ABAP Database Access
All the data relevant for all applications in AS ABAP, including metadata and technical data, is saved and managed centrally in the standard database. AS ABAP supports database systems from different vendors. The database objects used as data repositories and to access this data, such as database tables, database views, or stored procedures, are created as platform-specific objects by the ABAP-specific frameworks ABAP Dictionary (including ABAP CDS) and AMDP and are in the ABAP database schema.
- In ABAP Dictionary, database tables, views, and non-abstract CDS entities are defined as platform-independent objects. Instances of these objects are created in the ABAP database schema when they are activated. At the same time, database tables, views, and CDS entities defined in ABAP Dictionary are also structures in ABAP Dictionary and can be used as globally visible structured types in ABAP programs.
- The AMDP framework makes it possible to create ABAP-based definitions of AMDP procedures and AMDP functions in the ABAP database schema. In ABAP, they are called using either method calls or, in the case of CDS table functions, using ABAP SQL.
All database objects defined and managed in AS ABAP are known as:
To enable access to database objects, every database system uses the largely standardized language SQL, which can be implemented in different ways to suit specific platforms. The following is possible when accessing ABAP-managed database objects:
- Using the object-oriented framework ADBC
- Using embedded Native SQL statements after the ABAP statement
The following topics also deal with important aspects of database access:
- If a SAP HANA database is used as the standard AS ABAP database, it is handled in ABAP programs like any relational database.
- As well as the statements described here for database reads, the following are also available:
- Access to data clusters in database tables
- The framework for logical databases is an obsolete wrapper framework for database access.
- ABAP-managed database objects should not be accessed using any methods other than those described here.