CDS View Extension
Normal standard SAP tables can be extended with APPEND structure. Similarly standard CDS views can be extended with EXTEND View which works with the same principle as APPEND structure. There are also some restriction where the CDS view can’t be extended if the CDS base view contains GROUP BY clause, etc.
The below post shows how to extend a Z- CDS view with extend view (the same applies to the standard CDS view).
Below we have a CDS view with some fields from SPFLI table as shown below.
The underlying SQL view of the CDS view snapshot from SE11.
CDS View data preview( 8 columns)
The yellow color fields already added to the CDS view and we need to add the green color fields to the view as a part of extension view.
Create a Data Definition.
Choose Extend View option-
Provide the SQL View Append name and the CDS view name to be extended and the filed list. Activate the extend view.
Make a data preview of the base CDS view and it shows the CDS view fields as well as the extension view fields.
Open the SQL view APPEND in SE11.
It looks as below.
The base CDS view is appended with fields of the extend view fields.
The base SQL view looks as below-