I_CDSViewDetail

DDL: I_CDSVIEWDETAIL SQL: ICDSVIEWDTL Type: view BASIC
11 Fields 1 Data Sources

Metadata of CDS

I_CDSViewDetail is a Basic CDS View that provides data about "Metadata of CDS" in SAP S/4HANA. It reads from 1 data source (P_CDSVIEWATTR) and exposes 11 fields with key field EntSrchModelName.

Data Sources (1)

SourceAliasJoin Type
P_CDSVIEWATTR _CDSVIEWATTR from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICDSVIEWDTL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Metadata of CDS view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #META view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EntSrchModelName P_CDSVIEWATTR DDLName DDL Source Name
EntSrchModelApplComponent P_CDSVIEWATTR ApplicationComponentName
EntSrchModelApplComponentText P_CDSVIEWATTR ApplicationComponentText
EntSrchModelPackageName P_CDSVIEWATTR CDSPackage
CDSViewName P_CDSVIEWATTR CDSViewName CDS View Name
EntSrchModelLastChangedOnDate P_CDSVIEWATTR LastChangeDate Time Stamp
EntSrchLastChangedTime P_CDSVIEWATTR LastChangeTime Time changed
EntSrchModelLastChangedByUser P_CDSVIEWATTR LastChangeUser User Name
EntSrchModelSourceOrigin P_CDSVIEWATTR Origin Task Origin
EntSrchModelViewName P_CDSVIEWATTR SQLViewName View Name
EntSrchModelDescription P_CDSVIEWATTR ViewDescription Short text

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 I_CDSViewDetail.
-- 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: ICDSVIEWDTL

CREATE VIEW I_CDSViewDetail AS
SELECT
  _CDSVIEWATTR.DDLName AS EntSrchModelName,
  _CDSVIEWATTR.ApplicationComponentName AS EntSrchModelApplComponent,
  _CDSVIEWATTR.ApplicationComponentText AS EntSrchModelApplComponentText,
  _CDSVIEWATTR.CDSPackage AS EntSrchModelPackageName,
  _CDSVIEWATTR.CDSViewName AS CDSViewName,
  _CDSVIEWATTR.LastChangeDate AS EntSrchModelLastChangedOnDate,
  _CDSVIEWATTR.LastChangeTime AS EntSrchLastChangedTime,
  _CDSVIEWATTR.LastChangeUser AS EntSrchModelLastChangedByUser,
  _CDSVIEWATTR.Origin AS EntSrchModelSourceOrigin,
  _CDSVIEWATTR.SQLViewName AS EntSrchModelViewName,
  _CDSVIEWATTR.ViewDescription AS EntSrchModelDescription
FROM P_CDSVIEWATTR AS _CDSVIEWATTR
;

Learn More