I_MDChgProcessStep

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_MDChgProcessStep.
-- 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: IMDCHGPROCSTEP

CREATE VIEW I_MDChgProcessStep AS
SELECT
  db_key AS MDChgProcessStepUUID,
  parent_key AS MasterDataChangeProcessUUID,
  process_id AS MasterDataChangeProcess,
  step_number AS MDChgProcessStep,
  cast ( lpad( cast( cast( step_number as abap.int2 ) - 1 as abap.char( 11 ) ) , 4 , '0' ) as mdc_process_step_no ) AS MDChgProcessPreviousStep,
  step_type AS MDChgProcessStepType,
  description AS MDChgProcessStepDescription,
  status AS MDChgProcessStepStatus,
  adapter AS MDChgProcessStepAdapter,
  adapter_config_id AS MDChgProcessStepAdapterConfign,
  check_point_active AS MDChgProcessStepChkPointIsActv,
  original_step_no AS MDChgProcessStepOriglNumber,
  original_step_seq_no AS MDChgProcessStepOriglSqncNmbr,
  start_requested AS MDChgProcessStepStartIsReqd,
  source_otc AS MDChgProcessSrceObjectTypeCode,
  filter_chain AS MDChgProcessStepFilterChain,
  started_at AS MDChgProcessStepStartDateTime,
  finished_at AS MDChgProcessStepFinishDateTime,
  process_config_uuid AS MDChgProcessStepConfign,
  use_own_config AS MDChgProcessStpOwnConfignIsRqd,
  ad_hoc_step AS MDChgProcIsAdhocStep,
  scp_workflow_definition_id AS MDChgProcessStepWrkflwDefID,
  scp_workflow_handle AS MDChgProcessStepWrkflwHandle,
  scp_workflow_status AS MDChgProcessStepWrkflwSts,
  scp_workflow_decision AS MDChgProcessStepWrkflwOvrlDcsn
FROM mdc_d_prcstep
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON _MasterDataChangeProcess.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [1..1]
;