Replacement Object Principle

A CDS view can be defined as a replacement object for a database table or a classic database view in ABAP Dictionary.

If a replacement object has been assigned, any read access via Open SQL statement SELECT will be redirected to the replacement object.

Replacement object only takes effect for reading accesses. Any write access to the table is not redirected.

Prerequisites for Replacement Objects

Assigning a Replacement Object

In order to make a CDS view the replacement object for a table or classical Dictionary view, proceed as follows:

1. Open the table definition or Dictionary view
2. From the menu, choose Extras -> Proxy object….
3. On the dialog box, enter the name of the CDS View
4. Choose Apply

If you define a replacement object for the first time, the system checks whether the specified CDS view meets the perquisites. If a CDS view used as a replacement object is changed later and the perquisites are no longer met, a runtime error DBSQL_REDIRECT_INCONSISTENCY occurs.

Application Scenarios for Replacement Objects