I_MDCHANGEPROCESSPROGRESSRATIO

CDS View

MD Change Process Progress Ratio

I_MDCHANGEPROCESSPROGRESSRATIO is a CDS View in S/4HANA. MD Change Process Progress Ratio. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MDChangeProcessProgressRatio view_entity from CONSUMPTION MD Change Process Progress Ratio 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MD Change Process Progress Ratio'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_MDChangeProcessProgressRatio
  as select from I_MasterDataChangeProcess
  association [0..*] to C_MasterDataChangeProcessStep as _Step     on  _Step.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
  association [0..1] to I_MDChgProcPackageInformation as _Packages on  _Packages.MasterDataChangeProcess = $projection.MasterDataChangeProcess
                                                                   and _Packages.MDChgProcessStep        = $projection.MDChgProcessCurrentStepNumber


{
  key MasterDataChangeProcessUUID,
      MasterDataChangeProcess,
      MDChgProcessCurrentStepNumber,
      MDChgProcessStatus,
      MDChgProcessIsErased,
      count( distinct _Step.MDChgProcessStep )                                                                              as MDChangeProcessNumberOfSteps,
      sum( case when _Packages.MDChangeProcessPackageStatus = '' then 0 else _Packages.MDChgProcessNumberOfPackages end ) as MDChgProcessNumberOfPackages,
      sum( _Packages.MDChgProcessNumberOfPackages )                                                                         as MDChgProcTotalNumberOfPackages
}
group by
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessCurrentStepNumber,
  MDChgProcessStatus,
  MDChgProcessIsErased

Learn More