I_MasterDataChangeProcessTP

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_MasterDataChangeProcessTP.
-- 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: IMDCHGPROCESSTP

CREATE VIEW I_MasterDataChangeProcessTP AS
SELECT
  _Process.db_key AS MasterDataChangeProcessUUID,
  _Process.id AS MasterDataChangeProcess,
  _Process.description AS MDChgProcessDescription,
  _Process.type_id AS MDChgProcessTypeID,
  _Process.goal AS MDChgProcessGoal,
  _Process.status AS MDChgProcessStatus,
  _Process.source_otc AS MDChgProcessSrceObjectTypeCode,
  _Process.workflow AS MDChgProcessWorkflowTemplate,
  _Process.requestor AS MDChgProcessRequestor,
  _Process.delete_source AS MDChgProcessDelSrceDataIsRqd,
  _Process.create_date AS MDChgProcessCreationDate,
  _Process.create_time AS MDChgProcessCreationTime,
  _Process.change_date AS MDChgProcessChangeDate,
  _Process.change_time AS MDChgProcessChangeTime,
  _Process.finish_date AS MDChgProcessFinishDate,
  _Process.finish_time AS MDChgProcessFinishTime,
  _Process.update_counter AS MDChgProcessUpdateToken,
  _Process.started AS MDChgProcessIsStarted,
  _Process.initialized AS MDChgProcessIsInitialized,
  _Process.finalized AS MDChgProcessIsFinalized,
  _Process.last_step_finished AS MDChgProcessLastStepIsFinished,
  _Process.current_step_no AS MDChgProcessCurrentStepNumber,
  _Process.check_point_active AS MDChgProcessChkPointIsActive,
  _Process.complete_requested AS MDChgProcessCompletionIsReqd,
  _Process.wf_delete_requested AS MDChgProcessWrkFlwDeltnIsRqd,
  _Process.src_delete_requested AS MDChgProcessSrceDeletionIsRqd,
  ltrim ( rtrim( _Process.filter_chain, '\\' ), '\\' ) AS MDChgProcessFilterChain,
  _Process.log_error AS MDChgProcessErrorsAreLogged,
  _Process.last_act_key AS MDChgProcessLastActKey,
  _Process.predecessor_id AS MDChgProcessPredecessor,
  _Process.finalizing_at AS MDChgProcessFinalDateTime,
  _Process.next_step_scheduled_at AS MDChgProcessNextStpAtDateTime,
  _Process.duplicate_strategy AS MDChgProcessDuplicateStrategy,
  _Process.reliable AS MDChgProcessIsReliable,
  _Process.erased AS MDChgProcessIsErased,
  _Process.mass_intention AS MDChgProcessMassIntention,
  _Process.protection_reason AS MDChgProcessProtectionReason,
  _Process.referenced_federation_token AS MDChgProcRefcdFederationToken,
  _Process.referenced_fed_proc_step AS MDChgProcRefcdFederationStp,
  _Process.federation_proc_bus_system AS MDChgProcFederationBusSystName
FROM mdc_d_prcroot AS _Process
LEFT OUTER JOIN I_MDChgProcessAuthorityCheck AS _Auth ON _Auth.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [1..1]
LEFT OUTER JOIN I_MDChangeProcessSourceTP AS _Source ON _Source.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcessStepTP AS _Step ON _Step.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
;