CDS_VIEW_CROSSREF_QUERY

DDL: CDS_VIEW_CROSSREF_QUERY SQL: CDSCROSSREFQUERY Type: view
6 Fields 3 Data Sources

Referenced Objects of CDS View

CDS_VIEW_CROSSREF_QUERY is a CDS View that provides data about "Referenced Objects of CDS View" in SAP S/4HANA. It reads from 3 data sources (VB_CDS_CROSSREFERENCE, ddheadanno, dd02b) and exposes 6 fields with key field DDLSourceName.

Data Sources (3)

SourceAliasJoin Type
VB_CDS_CROSSREFERENCE Cds_View_Crossreference from
ddheadanno CDSPrivate left_outer
dd02b dd02b left_outer

Parameters (1)

NameTypeDefault
P_DDLSourceName abap.char( 30 )

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CDSCROSSREFQUERY view
EndUserText.label Referenced Objects of CDS View view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName VB_CDS_CROSSREFERENCE ObjectDDLSourceName DDL Source Name
ReferredObjectDDLSourceName VB_CDS_CROSSREFERENCE ReferredObjectDDLSourceName DDL Source Name
ReferredObjectText dd02b strucobjn_raw DD: Original Name of a Struct. Obj. (e.g. Entity, Context)
ddtextendasReferredObjectDescription
ddtextendasReferredObjectDescSearch
CanNavigateToReferredObject

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_CROSSREF_QUERY.
-- 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: CDSCROSSREFQUERY
-- Parameters: P_DDLSourceName : abap.char( 30 )

CREATE VIEW CDS_VIEW_CROSSREF_QUERY AS
SELECT
  Cds_View_Crossreference.ObjectDDLSourceName AS DDLSourceName,
  Cds_View_Crossreference.ReferredObjectDDLSourceName AS ReferredObjectDDLSourceName,
  dd02b.strucobjn_raw AS ReferredObjectText,
  case Cds_View_Crossreference.ReferredObjectType when 'VIEW' then Cds_View_Crossreference._ReferredViewDescription[ddlanguage = $session.system_language ].ddtext else Cds_View_Crossreference._ReferredTableDescription[ddlanguage = $session.system_language ].ddtext end as ReferredObjectDescription AS ddtextendasReferredObjectDescription,
  case Cds_View_Crossreference.ReferredObjectType when 'VIEW' then upper(Cds_View_Crossreference._ReferredViewDescription[ddlanguage = $session.system_language ].ddtext) else upper(Cds_View_Crossreference._ReferredTableDescription[ddlanguage = $session.system_language ].ddtext) end as ReferredObjectDescSearch AS ddtextendasReferredObjectDescSearch,
  'X' AS CanNavigateToReferredObject
FROM VB_CDS_CROSSREFERENCE AS Cds_View_Crossreference
LEFT OUTER JOIN dd02b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS CDSPrivate ON /* join condition not captured in parsed metadata */
;

Learn More