Ansicht
Dokumentation

ABENDDIC_VIEWS - DDIC VIEWS

ABENDDIC_VIEWS - DDIC VIEWS

Vendor Master (General Section)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

- Views

A DDIC view is a grouping of columns in one or more DDIC database tables in accordance with an application-specific view. In AS ABAP, views are defined in ABAP Dictionary and can be referenced as data types in the same way as structures. Views can be used like database tables in reading and sometimes partly writing statements. For this reason, the ABAP DDIC views are in the same namespace as all types of the ABAP Dictionary and hence in the namespace of all global types of an AS ABAP.

The name of a view must follow the naming rules for DDIC views.

The data in a view is read from the DDIC database tables involved by the database and is not saved physically.

  • Views for a DDIC database table can be used to restrict database access to specific fields (projection) or to specific rows (selection).
  • Views for multiple DDIC database tables use joins or subqueries to join these tables and to read the required fields and rows.

The views in ABAP Dictionary are usually platform-independent. With some special exceptions, the views in ABAP Dictionary are, when activated, transformed into platform-dependent SQL views in the current standard AS ABAP database in the ABAP database schema. This is done using the DDL statement CREATE VIEW with the addition AS SELECT, which formulates the corresponding SELECT statement. The definition of a view in the database can be displayed in transaction SE11 by choosing Utilities → Database Object.

ABAP Dictionary manages the following categories of views:

In DDIC table views the platform-dependent DDL statement is created from the definition of the view in the form-based ABAP Dictionary tool.
A DDIC external view makes an SAP HANA view known in ABAP programs and makes it usable like a DDIC table view.

When a view is accessed using the statement SELECT, the SELECT statement defined in the DDL statement is executed and the result set is returned as if a SELECT were executed on a DDIC database table whose structure matches the structure defined by the view.

Notes

  • Views are usually defined in the implementation of data models in ABAP Dictionary and this is not usually the job of a regular ABAP application programmer. Once created, views are used in ABAP programs using statements and must be stable enough to allow this.
  • When making selections using views, it is also important that suitable indexes are created for the basis tables in the view.






General Material Data   General Material Data  
This documentation is copyright by SAP AG.

Length: 4779 Date: 20240329 Time: 123602     sap01-206 ( 67 ms )