C_MasterDataChangeProcessStep

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_MasterDataChangeProcessStep.
-- 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.
-- SQL view name: CMDCHGPROCSTEP

CREATE VIEW C_MasterDataChangeProcessStep AS
SELECT
  MDChgProcessStepUUID,
  MasterDataChangeProcessUUID,
  _RootUpdateToken.MDChgProcessUpdateToken AS MDChgProcessUpdateToken,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessStepType,
  MDChgProcessStepDescription,
  MDChgProcessStepStatus,
  cast ( ' ' as abap_boolean preserving type ) AS MDChangeProcessStepHasError,
  cast ( 0 as abap.int4 ) AS MDChgProcStepNumberOfWarnings,
  cast ( 0 as abap.int4 ) AS MDChgProcessStepNumberOfErrors,
  cast ( 0 as abap.int4 ) AS MDChgProcStpNumberOfExceptions,
  sum ( _ModifiedObjects.MDChgProcModifdObjectsCount ) AS MDChgProcModifdObjectsCount,
  cast( 0 as abap.int1 ) AS MDChgProcStpProgressRatioInPct,
  cast( '%' as msehi ) AS MDChangeProcStepProgressUnit,
  MDChgProcessStepAdapter,
  MDChgProcessStepAdapterConfign,
  MDChgProcessStepChkPointIsActv,
  MDChgProcessStepOriglNumber,
  MDChgProcessStepOriglSqncNmbr,
  MDChgProcessStepStartIsReqd,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessStepFilterChain,
  MDChgProcessStepStartDateTime,
  MDChgProcessStepFinishDateTime,
  MDChgProcessStepConfign,
  MDChgProcessStpOwnConfignIsRqd,
  cast ( ' ' as abap_boolean preserving type ) AS MDChangeProcessStepIsTransient,
  MDChgProcIsAdhocStep,
  cast ( ' ' as abap_boolean preserving type ) AS MDChgProcStepScheduleIsRecmdd,
  cast( '' as mdc_business_system ) AS MDChgProcessSrceSystem,
  cast( '' as mdc_source_id ) AS MDChgProcessSrceObject,
  cast ( '' as boole_d ) AS MDChgProcStepIsRollbackAllowed,
  MDChgProcessStepWrkflwDefID,
  MDChgProcessStepWrkflwHandle,
  MDChgProcessStepWrkflwSts,
  MDChgProcessStepWrkflwOvrlDcsn
FROM I_MDChgProcessStepTP AS Step
LEFT OUTER JOIN C_MasterDataChangeProcess AS _Root ON _Root.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [1..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _RootUpdateToken ON _RootUpdateToken.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcModifdObjects AS _ModifiedObjects ON _ModifiedObjects.MasterDataChangeProcess = Step.MasterDataChangeProcess AND _ModifiedObjects.MDChgProcessStep = Step.MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN C_MDChangeProcessLogHeader AS _MDChangeProcessLogHeader ON _MDChangeProcessLogHeader.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [1..1]
;