I_MDChgProcEffctvConfign

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_MDChgProcEffctvConfign.
-- 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: IMDCHGPECONF

CREATE VIEW I_MDChgProcEffctvConfign AS
SELECT
  db_key AS MasterDataChangeProcessUUID,
  id AS MasterDataChangeProcess,
  description AS MDChgProcessDescription,
  type_id AS MDChgProcessTypeID,
  goal AS MDChgProcessGoal,
  status AS MDChgProcessStatus,
  source_otc AS MDChgProcessSrceObjectTypeCode,
  workflow AS MDChgProcessWorkflowTemplate,
  requestor AS MDChgProcessRequestor,
  delete_source AS MDChgProcessDelSrceDataIsRqd,
  create_date AS MDChgProcessCreationDate,
  create_time AS MDChgProcessCreationTime,
  change_date AS MDChgProcessChangeDate,
  change_time AS MDChgProcessChangeTime,
  finish_date AS MDChgProcessFinishDate,
  finish_time AS MDChgProcessFinishTime,
  update_counter AS MDChgProcessUpdateToken,
  started AS MDChgProcessIsStarted,
  initialized AS MDChgProcessIsInitialized,
  finalized AS MDChgProcessIsFinalized,
  last_step_finished AS MDChgProcessLastStepIsFinished,
  current_step_no AS MDChgProcessCurrentStepNumber,
  check_point_active AS MDChgProcessChkPointIsActive,
  complete_requested AS MDChgProcessCompletionIsReqd,
  wf_delete_requested AS MDChgProcessWrkFlwDeltnIsRqd,
  src_delete_requested AS MDChgProcessSrceDeletionIsRqd,
  filter_chain AS MDChgProcessFilterChain,
  log_error AS MDChgProcessErrorsAreLogged,
  last_act_key AS MDChgProcessLastActKey,
  predecessor_id AS MDChgProcessPredecessor,
  finalizing_at AS MDChgProcessFinalDateTime,
  next_step_scheduled_at AS MDChgProcessNextStpAtDateTime,
  duplicate_strategy AS MDChgProcessDuplicateStrategy,
  reliable AS MDChgProcessIsReliable,
  erased AS MDChgProcessIsErased
FROM mdc_d_prcroot
LEFT OUTER JOIN I_MDChgProcStepEffctvConfign AS _MDChgProcessStepEffctvConfign ON _MDChgProcessStepEffctvConfign.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
;