C_MasterDataMyBPChangeProcess

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_MasterDataMyBPChangeProcess.
-- 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.

CREATE VIEW C_MasterDataMyBPChangeProcess AS
SELECT
  Root.MasterDataChangeProcessUUID AS MasterDataChangeProcessUUID,
  Root.MasterDataChangeProcess AS MasterDataChangeProcess,
  cast( Root.MasterDataChangeProcess as mdc_process_id_alpha_out ) AS MDChangeProcessNumberDisplay,
  Root.MDChgProcessDescription AS MDChgProcessDescription,
  Root.MDChgProcessTypeID AS MDChgProcessTypeID,
  Root.MDChgProcessGoal AS MDChgProcessGoal,
  Root.MDChgProcessStatus AS MDChgProcessStatus,
  Root.MDChgProcessSrceObjectTypeCode AS MDChgProcessSrceObjectTypeCode,
  Root.MDChgProcessWorkflowTemplate AS MDChgProcessWorkflowTemplate,
  Root.MDChgProcessCreationDate AS MDChgProcessCreationDate,
  Root.MDChgProcessCreationTime AS MDChgProcessCreationTime,
  Root.MDChgProcessChangeDate AS MDChgProcessChangeDate,
  Root.MDChgProcessChangeTime AS MDChgProcessChangeTime,
  Root.MDChgProcessDelSrceDataIsRqd AS MDChgProcessDelSrceDataIsRqd,
  Root.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  Root.MDChgProcessFinishTime AS MDChgProcessFinishTime,
  Root.MDChgProcessUpdateToken AS MDChgProcessUpdateToken,
  Root.MDChgProcessIsStarted AS MDChgProcessIsStarted,
  Root.MDChgProcessIsInitialized AS MDChgProcessIsInitialized,
  Root.MDChgProcessIsFinalized AS MDChgProcessIsFinalized,
  Root.MDChgProcessLastStepIsFinished AS MDChgProcessLastStepIsFinished,
  Root.MDChgProcessCurrentStepNumber AS MDChgProcessCurrentStepNumber,
  Root.MDChgProcessChkPointIsActive AS MDChgProcessChkPointIsActive,
  Root.MDChgProcessCompletionIsReqd AS MDChgProcessCompletionIsReqd,
  Root.MDChgProcessWrkFlwDeltnIsRqd AS MDChgProcessWrkFlwDeltnIsRqd,
  Root.MDChgProcessSrceDeletionIsRqd AS MDChgProcessSrceDeletionIsRqd,
  Root.MDChgProcessFilterChain AS MDChgProcessFilterChain,
  Root.MDChgProcessErrorsAreLogged AS MDChgProcessErrorsAreLogged,
  Root.MDChgProcessLastActKey AS MDChgProcessLastActKey,
  Root.MDChgProcessPredecessor AS MDChgProcessPredecessor,
  Root.MDChgProcessFinalDateTime AS MDChgProcessFinalDateTime,
  Root.MDChgProcessNextStpAtDateTime AS MDChgProcessNextStpAtDateTime,
  Root.MDChgProcessDuplicateStrategy AS MDChgProcessDuplicateStrategy,
  Root.MDChgProcessIsReliable AS MDChgProcessIsReliable,
  Root.MDChgProcessProtectionReason AS MDChgProcessProtectionReason,
  Root.MDChgProcessIsErased AS MDChgProcessIsErased,
  _Criticality.MDChgProcessStatusCriticality AS MDChgProcessStatusCriticality,
  cast( '%' as msehi ) AS MDChangeProcessProgressUnit,
  _Ratio.MDChgProcPrgrsRatioInPercent AS MDChgProcPrgrsRatioInPercent,
  _Ratio.MDChangeProcessNumberOfSteps AS MDChangeProcessNumberOfSteps,
  _ProcessState.MDChgProcessStatusStateCode AS MDChgProcessStatusStateCode,
  _ProcessState.MDChgProcessStatusStateName AS MDChgProcessStatusStateName,
  cast( '' as abap.char( 60 ) ) AS MDChgProcessSrceSystem,
  Root.MasterDataChangeProcessDueDate AS MasterDataChangeProcessDueDate,
  Root.MasterDataChangeProcessReason AS MasterDataChangeProcessReason,
  _ReasonText.MDChangeProcessReasonText AS MDChangeProcessReasonText,
  concat( Root.MDChgProcessSrceObjectTypeCode, Root.MasterDataChangeProcessReason ) AS MDChgProcObjectTypeCodeReason,
  Root.MDChangeProcessPriority AS MDChangeProcessPriority,
  _PriorityText.MDChangeProcessPriorityText AS MDChangeProcessPriorityText,
  _StepDescription.MDChgProcessStepDescription AS MDChgProcessTypeStepDspDesc,
  _StepDescription.MDChgProcessStepType AS MDChgProcessTypeStepDesc,
  _EntityCounterBP.MDChgProcNmbrOfBPSourceRecords AS MDChgProcNmbrOfBPSourceRecords,
  _EntityCounterBPRel.MDNmbrOfBPRelshpSourceRecords AS MDNmbrOfBPRelshpSourceRecords,
  _EntityCounterBPHier.MDNumberOfBPHierSourceRecords AS MDNumberOfBPHierSourceRecords
FROM I_MasterDataChangeProcessTP AS Root
LEFT OUTER JOIN C_MDChangeProcessSource AS _Source ON _Source.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_MasterDataChangeProcessStep AS _Step ON _Step.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_MDChgProcessRelatedProcess AS _RelatedProcess ON _RelatedProcess.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcessSrceRecordsCntr AS _NumberOfSouceRecords ON _NumberOfSouceRecords.MDChgProcessSourceUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN P_MDMyBPChangeProcessCount AS _EntityCounterBP ON _EntityCounterBP.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN P_MDMyBPRelChangeProcessCount AS _EntityCounterBPRel ON _EntityCounterBPRel.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN P_MDMyBPHierChangeProcessCount AS _EntityCounterBPHier ON _EntityCounterBPHier.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN P_MDChangeProcessStatusState AS _ProcessState ON _ProcessState.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChangeProcessCriticality AS _Criticality ON _Criticality.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChangeProcessProgressRatio AS _Ratio ON _Ratio.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcessStepDescription AS _StepDescription ON _StepDescription.MasterDataChangeProcess = MasterDataChangeProcess AND _StepDescription.MDChgProcessStep = MDChgProcessCurrentStepNumber  -- association [0..1]
LEFT OUTER JOIN C_MDMyBPChgProcStatusStateVH AS _ProcessStateVH ON _ProcessStateVH.MDChgProcessStatusStateCode = MDChgProcessStatusStateCode  -- association [0..1]
LEFT OUTER JOIN C_MDChangeProcessGoalValueHelp AS _ProcessGoalVH ON _ProcessGoalVH.MDChgProcessGoal = MDChgProcessGoal  -- association [0..1]
LEFT OUTER JOIN C_MasterDataChangeProcessGoal AS _ProcessGoalText ON _ProcessGoalText.MDChgProcessGoal = MDChgProcessGoal  -- association [0..*]
LEFT OUTER JOIN C_MDChangeProcessGoalProperty AS _GoalProperty ON _GoalProperty.MDChgProcessGoal = MDChgProcessGoal  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessTypeVH AS _ProcessTypeVH ON _ProcessTypeVH.MDChgProcessTypeID = MDChgProcessTypeID AND _ProcessTypeVH.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode AND _ProcessTypeVH.MDChgProcessGoal = MDChgProcessGoal  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessReasonText AS _ReasonText ON _ReasonText.MasterDataChangeProcessReason = MasterDataChangeProcessReason AND _ReasonText.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode AND _ReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessPriorityText AS _PriorityText ON _PriorityText.MDChangeProcessPriority = MDChangeProcessPriority AND _PriorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcessTypeText AS _ProcessTypeText ON _ProcessTypeText.MDChgProcessTypeID = MDChgProcessTypeID  -- association [0..1]
LEFT OUTER JOIN C_MDChangeProcessStrategyVH AS _ProcessStrategyVH ON _ProcessStrategyVH.MDChgProcessDuplicateStrategy = MDChgProcessDuplicateStrategy  -- association [0..1]
LEFT OUTER JOIN C_BusinessPartnerGovTP AS _BusinessPartner ON _BusinessPartner.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..*]
LEFT OUTER JOIN C_BPHierarchyGovernanceTP AS _BPHierarchy ON _BPHierarchy.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..*]
LEFT OUTER JOIN C_BPHierarchyNodeGovernanceTP AS _BPHierarchyNode ON _BPHierarchyNode.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..*]
;