sadl_v_cds_view

DDL: SADL_V_CDS_VIEW SQL: SADL_V_CDS_SQL Type: view Package: SADL_ENTITY
4 Fields 1 Data Sources

Test View

sadl_v_cds_view is a CDS View that provides data about "Test View" in SAP S/4HANA. It reads from 1 data source (sbook) and exposes 4 fields with key field carrier. Part of development package SADL_ENTITY.

Data Sources (1)

SourceAliasJoin Type
sbook sbook from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SADL_V_CDS_SQL view
OData.entitySet.name SADL_CDS_ExternalName view

Fields (4)

KeyFieldSource TableSource FieldDescription
mandt sbook mandt Editing Client
KEY carrier sbook carrid Carrier
bookid sbook bookid Booking number
connid sbook connid Flight Number

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view sadl_v_cds_view.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SADL_V_CDS_SQL

CREATE VIEW sadl_v_cds_view AS
SELECT
  sbook.mandt AS mandt,
  sbook.carrid AS carrier,
  sbook.bookid AS bookid,
  sbook.connid AS connid
FROM sbook
;

Learn More