C_MDChangeProcessLogHeader

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_MDChangeProcessLogHeader.
-- 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: CMDCHNGPROCLOGH

CREATE VIEW C_MDChangeProcessLogHeader AS
SELECT
  MDChgProcessStepUUID,
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessTypeID,
  MDChgProcessGoal,
  MDChgProcessStatus,
  MDChgProcessSrceObjectTypeCode,
  MDChgProcessStepAdapter,
  MDChgProcessStepType,
  MDChgProcessStepStatus,
  MDChgProcessStepStartDateTime,
  MDChgProcessStepFinishDateTime,
  MDChgProcStpNumberOfExceptions,
  MDChgProcessStepNumberOfErrors,
  MDChgProcStepNumberOfWarnings
FROM I_MDChangeProcessLogHeader
LEFT OUTER JOIN C_MDChgProcStepActivationKPI AS _MDChgProcStepActKPI ON _MDChgProcStepActKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepBstRecdCalcKPI AS _MDChgProcStepBrcKPI ON _MDChgProcStepBrcKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepEditKPISmmry AS _MDChgProcStepEdiKPISmmry ON _MDChgProcStepEdiKPISmmry.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepEditKPI AS _MDChgProcStepEdiKPI ON _MDChgProcStepEdiKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..*]
LEFT OUTER JOIN C_MDChgProcStepEvalKPISmmry AS _MDChgProcStepEvaKPISmmry ON _MDChgProcStepEvaKPISmmry.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepEvaluationKPI AS _MDChgProcStepEvaKPI ON _MDChgProcStepEvaKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..*]
LEFT OUTER JOIN C_MDChgProcStepFilterRemoveKPI AS _MDChgProcStepFarKPI ON _MDChgProcStepFarKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepMatchingKPI AS _MDChgProcStepMtcKPI ON _MDChgProcStepMtcKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepStdznKPI AS _MDChgProcStepStdKPI ON _MDChgProcStepStdKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepUpdateKPISmmry AS _MDChgProcStepUpdKPISmmry ON _MDChgProcStepUpdKPISmmry.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepUpdateKPI AS _MDChgProcStepUpdKPI ON _MDChgProcStepUpdKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..*]
LEFT OUTER JOIN C_MDChgProcStepValidationKPI AS _MDChgProcStepValKPI ON _MDChgProcStepValKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepFederationKPI AS _MDChgProcStepFedKPI ON _MDChgProcStepFedKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepSimlnKPISmmry AS _MDChgProcStepSimKPISmmry ON _MDChgProcStepSimKPISmmry.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepSimulationKPI AS _MDChgProcStepSimKPI ON _MDChgProcStepSimKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..*]
LEFT OUTER JOIN C_MDChgProcStepReplicationKPI AS _MDChgProcStepRepKPI ON _MDChgProcStepRepKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcStepDataProviderKPI AS _MDChgProcStepDpiKPI ON _MDChgProcStepDpiKPI.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..*]
LEFT OUTER JOIN C_MDChgProcStpDtaPrvdrKPISmmry AS _MDChgProcStepDpiKPISmmry ON _MDChgProcStepDpiKPISmmry.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFilterUnion AS _MDChgProcKPIFilter ON _MDChgProcKPIFilter.MDChgProcessStepUUID = MDChgProcessStepUUID  -- association [0..*]
;