C_MDChangeProcessProgressRatio

DDL: C_MDCHANGEPROCESSPROGRESSRATIO Type: view_entity CONSUMPTION Package: MDC_PROCESS_OBJECT

MD Change Process Progress Ratio

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

Data Sources (1)

SourceAliasJoin Type
I_MDChangeProcessProgressRatio I_MDChangeProcessProgressRatio from

Annotations (4)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID
MDChangeProcessNumberOfSteps MDChangeProcessNumberOfSteps
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MD Change Process Progress Ratio'
@Metadata.ignorePropagatedAnnotations: true
@VDM:           {viewType:           #CONSUMPTION}
define view entity C_MDChangeProcessProgressRatio
  as select from I_MDChangeProcessProgressRatio
{
  key MasterDataChangeProcessUUID,
      MDChangeProcessNumberOfSteps,
      case
        when MDChgProcessStatus = 'F' or MDChgProcessIsErased = 'X'
          then 100
        when MDChgProcessStatus = 'S' or MDChangeProcessNumberOfSteps = 0
          then 0
        when MDChgProcTotalNumberOfPackages is null or MDChgProcTotalNumberOfPackages = 0
          then division( cast(MDChgProcessCurrentStepNumber as abap.int2), MDChangeProcessNumberOfSteps , 2) * 100
        else
          division(
            ( cast(MDChgProcessCurrentStepNumber as abap.int2) - 1 ) + division( MDChgProcessNumberOfPackages, MDChgProcTotalNumberOfPackages, 2 ),
              MDChangeProcessNumberOfSteps, 2
            ) * 100
      end as MDChgProcPrgrsRatioInPercent
}