P_ChmlCmplncInfoCmpstnCmbnd

DDL: P_CHMLCMPLNCINFOCMPSTNCMBND Type: view CONSUMPTION Package: EHFND_CNS_CCI

CCI Composition Combined

P_ChmlCmplncInfoCmpstnCmbnd is a Consumption CDS View that provides data about "CCI Composition Combined" in SAP S/4HANA. It reads from 3 data sources (P_AssociatedProductComposition, I_ChmlCmplncInfo, I_WorkViewAssgmt) and exposes 11 fields with key field ChmlCmplncInfoUUID. Part of development package EHFND_CNS_CCI.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
P_AssociatedProductComposition AssociatedProductComposition inner
I_ChmlCmplncInfo ChmlCmplncInfo from
I_WorkViewAssgmt WorkViewAssgmt inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCICOMPCMB 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 Composition Combined view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
ChmlCompositionUUID P_AssociatedProductComposition ChmlCmpstnNavgnLinkUUID
ChmlCmpstnInProcStatus P_AssociatedProductComposition ChmlCmpstnInProcStatus
ChmlCmpstnReldStatus P_AssociatedProductComposition ChmlCmpstnReldStatus
ReleasedByUser P_AssociatedProductComposition ReleasedByUser
ChmlCompositionType P_AssociatedProductComposition ChmlCompositionType
ProdCmplncLegalArea P_AssociatedProductComposition ProdCmplncLegalArea
WorkViewGroupName
PCPrptySequence
WorkView I_WorkViewAssgmt WorkView
WorkViewUUID I_WorkViewAssgmt WorkViewUUID 
@AbapCatalog: {
  sqlViewName: 'PCCICOMPCMB',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

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

@EndUserText.label: 'CCI Composition Combined'
define view P_ChmlCmplncInfoCmpstnCmbnd
  as select from I_ChmlCmplncInfo               as ChmlCmplncInfo

  //    inner join   I_ChmlCompositionTP as ChmlComposition on ChmlComposition.ChmlCmplncInfoUUID = ChmlCmplncInfo.ChmlCmplncInfoUUID

    inner join   P_AssociatedProductComposition as AssociatedProductComposition on AssociatedProductComposition.ChmlCmplncInfoUUID = ChmlCmplncInfo.ChmlCmplncInfoUUID
    inner join   I_WorkViewAssgmt               as WorkViewAssgmt               on WorkViewAssgmt.WorkViewComposition = AssociatedProductComposition.ChmlCompositionType                                                                        
                                                                                and WorkViewAssgmt.ProdCmplncLegalArea = AssociatedProductComposition.ProdCmplncLegalArea
{
  key ChmlCmplncInfo.ChmlCmplncInfoUUID,
     
      AssociatedProductComposition.ChmlCmpstnNavgnLinkUUID as ChmlCompositionUUID,
      AssociatedProductComposition.ChmlCmpstnInProcStatus,
      AssociatedProductComposition.ChmlCmpstnReldStatus,
      AssociatedProductComposition.ReleasedByUser,
      AssociatedProductComposition.ChmlCompositionType,
      AssociatedProductComposition.ProdCmplncLegalArea,                                                          
      
      WorkViewAssgmt._WorkViewGroup.WorkViewGroupName,
      //WorkViewAssgmt.ChmlCompositionType,

    //  WorkViewAssgmt.WorkViewComposition as ProdCmplncLegalArea,

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

Learn More