C_MDProductChangeProcess

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 C_MDProductChangeProcess.
-- 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: CMDPRODCHGPROC

CREATE VIEW C_MDProductChangeProcess AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessDescription,
  MDChgProcessTypeID,
  MDChgProcessGoal,
  MDChgProcessStatusStateCode,
  MDChgProcessStatus,
  MDChgProcessRequestor AS CreatedByUser,
  _MDChgProcProductCreatorVH.CreatedByUserName AS CreatedByUserName,
  MDChgProcessCreationDate AS CreationDate,
  _MDChgProcCalendarDate.YearMonth AS CreationYearMonth,
  MDChgProcessCreationTime,
  MDChgProcessWorkflowTemplate,
  MDChgProcessChangeDate,
  MDChgProcessChangeTime,
  MDChgProcessFinishDate,
  MDChgProcessFinishTime,
  MDChgProcessChkPointIsActive,
  MDChgProcessPredecessor,
  MDChgProcessFinalDateTime,
  MDChgProcessNextStpAtDateTime,
  MDChgProcessDuplicateStrategy,
  cast( 'TAG' as unit ) AS MDChgProcAvgProcgDaysUnit,
  cast (1 as abap.int4 ) AS MDChangeProcessCount,
  _MDChangeProcessSourceEnhcd.MDChgProcessNmbrOfSrceRecords AS MDChgProcessNmbrOfSrceRecords,
  _MDChgProcModifdObjectsEnhcd.MDChgProcModifdObjectsCount AS MDChgProcModifdObjectsCount,
  _MDChangeProcValdtnRslts.MDChgProcValdtnErrorCount AS MDChgProcValdtnErrorCount,
  MDChgProcRAPBsdSwitchIsActive,
  _MDChgProcCalendarDate._YearMonth AS _YearMonth
FROM I_MasterDataChangeProcessEnhcd
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureDays ON MDChgProcAvgProcgDaysUnit = _UnitOfMeasureDays.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcProductCreatorVH AS _MDChgProcProductCreatorVH ON CreatedByUser = _MDChgProcProductCreatorVH.CreatedByUser  -- association [0..1]
LEFT OUTER JOIN C_MDProductChgProcessTypeVH AS _MDProductChgProcessTypeVH ON MDChgProcessTypeID = _MDProductChgProcessTypeVH.MDChgProcessTypeID  -- association [1..1]
LEFT OUTER JOIN C_MDProductChgProcessGoalVH AS _MDProductChgProcessGoalVH ON MDChgProcessGoal = _MDProductChgProcessGoalVH.MDChgProcessGoal  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcessTypeText AS _MDChgProcessTypeText ON MDChgProcessTypeID = _MDChgProcessTypeText.MDChgProcessTypeID  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcGoalT AS _MDChangeProcGoalT ON MDChgProcessGoal = _MDChangeProcGoalT.MDChgProcessGoal  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcessStatusStateT AS _MDChgProcessStatusStateT ON MDChgProcessStatusStateCode = _MDChgProcessStatusStateT.MDChgProcessStatusStateCode  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON MDChgProcAvgProcgDaysUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
;