P_CDSVIEW

DDL: P_CDSVIEW SQL: PCDSVIEW Type: view
13 Fields 2 Data Sources 2 Associations

P_CDSVIEW is a CDS View in SAP S/4HANA. It reads from 2 data sources (P_CDSHEADERANNOTATIONS, P_CDSVIEWATTR) and exposes 13 fields with key field DDLName. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_CDSHEADERANNOTATIONS _CDSHEADERANNOTATIONSX left_outer
P_CDSVIEWATTR _CDSVIEWATTR from

Associations (2)

CardinalityTargetAliasCondition
[1..*] P_CDSHEADERANNOTATIONS _CDSHEADERANNOTATIONS _CDSVIEWATTR.DDLName = _CDSHEADERANNOTATIONS.DDLName
[1..*] P_CDSFIELDANNOTATIONS _CDSFIELDANNOTATIONS _CDSVIEWATTR.DDLName = _CDSFIELDANNOTATIONS.DDLName

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCDSVIEW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_INDEPENDENT view
ClientHandling.algorithm #NONE view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #META view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DDLName P_CDSVIEWATTR DDLName DDL Source Name
ApplicationComponentName P_CDSVIEWATTR ApplicationComponentName
ApplicationComponentText P_CDSVIEWATTR ApplicationComponentText
CDSPackage P_CDSVIEWATTR CDSPackage
CDSViewName P_CDSVIEWATTR CDSViewName CDS View Name
LastChangeDate P_CDSVIEWATTR LastChangeDate Time Stamp
LastChangeTime P_CDSVIEWATTR LastChangeTime Time changed
LastChangeUser P_CDSVIEWATTR LastChangeUser User Name
Origin P_CDSVIEWATTR Origin Task Origin
SQLViewName P_CDSVIEWATTR SQLViewName View Name
ViewDescription P_CDSVIEWATTR ViewDescription Short text
_CDSHEADERANNOTATIONS _CDSHEADERANNOTATIONS
_CDSFIELDANNOTATIONS _CDSFIELDANNOTATIONS

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 P_CDSVIEW.
-- 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: PCDSVIEW

CREATE VIEW P_CDSVIEW AS
SELECT
  _CDSVIEWATTR.DDLName AS DDLName,
  _CDSVIEWATTR.ApplicationComponentName AS ApplicationComponentName,
  _CDSVIEWATTR.ApplicationComponentText AS ApplicationComponentText,
  _CDSVIEWATTR.CDSPackage AS CDSPackage,
  _CDSVIEWATTR.CDSViewName AS CDSViewName,
  _CDSVIEWATTR.LastChangeDate AS LastChangeDate,
  _CDSVIEWATTR.LastChangeTime AS LastChangeTime,
  _CDSVIEWATTR.LastChangeUser AS LastChangeUser,
  _CDSVIEWATTR.Origin AS Origin,
  _CDSVIEWATTR.SQLViewName AS SQLViewName,
  _CDSVIEWATTR.ViewDescription AS ViewDescription
FROM P_CDSVIEWATTR AS _CDSVIEWATTR
LEFT OUTER JOIN P_CDSHEADERANNOTATIONS AS _CDSHEADERANNOTATIONSX ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CDSHEADERANNOTATIONS AS _CDSHEADERANNOTATIONS ON _CDSVIEWATTR.DDLName = _CDSHEADERANNOTATIONS.DDLName  -- association [1..*]
LEFT OUTER JOIN P_CDSFIELDANNOTATIONS AS _CDSFIELDANNOTATIONS ON _CDSVIEWATTR.DDLName = _CDSFIELDANNOTATIONS.DDLName  -- association [1..*]
;

Learn More