Ansicht
Dokumentation

ABENABAP_MANAGED_DB_OBJECTS_OVIEW - ABAP MANAGED DB OBJECTS OVIEW

ABENABAP_MANAGED_DB_OBJECTS_OVIEW - ABAP MANAGED DB OBJECTS OVIEW

CPI1466 during Backup   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book

Overview of ABAP-Managed Database Objects

ABAP-managed database objects can be the following:

  • The name of the database table on the database matches the name of the table in the ABAP Dictionary.

  • The key fields defined in the ABAP Dictionary are the primary key of the database table on the database.

  • The indexes defined in the ABAP Dictionary are created on the database.

  • The order of the fields in the ABAP Dictionary does not need to match the order and on the database.

  • The database object of a DDIC database view is implemented as an SQL view using a platform-dependent database statement CREATE VIEW, which is itself based on the definition of the DDIC database view in the ABAP Dictionary.

  • The name of the view on the database matches the name of the table in the ABAP Dictionary.

  • The key fields of a DDIC database view defined in the ABAP Dictionary are ignored on the database.

  • Instance of a CDS view defined in ABAP CDS.
  • In CDS views that are not defined with the addition ENTITY of the statement DEFINE VIEW, an additional CDS-managed DDIC view is created in the ABAP Dictionary whose name is specified in the definition of the CDS view with the annotation @AbapCatalog.sqlViewName. The same applies as to DDIC database views, where instances of CDS views with input parameters can also be created as database functions using CREATE FUNCTION, depending on the database platform, as is currently the case on SAP HANA databases.

  • In CDS views defined using the statement DEFINE VIEW ENTITY, an identically named SQL view or a database function on the database is created directly from the definition of the CDS entity.

  • The name of an AMDP-managed database procedure is CLASS=>METH, where CLASS is the AMDP class and METH is the AMDP method.

  • The parameter interface of an AMDP-managed database procedure is generated as a platform-dependent interface from the parameter interface of the AMDP method.

  • Instances of CDS hierarchies are created as special views on the database, which access a built-in hierarchy function on the database.

  • The name of the view on the database matches the name of the CDS hierarchy.

  • Instances of ABAP-specific session variables

  • On other database platforms, these ABAP-specific session variables exist only when CDS views are accessed using .

  • Instances of dependency rules defined in ABAP Dictionary on the SAP HANA database.

In addition to the database objects themselves, their definitions in the AS ABAP framework cover further attributes described using metadata that are not known to the database. The most important of these attributes are:

  • Use as data types
  • The database tables and DDIC database views in the ABAP Dictionary can be used in the ABAP Dictionary itself and as structured types in ABAP programs.

In the ABAP Dictionary, the data types of the components of the database tables and views are based on built-in dictionary types. These types are an ABAP-specific wrapper of the actual database types and have ABAP-specific properties.
  • Client dependency

  • Table buffering
  • In ABAP Dictionary, it is possible to define whether and how table buffering takes place for database tables and DDIC database views.

  • Enhancements

  • The enhancement of CDS views is defined by the annotation @AbapCatalog.viewEnhancementCategory.

  • Foreign key dependencies

  • Logging
  • Logging can be enabled in the ABAP Dictionary for database tables.

  • Access control

  • Reference fields
  • For table fields or view fields with the built-in data types CURR and QUAN, reference fields of the types CUKY and UNIT must be defined in the ABAP Dictionary.

  • Translatable texts
  • For database tables and DDIC database views, translatable short texts and documentation can be created in the ABAP Dictionary.

In AS ABAP, the database objects managed by the ABAP Dictionary, ABAP CDS, and AMDP are represented by repository objects that have a package interface to the Change and Transport System (CTS). The actual database objects are created and modified using internal DDL statements and the AS ABAP database interface.

The ABAP Dictionary, ABAP CDS, and AMDP frameworks, together with the Change and Transport System (CTS), ensure that complete and consistent ABAP-managed database objects are available to be accessed from AS ABAP.

Note

The overview above does not contain any database objects created by AS ABAP on the database for purely technical reasons and which should therefore never be accessed. Examples are database objects in the AMDP framework that are part of the framework itself, unlike AMDP procedures and AMDP functions.






ROGBILLS - Synchronize billing plans   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 16617 Date: 20240328 Time: 194139     sap01-206 ( 155 ms )