P_CdsViewPkgAppComp

DDL: P_CDSVIEWPKGAPPCOMP SQL: PCDSPKGAPPCOMP Type: view BASIC Package: S_ESH_MSM

CDS Views Package and Application Component Info

P_CdsViewPkgAppComp is a Basic CDS View that provides data about "CDS Views Package and Application Component Info" in SAP S/4HANA. It reads from 3 data sources (P_ApplicationComponent, tdevc, tadir) and exposes 6 fields with key field DDLName. Part of development package S_ESH_MSM.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
P_ApplicationComponent ApplicationComp left_outer
tdevc CDSAppComp inner
tadir CDSPackage from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCDSPKGAPPCOMP 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.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #P view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DDLName tadir obj_name
CDSPackage tadir devclass
CreatedBy tadir author
ApplicationComponent P_ApplicationComponent ApplicationComponent
ApplicationComponentName P_ApplicationComponent ApplicationComponentName
ApplicationComponentText P_ApplicationComponent ApplicationComponentText 
@AbapCatalog.sqlViewName: 'PCDSPKGAPPCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'CDS Package and Application Component'


@ClientHandling.type: #CLIENT_INDEPENDENT
@ClientHandling.algorithm: #NONE

@VDM.viewType: #BASIC
@VDM.private: true

@ObjectModel.usageType.serviceQuality: #P

define view P_CdsViewPkgAppComp as select from tadir as CDSPackage

inner join tdevc as CDSAppComp 
on CDSPackage.devclass = CDSAppComp.devclass and CDSPackage.object = 'DDLS'

left outer join P_ApplicationComponent as ApplicationComp 
on CDSAppComp.component = ApplicationComp.ApplicationComponent {

  key CDSPackage.obj_name as DDLName,
  CDSPackage.devclass as CDSPackage,
  CDSPackage.author as CreatedBy,
  ApplicationComp.ApplicationComponent,
  ApplicationComp.ApplicationComponentName, 
  ApplicationComp.ApplicationComponentText
}

Learn More