Ansicht
Dokumentation

ABENDBTAB_OVIEW - DBTAB OVIEW

Relational Databases

Application software models a part of the real world. This type of modeling is based on the relational data model. A data model describes reality using formal structures. In the relational data model, the only formal structure used is known as a relation or table. All the information about the modeled area of reality is represented as values in tables.

A table is a two-dimensional matrix which consists of rows and columns (fields). A field or combination of fields which uniquely identifies every row in a table is known as the key. This is a minimal attribute: if one of the fields is removed from the key, the remaining fields cannot uniquely identify the table rows.

Each table must have at least one table key (primary key integrity). However a table usually has multiple keys. During the modeling process, only one key is defined as the primary key.

In the relational model, the relationship between objects is expressed in terms of a foreign key. A combination of fields in a table is known as a foreign key, if it is also the primary key in another table.

In AS ABAP, the data model is managed in ABAP Dictionary:

• In ABAP Dictionary, database tables, views, and CDS entities are defined as platform-independent objects and, when activated, are usually given variants on the central AS ABAP database.

• The fields of database tables, views, and CDS entities are components of structures in ABAP Dictionary and are identified accordingly as structured types in ABAP programs.

• Open SQL statements can be used in ABAP programs to access database tables, views, and CDS entities from ABAP Dictionary directly and independently of the platform.