I_MDChangeProcessProgressRatio

DDL: I_MDCHANGEPROCESSPROGRESSRATIO Type: view_entity Package: MDC_PROCESS_OBJECT

MD Change Process Progress Ratio

I_MDChangeProcessProgressRatio is a CDS View that provides data about "MD Change Process Progress Ratio" in SAP S/4HANA. It reads from 1 data source (I_MasterDataChangeProcess) and exposes 8 fields with key field MasterDataChangeProcessUUID. It has 2 associations to related views. Part of development package MDC_PROCESS_OBJECT.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcess I_MasterDataChangeProcess from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_MasterDataChangeProcessStep _Step _Step.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
[0..1] I_MDChgProcPackageInformation _Packages _Packages.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _Packages.MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MD Change Process Progress Ratio view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID
MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber
MDChgProcessStatus MDChgProcessStatus
MDChgProcessIsErased MDChgProcessIsErased
MDChangeProcessNumberOfSteps
MDChgProcessNumberOfPackages
MDChgProcTotalNumberOfPackages 
@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