Cds_Views_Pkg_Appcomp

DDL: CDS_VIEWS_PKG_APPCOMP SQL: CDSPKGAPPCOMP Type: view Package: S_DICT_VB

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. Part of development package S_DICT_VB.

2 data source(s) 6 fields

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
CDSViewPackage tadir devclass
CDSViewSourceSystem tadir srcsystem
ApplicationComponent ApplicationComp ApplicationComponent
ApplicationComponentName ApplicationComp ApplicationComponentName
_CDSAppCompText ApplicationComp _Text 
@AbapCatalog.sqlViewName: 'CDSPKGAPPCOMP'
@EndUserText.label: 'CDS Views Package and Application Component Info'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_Views_Pkg_Appcomp as select from tadir as CDSPackage

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

left outer to one join Application_Component as ApplicationComp 
on CDSAppComp.component = ApplicationComp.ApplicationComponent {

  key CDSPackage.obj_name as DDLSourceName,
  CDSPackage.devclass as CDSViewPackage,
  CDSPackage.srcsystem as CDSViewSourceSystem,
  ApplicationComp.ApplicationComponent,
  ApplicationComp.ApplicationComponentName,
  ApplicationComp._Text as _CDSAppCompText
}  where CDSPackage.object = 'DDLS'

Learn More