CDB_ALL_CDS_VIEWS

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 CDB_ALL_CDS_VIEWS.
-- 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.

CREATE VIEW CDB_ALL_CDS_VIEWS AS
SELECT
  ddldependency.objectname AS CDSName,
  ddddlsrc.ddlname AS DDLSourceName,
  ddddlsrct.ddtext AS CDSDescription,
  cast ( case VDMViewAnnotations.value when '#BASIC' then 'BASIC' when '#COMPOSITE' then 'COMPOSITE' when '#CONSUMPTION' then 'CONSUMPTION' when '#EXTENSION' then 'EXTENSION' else 'NA' end as abap.char(20) ) as CDSVDMViewType AS char20asCDSVDMViewType,
  cast ( case DataCtgAnnotations.value when '#FACT' then 'FACT' when '#DIMENSION' then 'DIMENSION' when '#CUBE' then 'CUBE' when '#AGGREGATIONLEVEL' then 'AGGREGATIONLEVEL' when '#TEXT' then 'TEXT' when '#HIERARCHY' then 'HIERARCHY' else 'UNDEFINED' end as abap.char(20) ) as CDSAnalyticsDataCategory AS char20asCDSAnalyticsDataCategory,
  ObjModDataCtgAnnotations.value AS CDSObjModelDataCategory,
  cast ( case DCLAnnotations.value when '#CHECK' then 'X' when '#MANDATORY' then 'X' else 'NA' end as abap.char(2) ) as CDSDCLAvailable AS char2asCDSDCLAvailable,
  DCLAnnotations.value AS CDSAccCtrlAuthChk,
  tadir.devclass AS CDSPackage,
  tadir.srcsystem AS CDSSrcSystem,
  df14l.ps_posid AS CDSApplComp,
  df14t.name AS CDSApplCompName,
  tdevc.dlvunit AS CDSDeliveryUnit,
  tdevc.pdevclass AS CDSTransportLayer,
  tdevc.packtype AS CDSPackageType,
  ReleasedViews.Contract AS CDSContract,
  ReleasedViews.UseInKeyUserApps AS CDSUsageKeyUsers,
  ReleasedViews.UseInSapCloudPlatform AS CDSUsageSCP,
  ReleasedViews.SoftwareReleaseName AS CDSSoftwareRelease
INNER JOIN ddldependency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS VDMViewAnnotations ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS DataCtgAnnotations ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS DCLAnnotations ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS ObjModDataCtgAnnotations ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_V_RELEASE_info AS ReleasedViews ON /* join condition not captured in parsed metadata */
;