Core Data Services (CDS) ABAP

Virtual Data Model (VDM)

SAP Virtual Data Model

VDM Example

Overview of views using the example of a sales order

How to Find SAP Views

Search in this order:

  1. Successors of the DB table in the Properties → API State (as of 2023)
  2. View Browser: Fiori App – https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F2170')/S25OP
  3. SAP Documentation: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/5418de55938d1d22e10000000a44147b.html
  4. Google, if link is broken or you are on another release
  5. Where-used list

Search for Released Views

filter for API State

  • type:ddls → filter for CDS Views and View Entities
  • api:use_in_cloud_development → direct filter for the correct C1 release state

Naming Conventions

(See SAP Documentation)

Prefixes

  • I_Entity: Interface Views
    • Basic Views: 1:1 representation of DB tables
    • Composite Views: Combination of I-Views
  • R_Entity: Re-Use View – based on an I_View (optional)
  • C_Entity: Consumption Views – in RAP: projection of the R-View for the UI
  • A_Entity: For Web APIs
  • P_Entity: Private Views – only for SAP internal usage
  • E_: Extension-Includes
  • X_: Extensions

Suffixes

  • Qry or Query – Analytical Query Views
  • Cube – Cube Views
  • Text – Text Views
  • TP – Views for RAP objects (Transactional Processing)
  • VH – Value Helps
  • DEX – Extractors