I_EntSrchCDSModelPckgCompDet

DDL: I_ENTSRCHCDSMODELPCKGCOMPDET SQL: IENTSRCHPCKGCOMP Type: view BASIC Package: S_ESH_MSM

CDS View for Package and Application component details

I_EntSrchCDSModelPckgCompDet is a Basic CDS View that provides data about "CDS View for Package and Application component details" in SAP S/4HANA. It reads from 3 data sources (P_ApplicationComponent, tdevc, tadir) and exposes 5 fields with key field EntSrchModelName. Part of development package S_ESH_MSM.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
P_ApplicationComponent ApplicationComp left_outer
tdevc CDSAppComp inner
tadir CDSPackage from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IENTSRCHPCKGCOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View for Package and Application component details view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EntSrchModelName tadir obj_name
EntSrchModelPackageName tadir devclass
EntSrchModelCreatedByUser tadir author
EntSrchModelApplComponent P_ApplicationComponent ApplicationComponentName
EntSrchModelApplComponentText P_ApplicationComponent ApplicationComponentText 
@AbapCatalog.sqlViewName: 'IENTSRCHPCKGCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS View for Package and Application component details'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #L,
    usageType.dataClass: #META
}
define view I_EntSrchCDSModelPckgCompDet 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 EntSrchModelName,
  CDSPackage.devclass as EntSrchModelPackageName,
  CDSPackage.author as EntSrchModelCreatedByUser,
  ApplicationComp.ApplicationComponentName as EntSrchModelApplComponent, 
  ApplicationComp.ApplicationComponentText as EntSrchModelApplComponentText
}

Learn More