P_CDSVIEWATTR

DDL: P_CDSVIEWATTR SQL: PCDSVIEWATTR Type: view BASIC
12 Fields 5 Data Sources

P_CDSVIEWATTR is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (P_CdsViewPkgAppComp, ddddlsrc02bt, ddldependency, ddldependency, ddddlsrc) and exposes 12 fields with key field DDLName.

Data Sources (5)

SourceAliasJoin Type
P_CdsViewPkgAppComp _CdsViewPkgAppComp left_outer
ddddlsrc02bt _TXTSRC left_outer
ddldependency CDSSQLVIEW left_outer
ddldependency CDSVIEW inner
ddddlsrc DDL from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCDSVIEWATTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_INDEPENDENT view
ClientHandling.algorithm #NONE view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #P view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DDLName ddddlsrc ddlname DDL Source Name
LastChangeUser ddddlsrc as4user Person Respons.
LastChangeDate ddddlsrc as4date Date
LastChangeTime ddddlsrc as4time Time
Origin ddddlsrc source_origin Source Origin
SQLViewName ddldependency objectname Object name
CDSViewName ddldependency objectname Object name
ViewDescription ddddlsrc02bt ddtext Short text
ApplicationComponent P_CdsViewPkgAppComp ApplicationComponent
ApplicationComponentName P_CdsViewPkgAppComp ApplicationComponentName
ApplicationComponentText P_CdsViewPkgAppComp ApplicationComponentText
CDSPackage P_CdsViewPkgAppComp CDSPackage Package (Obsolete)

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_CDSVIEWATTR.
-- 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: PCDSVIEWATTR

CREATE VIEW P_CDSVIEWATTR AS
SELECT
  DDL.ddlname AS DDLName,
  DDL.as4user AS LastChangeUser,
  DDL.as4date AS LastChangeDate,
  DDL.as4time AS LastChangeTime,
  DDL.source_origin AS Origin,
  CDSSQLVIEW.objectname AS SQLViewName,
  CDSVIEW.objectname AS CDSViewName,
  _TXTSRC.ddtext AS ViewDescription,
  _CdsViewPkgAppComp.ApplicationComponent AS ApplicationComponent,
  _CdsViewPkgAppComp.ApplicationComponentName AS ApplicationComponentName,
  _CdsViewPkgAppComp.ApplicationComponentText AS ApplicationComponentText,
  _CdsViewPkgAppComp.CDSPackage AS CDSPackage
FROM ddddlsrc AS DDL
LEFT OUTER JOIN ddldependency AS CDSSQLVIEW ON /* join condition not captured in parsed metadata */
INNER JOIN ddldependency AS CDSVIEW ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CdsViewPkgAppComp AS _CdsViewPkgAppComp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrc02bt AS _TXTSRC ON /* join condition not captured in parsed metadata */
;

Learn More