I_BPHierChangeProcessGov

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_BPHierChangeProcessGov.
-- 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.

CREATE VIEW I_BPHierChangeProcessGov AS
SELECT
  BPHierProcess.process_id AS MasterDataChangeProcess,
  BPHierProcess.process_step_no AS MDChgProcessStep,
  BPHierProcess.source_system AS MDChgProcessSrceSystem,
  BPHierProcess.source_id AS MDChgProcessSrceObject,
  Process.MasterDataChangeProcessUUID AS MasterDataChangeProcessUUID,
  Process.MDChgProcessDescription AS MDChgProcessDescription,
  Process.MDChgProcessTypeID AS MDChgProcessTypeID,
  Process.MDChgProcessGoal AS MDChgProcessGoal,
  Process.MDChgProcessStatus AS MDChgProcessStatus,
  Process.MDChgProcessSrceObjectTypeCode AS MDChgProcessSrceObjectTypeCode,
  Process.MDChgProcessRequestor AS MDChgProcessRequestor,
  Process.MDChgProcessIsStarted AS MDChgProcessIsStarted,
  Process.MDChgProcessIsFinalized AS MDChgProcessIsFinalized,
  Process.MDChgProcessLastStepIsFinished AS MDChgProcessLastStepIsFinished,
  Process.MDChgProcessCurrentStepNumber AS MDChgProcessCurrentStepNumber,
  Process.MDChgProcessIsErased AS MDChgProcessIsErased,
  Process.MasterDataChangeProcessReason AS MasterDataChangeProcessReason,
  _ReasonText.MDChangeProcessReasonText AS MDChangeProcessReasonText,
  Process.MDChangeProcessPriority AS MDChangeProcessPriority,
  _PriorityText.MDChangeProcessPriorityText AS MDChangeProcessPriorityText,
  Process.MasterDataChangeProcessDueDate AS MasterDataChangeProcessDueDate
FROM I_MasterDataChangeProcess AS Process
INNER JOIN bph_hier_prc AS BPHierProcess ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDChangeProcessReasonText AS _ReasonText ON _ReasonText.MasterDataChangeProcessReason = MasterDataChangeProcessReason AND _ReasonText.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode AND _ReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessPriorityText AS _PriorityText ON _PriorityText.MDChangeProcessPriority = MDChangeProcessPriority AND _PriorityText.Language = $session.system_language  -- association [0..1]
;