CDS_VIEW_FIRST_REFERENCE

DDL: CDS_VIEW_FIRST_REFERENCE SQL: CDSVIEWFIRSTREF Type: view
4 Fields 2 Data Sources

Returns First View Reference

CDS_VIEW_FIRST_REFERENCE is a CDS View that provides data about "Returns First View Reference" in SAP S/4HANA. It reads from 2 data sources (Cds_View_Crossreference, Cds_View_First_Ref_Position) and exposes 4 fields.

Data Sources (2)

SourceAliasJoin Type
Cds_View_Crossreference A from
Cds_View_First_Ref_Position B inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDSVIEWFIRSTREF view
EndUserText.label Returns First View Reference view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
CreferredObject Cds_View_Crossreference CReferredObject
SqlViewName Cds_View_Crossreference SQLViewName View Name
CSQLViewName Cds_View_Crossreference CSQLViewName
ObjectDDLSourceName Cds_View_Crossreference ObjectDDLSourceName DDL Source Name

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_FIRST_REFERENCE.
-- 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: CDSVIEWFIRSTREF

CREATE VIEW CDS_VIEW_FIRST_REFERENCE AS
SELECT
  A.CReferredObject AS CreferredObject,
  A.SQLViewName AS SqlViewName,
  A.CSQLViewName AS CSQLViewName,
  A.ObjectDDLSourceName AS ObjectDDLSourceName
FROM Cds_View_Crossreference AS A
INNER JOIN Cds_View_First_Ref_Position AS B ON /* join condition not captured in parsed metadata */
;

Learn More