I_MDChgProcStepEffctvConfign

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_MDChgProcStepEffctvConfign.
-- 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: IMDCHGPSTECONF

CREATE VIEW I_MDChgProcStepEffctvConfign AS
SELECT
  db_key AS MDChgProcessStepUUID,
  parent_key AS MasterDataChangeProcessUUID,
  process_id AS MasterDataChangeProcess,
  step_number AS MDChgProcessStep,
  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,
  started_at AS MDChgProcessStepStartDateTime,
  finished_at AS MDChgProcessStepFinishDateTime,
  process_config_uuid AS MDChgProcessStepConfign,
  use_own_config AS MDChgProcessStpOwnConfignIsRqd,
  ad_hoc_step AS MDChgProcIsAdhocStep,
  action_ctrl AS MDChgProcessStepActionControl,
  begru AS MDChgProcessStepAuthznGroup
FROM mdc_d_prcstep
LEFT OUTER JOIN I_MDChgProcEffctvConfign AS _MDChgProcEffctvConfiguration ON _MDChgProcEffctvConfiguration.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [1..1]
;