P_ChmlCmplncInfoAssmtCmbnd

DDL: P_CHMLCMPLNCINFOASSMTCMBND Type: view CONSUMPTION Package: EHFND_CNS_CCI

CCI assignments combined

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

3 data source(s) 14 fields

Data Sources (3)

SourceAliasJoin Type
I_ChmlCmplncInfo ChmlCmplncInfo from
I_CmplRqRslt CmplRqRslt inner
I_WorkViewAssgmt WorkViewAssgmt inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCIASSMTCM 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 assignments combined view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
CmplRqRsltUUID I_CmplRqRslt CmplRqRsltUUID
CmplRqVersUUID I_CmplRqRslt CmplRqVersUUID
ComplianceRequirement I_CmplRqRslt ComplianceRequirement
CmplRqRsltProcessingStatus I_CmplRqRslt CmplRqRsltProcessingStatus
Processor I_CmplRqRslt Processor
ReleasedByUser I_CmplRqRslt ReleasedByUser
CreationDateTime I_CmplRqRslt CreationDateTime
CmplRqPattern
CmplRqVersName
WorkViewGroupName
PCPrptySequence
WorkView I_WorkViewAssgmt WorkView
WorkViewUUID I_WorkViewAssgmt WorkViewUUID 
@AbapCatalog: {
  sqlViewName: 'PCCIASSMTCM',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'CCI assignments combined'
define view P_ChmlCmplncInfoAssmtCmbnd
  as select from I_ChmlCmplncInfo as ChmlCmplncInfo
    inner join   I_CmplRqRslt     as CmplRqRslt     on CmplRqRslt.ChmlCmplncInfoUUID = ChmlCmplncInfo.ChmlCmplncInfoUUID
    inner join   I_WorkViewAssgmt as WorkViewAssgmt on WorkViewAssgmt.ComplianceRequirement = CmplRqRslt.ComplianceRequirement
{
  key ChmlCmplncInfo.ChmlCmplncInfoUUID,
      CmplRqRslt.CmplRqRsltUUID,
      CmplRqRslt.CmplRqVersUUID,
      CmplRqRslt.ComplianceRequirement,
      CmplRqRslt.CmplRqRsltProcessingStatus,
      CmplRqRslt.Processor,
      CmplRqRslt.ReleasedByUser,      
      CmplRqRslt.CreationDateTime,
      CmplRqRslt._CmplRqVers.CmplRqPattern,
      CmplRqRslt._CmplRqVers.CmplRqVersName,

      WorkViewAssgmt._WorkViewGroup.WorkViewGroupName,
      
      WorkViewAssgmt._WorkViewGroup.PCPrptySequence,
      
      WorkViewAssgmt.WorkView,
      WorkViewAssgmt.WorkViewUUID
}
where
  CmplRqRslt.ComplianceRequirement is not initial

Learn More