I_MDChangeProcessStepTP_2

DDL: I_MDCHANGEPROCESSSTEPTP_2 Type: view_entity TRANSACTIONAL
34 Fields 1 Data Sources 7 Associations

Master Data Change Process Step

I_MDChangeProcessStepTP_2 is a Transactional CDS View that provides data about "Master Data Change Process Step" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcessStep) and exposes 34 fields with key field MDChgProcessStepUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcessStep _Step from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_MasterDataChangeProcess _MasterDataChangeProcess _MasterDataChangeProcess.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
[1..1] I_MDChangeProcessGoalValueHelp _ProcessGoal _ProcessGoal.MDChgProcessGoal = $projection.MDChgProcessGoal
[1..1] I_MDChgProcessStepType _StepType _StepType.MDChgProcessStepType = $projection.MDChgProcessStepType
[0..1] I_MDChgProcessSrceRecordsCntr _NumberOfSouceRecords _NumberOfSouceRecords.MDChgProcessSourceUUID = $projection.MasterDataChangeProcessUUID
[0..1] C_MDChgProcessStepDescription _StepDescription $projection.MasterDataChangeProcess = _StepDescription.MasterDataChangeProcess and $projection.MDChgProcessCurrentStepNumber = _StepDescription.MDChgProcessStep
[0..*] I_MDChgProcModifdObjectTP _ModifiedObjects
[0..*] I_MDChangeProcModifdTableTP _ModifiedTables

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Master Data Change Process Step view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID MDChgProcessStepUUID UUID
MasterDataChangeProcessUUID MasterDataChangeProcessUUID NodeID
MasterDataChangeProcess MasterDataChangeProcess Process ID
MDChgProcessStep MDChgProcessStep Step Number
MDChgProcessStepType MDChgProcessStepType VSS Sol. Step Type
MDChgProcessStepDescription MDChgProcessStepDescription Well Code Des.
MDChgProcessStepStatus MDChgProcessStepStatus Workflow Status
MDChgProcessStepAdapter MDChgProcessStepAdapter Step Adapter
MDChgProcessStepAdapterConfign MDChgProcessStepAdapterConfign Configuration ID
MDChgProcessStepChkPointIsActv MDChgProcessStepChkPointIsActv Check Point active
MDChgProcessStepOriglNumber MDChgProcessStepOriglNumber Step Number
MDChgProcessStepOriglSqncNmbr MDChgProcessStepOriglSqncNmbr Step Sequence
MDChgProcessStepStartIsReqd MDChgProcessStepStartIsReqd Start Requested
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessStepFilterChain MDChgProcessStepFilterChain Filter Chain
MDChgProcessStepStartDateTime MDChgProcessStepStartDateTime Time Stamp
MDChgProcessStepFinishDateTime MDChgProcessStepFinishDateTime Time Stamp
MDChgProcessStepConfign MDChgProcessStepConfign Config. UUID
MDChgProcessStpOwnConfignIsRqd MDChgProcessStpOwnConfignIsRqd Use Own
MDChgProcessTypeID _MasterDataChangeProcess MDChgProcessTypeID Process Template
MDChgProcessGoal _MasterDataChangeProcess MDChgProcessGoal Process Goal
MDChgProcessNmbrOfSrceRecords _NumberOfSouceRecords MDChgProcessNmbrOfSrceRecords
MDChgProcessCurrentStepNumber _MasterDataChangeProcess MDChgProcessCurrentStepNumber Step Number
MDChgProcessStepWrkflwDefID MDChgProcessStepWrkflwDefID Ext Workflow ID
MDChgProcessStepWrkflwHandle MDChgProcessStepWrkflwHandle CPWF Handle ID
MDChgProcessStepWrkflwSts MDChgProcessStepWrkflwSts Status
MDChgProcessStepWrkflwOvrlDcsn MDChgProcessStepWrkflwOvrlDcsn Workflow Decision
_ModifiedObjects _ModifiedObjects
_ModifiedTables _ModifiedTables
_MasterDataChangeProcess _MasterDataChangeProcess
_StepType _StepType
_ProcessGoal _ProcessGoal
_MDBusObjTypeCodeViaParam _MDBusObjTypeCodeViaParam
_StepDescription _StepDescription

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 I_MDChangeProcessStepTP_2.
-- 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 I_MDChangeProcessStepTP_2 AS
SELECT
  MDChgProcessStepUUID,
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessStepType,
  MDChgProcessStepDescription,
  MDChgProcessStepStatus,
  MDChgProcessStepAdapter,
  MDChgProcessStepAdapterConfign,
  MDChgProcessStepChkPointIsActv,
  MDChgProcessStepOriglNumber,
  MDChgProcessStepOriglSqncNmbr,
  MDChgProcessStepStartIsReqd,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessStepFilterChain,
  MDChgProcessStepStartDateTime,
  MDChgProcessStepFinishDateTime,
  MDChgProcessStepConfign,
  MDChgProcessStpOwnConfignIsRqd,
  _MasterDataChangeProcess.MDChgProcessTypeID AS MDChgProcessTypeID,
  _MasterDataChangeProcess.MDChgProcessGoal AS MDChgProcessGoal,
  _NumberOfSouceRecords.MDChgProcessNmbrOfSrceRecords AS MDChgProcessNmbrOfSrceRecords,
  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber AS MDChgProcessCurrentStepNumber,
  MDChgProcessStepWrkflwDefID,
  MDChgProcessStepWrkflwHandle,
  MDChgProcessStepWrkflwSts,
  MDChgProcessStepWrkflwOvrlDcsn
FROM I_MDChgProcessStep AS _Step
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON _MasterDataChangeProcess.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [1..1]
LEFT OUTER JOIN I_MDChangeProcessGoalValueHelp AS _ProcessGoal ON _ProcessGoal.MDChgProcessGoal = MDChgProcessGoal  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcessStepType AS _StepType ON _StepType.MDChgProcessStepType = MDChgProcessStepType  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcessSrceRecordsCntr AS _NumberOfSouceRecords ON _NumberOfSouceRecords.MDChgProcessSourceUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcessStepDescription AS _StepDescription ON MasterDataChangeProcess = _StepDescription.MasterDataChangeProcess AND MDChgProcessCurrentStepNumber = _StepDescription.MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcModifdObjectTP AS _ModifiedObjects ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcModifdTableTP AS _ModifiedTables ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More