C_MasterDataChangeProcess

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_MasterDataChangeProcess.
-- 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_MasterDataChangeProcess 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.MDChgProcessRequestor AS MDChgProcessRequestor,
  _ProcessVariant.MasterDataChangeProcessVariant AS MasterDataChangeProcessVariant,
  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,
  _ProcessStrategyVH._Text[1:Language=$session.system_language].MDChgProcDuplicateStrategyText AS MDChgProcDuplicateStrategyText,
  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,
  _NumberOfSouceRecords.MDChgProcessNmbrOfSrceRecords AS MDChgProcessNmbrOfSrceRecords,
  _ProcessIsIdle.MDChgProcessIsIdle AS MDChgProcessIsIdle,
  _ProcessState.MDChgProcessStatusStateCode AS MDChgProcessStatusStateCode,
  _ProcessState.MDChgProcessStatusStateName AS MDChgProcessStatusStateName,
  cast( '' as abap.char( 60 ) ) AS MDChgProcessSrceSystem,
  cast( ' ' as mdc_table_name preserving type ) AS MDChgProcessModelRootTableName,
  cast( '' as abap_boolean preserving type ) AS MDChgProcSelectionIsAvailable,
  _Attachments.NumberOfAttachments AS NumberOfAttachments,
  _NoteItem.NumberOfNotes AS NumberOfNotes,
  cast( '' as abap_boolean preserving type ) AS MDChgProcDspAttchIsAllowed,
  cast('' as mdc_process_id) AS MDChgProcVisualizationProcess,
  cast('' as mdc_business_system) AS MDChgProcVisualizationSrceSyst,
  Root.MDChgProcRefcdFederationToken AS MDChgProcRefcdFederationToken,
  Root.MDChgProcRefcdFederationStp AS MDChgProcRefcdFederationStp,
  Root.MDChgProcFederationBusSystName AS MDChgProcFederationBusSystName,
  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,
  Root.MDChangeProcessRejectionReason AS MDChangeProcessRejectionReason,
  _RejectionReasonText.MDChgProcRejectionReasonText AS MDChgProcRejectionReasonText,
  _StepDescription.MDChgProcessStepDescription AS MDChgProcessTypeStepDspDesc,
  _StepDescription.MDChgProcessStepType AS MDChgProcessTypeStepDesc
FROM I_MasterDataChangeProcessTP AS Root
LEFT OUTER JOIN C_MDChgProcessRelatedProcess AS _RelatedProcess ON _RelatedProcess.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_MDChangeProcessSource AS _Source ON _Source.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcessSrceRecordsCntr AS _NumberOfSouceRecords ON _NumberOfSouceRecords.MDChgProcessSourceUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN C_MasterDataChangeProcessStep AS _Step ON _Step.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
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 MasterDataChangeProcess = _StepDescription.MasterDataChangeProcess AND MDChgProcessCurrentStepNumber = _StepDescription.MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessIsIdle AS _ProcessIsIdle ON _ProcessIsIdle.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN C_MasterDataChangeProcessUser AS _ProcessUserVH ON _ProcessUserVH.MDChgProcessRequestor = MDChgProcessRequestor AND _ProcessUserVH.MasterDataChangeProcessVariant = masterdatachangeprocessvariant  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessVariant AS _ProcessVariant ON _ProcessVariant.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _ProcessRequestorContactCard ON MDChgProcessRequestor = _ProcessRequestorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_MDChangeProcessStatusStateVH 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_MDChgProcTypeRejectionReason AS _TypeRejectionReason ON _TypeRejectionReason.MDChgProcessTypeID = MDChgProcessTypeID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcRejectionReasonT AS _RejectionReasonText ON _RejectionReasonText.MDChangeProcessRejectionReason = MDChangeProcessRejectionReason AND _RejectionReasonText.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_MDQualityEvaluations AS _MDQualityEvaluations ON _MDQualityEvaluations.MasterDataChangeProcess = MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN P_MasterDataAttchLinkCount AS _Attachments ON MasterDataChangeProcess = _Attachments.MasterDataAttachmentObjectID AND _Attachments.MasterDataAttachmentObjectType = 'C_MASTERDATACHANGEPROCESS'  -- association [0..1]
LEFT OUTER JOIN P_MasterDataNoteItemCount AS _NoteItem ON MasterDataChangeProcess = _NoteItem.MasterDataNoteObjectIdentifier AND _NoteItem.MasterDataNoteObjectType = 'C_MASTERDATACHANGEPROCESS'  -- association [0..1]
LEFT OUTER JOIN P_MDChgProcTypeRjcnReasonCount AS _RejectionReason ON _RejectionReason.MDChgProcessTypeID = MDChgProcessTypeID  -- association [0..1]
;