C_MDChgProcessStepDescription

DDL: C_MDCHGPROCESSSTEPDESCRIPTION Type: view_entity CONSUMPTION Package: MDC_PROCESS_OBJECT

Step descriptions of a process

C_MDChgProcessStepDescription is a Consumption CDS View that provides data about "Step descriptions of a process" in SAP S/4HANA. It reads from 1 data source (I_MasterDataChangeProcess) and exposes 6 fields with key field MDChgProcessStepUUID. It has 3 associations to related views. Part of development package MDC_PROCESS_OBJECT.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcess Process from

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_MDChangeProcessTemplateStep _TemplateDescription Process.MDChgProcessTypeID = _TemplateDescription.MDChgProcessTypeID and Step.MDChgProcessStepOriglNumber = _TemplateDescription.MDChgProcessStep
[0..1] I_MDChgProcessStep _PreviousStep _PreviousStep.MasterDataChangeProcess = Step.MasterDataChangeProcess and _PreviousStep.MDChgProcessStep = Step.MDChgProcessPreviousStep
[0..1] I_MDChgProcMessageShortText _RevisionStepText _RevisionStepText.MDChangeProcessMessageID = 'MDC_PROCESS_MSG' and _RevisionStepText.MDChangeProcessMessageNumber = '535' and _RevisionStepText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Step descriptions of a process view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID Step MDChgProcessStepUUID
MasterDataChangeProcess I_MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessGoal I_MasterDataChangeProcess MDChgProcessGoal
MDChgProcessStep Step MDChgProcessStep
MDChgProcessStepType Step MDChgProcessStepType
MDChgProcessSrceObjectTypeCode Step MDChgProcessSrceObjectTypeCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Step descriptions of a process'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel:{
  usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
  },
  alternativeKey: [{ id: 'MDChgProcessStepUUID', element: [ 'MasterDataChangeProcess', 'MDChgProcessStep' ] }]
}
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view entity C_MDChgProcessStepDescription
  as select from I_MasterDataChangeProcess as Process
    join         I_MDChgProcessStep        as Step on Step.MasterDataChangeProcessUUID = Process.MasterDataChangeProcessUUID
  association [0..1] to C_MDChangeProcessTemplateStep as _TemplateDescription     on  Process.MDChgProcessTypeID       = _TemplateDescription.MDChgProcessTypeID
                                                                                  and Step.MDChgProcessStepOriglNumber = _TemplateDescription.MDChgProcessStep
  association [0..1] to I_MDChgProcessStep            as _PreviousStep            on  _PreviousStep.MasterDataChangeProcess = Step.MasterDataChangeProcess
                                                                                  and _PreviousStep.MDChgProcessStep        = Step.MDChgProcessPreviousStep
  association [0..1] to I_MDChgProcMessageShortText   as _RevisionStepText        on  _RevisionStepText.MDChangeProcessMessageID     = 'MDC_PROCESS_MSG'
                                                                                  and _RevisionStepText.MDChangeProcessMessageNumber = '535'
                                                                                  and _RevisionStepText.Language                     = $session.system_language
{
  key Step.MDChgProcessStepUUID,
      Process.MasterDataChangeProcess,
      @UI.hidden: true
      Process.MDChgProcessGoal,
      Step.MDChgProcessStep,
      Step.MDChgProcessStepType,
      Step.MDChgProcessSrceObjectTypeCode,
      case
      when Step.MDChgProcIsAdhocStep is initial then _TemplateDescription.MDChgProcessTypeStepDspDesc
      when ( Step.MDChgProcessStepType = 'EDI' and Step.MDChgProcessStep > '0001' and _PreviousStep.MDChgProcessStepType = 'FED' ) then _RevisionStepText.MDChgProcessMessageText
      when Step.MDChgProcessStepType = _PreviousStep.MDChgProcessStepType then
        concat(_TemplateDescription.MDChgProcessTypeStepDspDesc,
          concat(
            concat(
              ' (',
              cast( cast( Step.MDChgProcessStep as abap.int2 ) - cast( Step.MDChgProcessStepOriglNumber as abap.int2 ) + 1 as abap.char(11) )
            ),
            ')'
          )
        )
      else
        _TemplateDescription.MDChgProcessTypeStepDspDesc
      end as MDChgProcessStepDescription
}

Learn More