P_ChmlCmplncInfoPrptyCmbnd

DDL: P_CHMLCMPLNCINFOPRPTYCMBND Type: view CONSUMPTION

CCI Property Combined

P_ChmlCmplncInfoPrptyCmbnd is a Consumption CDS View that provides data about "CCI Property Combined" in SAP S/4HANA. It reads from 3 data sources (I_ChmlCmplncInfo, P_ChmlCmplncInfoAssgdPCPrpty, P_WorkViewAssgmtPrptyRootType) and exposes 10 fields with key field ChmlCmplncInfoUUID.

3 data source(s) 10 fields

Data Sources (3)

SourceAliasJoin Type
I_ChmlCmplncInfo ChmlCmplncInfo from
P_ChmlCmplncInfoAssgdPCPrpty ChmlCmplncInfoAssgdPCPrpty inner
P_WorkViewAssgmtPrptyRootType WorkViewAssgmtPrptyRootType inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCIPROPCMB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CCI Property Combined view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
PCPrptyRootType P_ChmlCmplncInfoAssgdPCPrpty PCPrptyRootType
PCPrptyInProcProcgSts P_ChmlCmplncInfoAssgdPCPrpty PCPrptyInProcProcgSts
PCPrptyReldProcgSts P_ChmlCmplncInfoAssgdPCPrpty PCPrptyReldProcgSts
PCPrptyNavgnLinkUUID P_ChmlCmplncInfoAssgdPCPrpty PCPrptyNavgnLinkUUID
ReleasedByUser P_ChmlCmplncInfoAssgdPCPrpty ReleasedByUser
WorkViewGroupName
PCPrptySequence
WorkView P_WorkViewAssgmtPrptyRootType WorkView
WorkViewUUID P_WorkViewAssgmtPrptyRootType WorkViewUUID 
@AbapCatalog: {
  sqlViewName: 'PCCIPROPCMB',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'CCI Property Combined'
define view P_ChmlCmplncInfoPrptyCmbnd
  as select from I_ChmlCmplncInfo              as ChmlCmplncInfo

    inner join   P_ChmlCmplncInfoAssgdPCPrpty  as ChmlCmplncInfoAssgdPCPrpty  on ChmlCmplncInfoAssgdPCPrpty.ChmlCmplncInfoUUID = ChmlCmplncInfo.ChmlCmplncInfoUUID
    inner join   P_WorkViewAssgmtPrptyRootType as WorkViewAssgmtPrptyRootType on WorkViewAssgmtPrptyRootType.WorkViewProperty = ChmlCmplncInfoAssgdPCPrpty.PCPrptyRootType

{
  key ChmlCmplncInfo.ChmlCmplncInfoUUID,


      ChmlCmplncInfoAssgdPCPrpty.PCPrptyRootType,
      ChmlCmplncInfoAssgdPCPrpty.PCPrptyInProcProcgSts,
      ChmlCmplncInfoAssgdPCPrpty.PCPrptyReldProcgSts,
      ChmlCmplncInfoAssgdPCPrpty.PCPrptyNavgnLinkUUID,

      ChmlCmplncInfoAssgdPCPrpty.ReleasedByUser,

      WorkViewAssgmtPrptyRootType._WorkViewGroup.WorkViewGroupName,

      WorkViewAssgmtPrptyRootType._WorkViewGroup.PCPrptySequence as PCPrptySequence,
      WorkViewAssgmtPrptyRootType.WorkView,
      WorkViewAssgmtPrptyRootType.WorkViewUUID
      
      
}

Learn More