I_ChmlCmplncReqRelevantStep

DDL: I_CHMLCMPLNCREQRELEVANTSTEP Type: view_entity COMPOSITE Package: EHFND_BO_CRQ

Relevant Step for a Compliance Request

I_ChmlCmplncReqRelevantStep is a Composite CDS View that provides data about "Relevant Step for a Compliance Request" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncReq) and exposes 12 fields with key fields ChmlCmplncRequestUUID, CmplncReqDialogSectionID. Part of development package EHFND_BO_CRQ.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncReq ComplianceRequest from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Relevant Step for a Compliance Request view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncRequestUUID I_ChmlCmplncReq ChmlCmplncRequestUUID
KEY CmplncReqDialogSectionID ConfigurationStep CmplncReqDialogSectionID
CmplncReqBusinessProcess ConfigurationStep CmplncReqBusinessProcess
CmplncReqDialogSectionMode ConfigurationStep CmplncReqDialogSectionMode
CmplncReqReason ConfigurationStep CmplncReqReason
CmplncReqReasonDetailAlias ConfigurationStep CmplncReqReasonDetailAlias
CmplncReqSolutionArea ConfigurationStep CmplncReqSolutionArea
CmplncReqStepSequenceNumber ConfigurationStep CmplncReqStepSequenceNumber
CmplncRequestStepIsCompleted StepInstance CmplncRequestStepIsCompleted
ChmlCmplncReqStepProcessorUser StepInstance ChmlCmplncReqStepProcessorUser
ChmlCmplncInfoUUID I_ChmlCmplncReq ChmlCmplncInfoUUID
_ChmlCmplncInfo I_ChmlCmplncReq _ChmlCmplncInfo 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Relevant Step for a Compliance Request'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_ChmlCmplncReqRelevantStep
  as select from           I_ChmlCmplncReq             as ComplianceRequest
    join                   I_ChmlCmplncReqReasonDetail as ReasonDetail      on ReasonDetail.CmplncReqReasonDetailConcept = ComplianceRequest.ChmlCmplncReqDetails
    join                   I_ChmlCmplncReqConfignStep  as ConfigurationStep on  ConfigurationStep.CmplncReqBusinessProcess   = ComplianceRequest.ChmlCmplncBusinessProcess
                                                                            and ConfigurationStep.CmplncReqReason            = ComplianceRequest.ChmlCmplncReqOriginProc
                                                                            and ConfigurationStep.CmplncReqSolutionArea      = ComplianceRequest.ChmlCmplncReqCmplncProc
                                                                            and ConfigurationStep.CmplncReqReasonDetailAlias = ReasonDetail.CmplncReqReasonDetailAlias
    left outer to one join I_ChmlCmplncReqStep         as StepInstance      on  StepInstance.ChmlCmplncRequestUUID    = ComplianceRequest.ChmlCmplncRequestUUID
                                                                            and StepInstance.CmplncReqDialogSectionID = ConfigurationStep.CmplncReqDialogSectionID
{
  key ComplianceRequest.ChmlCmplncRequestUUID,
  key ConfigurationStep.CmplncReqDialogSectionID,
      ConfigurationStep.CmplncReqBusinessProcess,
      ConfigurationStep.CmplncReqDialogSectionMode,
      ConfigurationStep.CmplncReqReason,
      ConfigurationStep.CmplncReqReasonDetailAlias,
      ConfigurationStep.CmplncReqSolutionArea,
      ConfigurationStep.CmplncReqStepSequenceNumber,
      StepInstance.CmplncRequestStepIsCompleted,
      StepInstance.ChmlCmplncReqStepProcessorUser,
      
      // Needed for Auth Check

      ComplianceRequest.ChmlCmplncInfoUUID,      
      /* Associations */
      ComplianceRequest._ChmlCmplncInfo
}

Learn More