Cds_View_Crossreference

DDL: CDS_VIEW_CROSSREFERENCE SQL: CDSVIEWCROSSREF Type: view
10 Fields 3 Data Sources

CDS View CrossReference

Cds_View_Crossreference is a CDS View that provides data about "CDS View CrossReference" in SAP S/4HANA. It reads from 3 data sources (ddldependency, dd26s, ddldependency) and exposes 10 fields with key fields SQLViewName, ReferredObject, ViewPosition.

Data Sources (3)

SourceAliasJoin Type
ddldependency currentObject left_outer
dd26s dd26s from
ddldependency referrencedObject left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDSVIEWCROSSREF view
EndUserText.label CDS View CrossReference view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SQLViewName dd26s viewname View Name
KEY ReferredObject dd26s tabname Table/Constant Value
KEY ViewPosition dd26s tabpos Position in a repetition group
ReferredObjectType _ReferredObjectType tabclass Table Category
ReferredObjectDDLSourceName ddldependency ddlname DDL Source Name
ObjectDDLSourceName ddldependency ddlname DDL Source Name
_ReferredTableDescription _ReferredTableDescription
_ReferredViewDescription _ReferredViewDescription
CReferredObject
CSQLViewName

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 Cds_View_Crossreference.
-- 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: CDSVIEWCROSSREF

CREATE VIEW Cds_View_Crossreference AS
SELECT
  dd26s.viewname AS SQLViewName,
  dd26s.tabname AS ReferredObject,
  dd26s.tabpos AS ViewPosition,
  _ReferredObjectType.tabclass AS ReferredObjectType,
  referrencedObject.ddlname AS ReferredObjectDDLSourceName,
  currentObject.ddlname AS ObjectDDLSourceName,
  concat('2C',dd26s.tabname) AS CReferredObject,
  concat('2C',dd26s.viewname) AS CSQLViewName
FROM dd26s
LEFT OUTER JOIN ddldependency AS referrencedObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddldependency AS currentObject ON /* join condition not captured in parsed metadata */
;

Learn More