SAP DDIC PROJECTION VIEWS



Get Example source ABAP code based on a different SAP table
  



ABAP_DDIC - Projection Views
A DDIC projection view is a DDIC table view that can be used to hide fields from a single basis table. No SQL view is created on the database. No selection conditions can be specified for a DDIC projection view.
The structure type defined by the view fields of the projection view can be referenced in ABAP programs using TYPE. A projection view can be accessed using AB_SQL but not using CDS views, Native SQL, or AMDP. The database interface transforms an AB-SQL statement that accesses a projection view to a platform-dependent SQL statement.
The Access setting in the maintenance status of a projection view can have the following values:
Read only The projection view can only be used to read data with AB_SQL .
Read, change, delete, and insert The projection view can be used to read or change data with AB_SQL .
When rows are inserted via DDIC projection views, all fields from the basis table that are not part of the DDIC view are given the type-specific initial value. This is done regardless of whether the field is defined as NOT NULL on the database.



Latest notes:

As in a DDIC database table, the client dependency of a DDIC projection view is determined by a column with the built-in dictionary type CLNT. This column must be the first column of the view.
Like a DDIC database table, the maintenance status of a projection view has a Display and Maintain setting alongside the Access setting. The setting must match the Access setting.
The basis table of a projection view can be a transparent table or a global temporary table.
ABAP_HINT_END



Example ABAP Coding

The projection view DEMO_SPFLI contains fields of the tables SPFLI . The view can be accessed as follows using AB_SQL :
ABEXA 00995
ABAP_EXAMPLE_END