I_MDChgProcessStepEnhcd

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_MDChgProcessStepEnhcd.
-- 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: IMDCPROCSENH

CREATE VIEW I_MDChgProcessStepEnhcd AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessStepType,
  MDChgProcessStepStatus,
  MDChgProcessSrceObjectTypeCode
FROM I_MDChgProcessStep
LEFT OUTER JOIN I_MasterDataChangeProcessEnhcd AS _MasterDataChangeProcessEnhcd ON _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = MasterDataChangeProcess  -- association [1..1]
LEFT OUTER JOIN I_MDChangeProcStepValdtnRslts AS _MDChangeProcStepValdtnRslts ON _MDChangeProcStepValdtnRslts.MasterDataChangeProcess = MasterDataChangeProcess AND _MDChangeProcStepValdtnRslts.MDChgProcessStep = MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcModifdTables AS _MDChangeProcModifdTables ON _MDChangeProcModifdTables.MasterDataChangeProcess = MasterDataChangeProcess AND _MDChangeProcModifdTables.MDChgProcessStep = MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcModifdObjects AS _MDChgProcModifdObjects ON _MDChgProcModifdObjects.MasterDataChangeProcess = MasterDataChangeProcess AND _MDChgProcModifdObjects.MDChgProcessStep = MDChgProcessStep  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcessStepType AS _MDChgProcessStepType ON _MDChgProcessStepType.MDChgProcessStepType = MDChgProcessStepType  -- association [1..1]
LEFT OUTER JOIN I_MDChangeProcStepStatus AS _MDChangeProcStepStatus ON _MDChangeProcStepStatus.MDChgProcessStepStatus = MDChgProcessStepStatus  -- association [1..1]
;