Cds_Views_Pkg_Appcomp

DDL: CDS_VIEWS_PKG_APPCOMP SQL: CDSPKGAPPCOMP Type: view
6 Fields 2 Data Sources

CDS Views Package and Application Component Info

Cds_Views_Pkg_Appcomp is a CDS View that provides data about "CDS Views Package and Application Component Info" in SAP S/4HANA. It reads from 2 data sources (tdevc, tadir) and exposes 6 fields with key field DDLSourceName.

Data Sources (2)

SourceAliasJoin Type
tdevc CDSAppComp inner
tadir CDSPackage from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDSPKGAPPCOMP view
EndUserText.label CDS Views Package and Application Component Info view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName tadir obj_name Object Name
CDSViewPackage tadir devclass Package (Obsolete)
CDSViewSourceSystem tadir srcsystem Source system
ApplicationComponent ApplicationComp ApplicationComponent
ApplicationComponentName ApplicationComp ApplicationComponentName
_CDSAppCompText ApplicationComp _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 Cds_Views_Pkg_Appcomp.
-- 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: CDSPKGAPPCOMP

CREATE VIEW Cds_Views_Pkg_Appcomp AS
SELECT
  CDSPackage.obj_name AS DDLSourceName,
  CDSPackage.devclass AS CDSViewPackage,
  CDSPackage.srcsystem AS CDSViewSourceSystem,
  ApplicationComp.ApplicationComponent AS ApplicationComponent,
  ApplicationComp.ApplicationComponentName AS ApplicationComponentName,
  ApplicationComp._Text AS _CDSAppCompText
FROM tadir AS CDSPackage
INNER JOIN tdevc AS CDSAppComp ON /* join condition not captured in parsed metadata */
;

Learn More