C_MDChgProcessRelatedProcess

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_MDChgProcessRelatedProcess.
-- 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: CMDPROCRELCPROC

CREATE VIEW C_MDChgProcessRelatedProcess AS
SELECT
  MasterDataChangeProcessUUID,
  MDChangeProcRelatedProcessUUID,
  MasterDataChangeProcess,
  MDChangeProcessIsPredecessor,
  MDChgProcessTypeID,
  MDChgProcessCurrentStepNumber,
  _ProcessState.MDChgProcessStatusStateCode AS MDChgProcessStatusStateCode,
  _ProcessState.MDChgProcessStatusStateName AS MDChgProcessStatusStateName,
  _StepDescription.MDChgProcessStepDescription AS MDChgProcessTypeStepDspDesc,
  _NumberOfSourceRecords.MDChgProcessNmbrOfSrceRecords AS MDChgProcessNmbrOfSrceRecords,
  MDChgProcessSrceObjectTypeCode
FROM I_MDChgProcessRelatedProcess
LEFT OUTER JOIN P_MDChangeProcessStatusState AS _ProcessState ON _ProcessState.MasterDataChangeProcessUUID = MDChangeProcRelatedProcessUUID  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcessSrceRecordsCntr AS _NumberOfSourceRecords ON _NumberOfSourceRecords.MDChgProcessSourceUUID = MDChangeProcRelatedProcessUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcessStepDescription AS _StepDescription ON MasterDataChangeProcess = _StepDescription.MasterDataChangeProcess AND MDChgProcessCurrentStepNumber = _StepDescription.MDChgProcessStep  -- association [0..1]
;