C_MDChgProcessStepDescription

DDL: C_MDCHGPROCESSSTEPDESCRIPTION Type: view_entity
6 Fields 1 Data Sources 4 Associations

Step descriptions of a process

C_MDChgProcessStepDescription is a 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 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcess Process from

Associations (4)

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
[1] I_MasterDataChangeProcess _MasterDataChangeProcess _MasterDataChangeProcess.MasterDataChangeProcess = Process.MasterDataChangeProcess

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Step descriptions of a process view
Metadata.ignorePropagatedAnnotations true 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 Process ID
MDChgProcessStep Step MDChgProcessStep Step Number
MDChgProcessStepType Step MDChgProcessStepType
MDChgProcessSrceObjectTypeCode Step MDChgProcessSrceObjectTypeCode Bus. Obj. Type
_MasterDataChangeProcess _MasterDataChangeProcess

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MDChgProcessStepDescription.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MDChgProcessStepDescription AS
SELECT
  Step.MDChgProcessStepUUID AS MDChgProcessStepUUID,
  Process.MasterDataChangeProcess AS MasterDataChangeProcess,
  Step.MDChgProcessStep AS MDChgProcessStep,
  Step.MDChgProcessStepType AS MDChgProcessStepType,
  Step.MDChgProcessSrceObjectTypeCode AS MDChgProcessSrceObjectTypeCode
FROM I_MasterDataChangeProcess AS Process
LEFT OUTER JOIN C_MDChangeProcessTemplateStep AS _TemplateDescription ON Process.MDChgProcessTypeID = _TemplateDescription.MDChgProcessTypeID AND Step.MDChgProcessStepOriglNumber = _TemplateDescription.MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcessStep AS _PreviousStep ON _PreviousStep.MasterDataChangeProcess = Step.MasterDataChangeProcess AND _PreviousStep.MDChgProcessStep = Step.MDChgProcessPreviousStep  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcMessageShortText AS _RevisionStepText ON _RevisionStepText.MDChangeProcessMessageID = 'MDC_PROCESS_MSG' AND _RevisionStepText.MDChangeProcessMessageNumber = '535' AND _RevisionStepText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON _MasterDataChangeProcess.MasterDataChangeProcess = Process.MasterDataChangeProcess  -- association [1]
;

Learn More