C_MDChangeProcessCriticality

DDL: C_MDCHANGEPROCESSCRITICALITY Type: view_entity CONSUMPTION Package: MDC_PROCESS_OBJECT

MD Change Process Criticality

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

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcessTP I_MasterDataChangeProcessTP from

Associations (4)

CardinalityTargetAliasCondition
[0..1] C_MasterDataChangeProcessStep _Step _Step.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID and _Step.MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber
[0..1] C_MDCHANGEPROCESSSTEPCONSOLE _ErrorsA _ErrorsA.MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber and _ErrorsA.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _ErrorsA.MDChangeProcessMessageType = 'A'
[0..1] C_MDCHANGEPROCESSSTEPCONSOLE _ErrorsX _ErrorsX.MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber and _ErrorsX.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _ErrorsX.MDChangeProcessMessageType = 'X'
[0..1] C_MDCHANGEPROCESSSTEPCONSOLE _ErrorsE _ErrorsE.MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber and _ErrorsE.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _ErrorsE.MDChangeProcessMessageType = 'E'

Annotations (4)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID
MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber
MDChgProcessStatus MDChgProcessStatus 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MD Change Process Criticality'
@Metadata.ignorePropagatedAnnotations: true
@VDM:           {viewType:           #CONSUMPTION}
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view entity C_MDChangeProcessCriticality
  as select from I_MasterDataChangeProcessTP
  association [0..1] to C_MasterDataChangeProcessStep as _Step    on  _Step.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
                                                                  and _Step.MDChgProcessStep            = $projection.MDChgProcessCurrentStepNumber
  association [0..1] to C_MDCHANGEPROCESSSTEPCONSOLE  as _ErrorsA on  _ErrorsA.MDChgProcessStep           = $projection.MDChgProcessCurrentStepNumber
                                                                  and _ErrorsA.MasterDataChangeProcess    = $projection.MasterDataChangeProcess
                                                                  and _ErrorsA.MDChangeProcessMessageType = 'A'
  association [0..1] to C_MDCHANGEPROCESSSTEPCONSOLE  as _ErrorsX on  _ErrorsX.MDChgProcessStep           = $projection.MDChgProcessCurrentStepNumber
                                                                  and _ErrorsX.MasterDataChangeProcess    = $projection.MasterDataChangeProcess
                                                                  and _ErrorsX.MDChangeProcessMessageType = 'X'
  association [0..1] to C_MDCHANGEPROCESSSTEPCONSOLE  as _ErrorsE on  _ErrorsE.MDChgProcessStep           = $projection.MDChgProcessCurrentStepNumber
                                                                  and _ErrorsE.MasterDataChangeProcess    = $projection.MasterDataChangeProcess
                                                                  and _ErrorsE.MDChangeProcessMessageType = 'E'
{
  key MasterDataChangeProcessUUID,
      MasterDataChangeProcess,
      MDChgProcessCurrentStepNumber,
      MDChgProcessStatus,
      case
      when MDChgProcessIsErased = 'X' or MDChgProcessStatus = 'S' or MDChgProcessStatus = 'W' or MDChgProcessStatus = 'P' or MDChgProcessStatus = 'R'
        then 'UI.CriticalityType/Neutral'
      when MDChgProcessStatus = 'F'
        then 'UI.CriticalityType/Positive'
      when _Step.MDChgProcessStepStatus = '4' and (_ErrorsA.NumberOfSystemMessages > 0 or _ErrorsX.NumberOfSystemMessages > 0 or _ErrorsE.NumberOfSystemMessages > 0 )
        then 'UI.CriticalityType/Critical'
      when _Step.MDChgProcessStepStatus = '4'
        then 'UI.CriticalityType/Positive'
      when _Step.MDChgProcessStepStatus = '5' or  _Step.MDChgProcessStepStatus = '3'
        then 'UI.CriticalityType/Negative'
      else 'UI.CriticalityType/Neutral'
      end as MDChgProcessStatusCriticality
}

Learn More