I_MasterDataChangeProcessEnhcd

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_MasterDataChangeProcessEnhcd.
-- 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: IMDCHGPROCENH

CREATE VIEW I_MasterDataChangeProcessEnhcd AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessDescription,
  MDChgProcessTypeID,
  MDChgProcessGoal,
  MDChgProcessStatus,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessWorkflowTemplate,
  MDChgProcessRequestor,
  MDChgProcessCreationDate,
  MDChgProcessCreationTime,
  MDChgProcessChangeDate,
  MDChgProcessChangeTime,
  MDChgProcessFinishDate,
  MDChgProcessFinishTime,
  MDChgProcessFinalDateTime,
  MDChgProcessNextStpAtDateTime,
  MDChgProcessCurrentStepNumber,
  MDChgProcessIsStarted,
  MDChgProcessLastActKey,
  MDChgProcessChkPointIsActive,
  MDChgProcessPredecessor,
  MDChgProcessDuplicateStrategy,
  _MDChgProcessStatusStateCode.MDChgProcessStatusStateCode AS MDChgProcessStatusStateCode,
  _MDChgProcRapBasedSwitch.MDChgProcRAPBsdSwitchIsActive AS MDChgProcRAPBsdSwitchIsActive
FROM I_MasterDataChangeProcess
LEFT OUTER JOIN I_MDChgProcessStepEnhcd AS _MDChgProcessStepEnhcd ON _MDChgProcessStepEnhcd.MasterDataChangeProcess = MasterDataChangeProcess AND _MDChgProcessStepEnhcd.MDChgProcessStep = MDChgProcessCurrentStepNumber  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcessStatusState AS _MDChgProcessStatusState ON _MDChgProcessStatusState.MDChgProcessStatusStateCode = mdchgprocessstatusstatecode  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcessStatusStateCode AS _MDChgProcessStatusStateCode ON _MDChgProcessStatusStateCode.MasterDataChangeProcess = MasterDataChangeProcess  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcessType AS _MDChgProcessType ON _MDChgProcessType.MDChgProcessTypeID = MDChgProcessTypeID  -- association [1..1]
LEFT OUTER JOIN I_MDChangeProcStatus AS _MDChangeProcStatus ON _MDChangeProcStatus.MDChgProcessStatus = MDChgProcessStatus  -- association [1..1]
LEFT OUTER JOIN I_MDChangeProcGoal AS _MDChangeProcGoal ON _MDChangeProcGoal.MDChgProcessGoal = MDChgProcessGoal  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcModifdObjectsEnhcd AS _MDChgProcModifdObjectsEnhcd ON _MDChgProcModifdObjectsEnhcd.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessSourceEnhcd AS _MDChangeProcessSourceEnhcd ON _MDChangeProcessSourceEnhcd.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcValdtnRslts AS _MDChangeProcValdtnRslts ON _MDChangeProcValdtnRslts.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _MDChgProcCalendarDate ON _MDChgProcCalendarDate.CalendarDate = MDChgProcessCreationDate  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRAPBasedSwitch AS _MDChgProcRapBasedSwitch ON _MDChgProcRapBasedSwitch.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode OR _MDChgProcRapBasedSwitch.MDChgProcessSuiteObjTypeCode = MDChgProcessSrceObjectTypeCode  -- association [0..*]
;