I_MDChangeProcessProgressRatio

DDL: I_MDCHANGEPROCESSPROGRESSRATIO Type: view_entity
8 Fields 1 Data Sources 2 Associations

MD Change Process Progress Ratio

I_MDChangeProcessProgressRatio is a CDS View that provides data about "MD Change Process Progress Ratio" in SAP S/4HANA. It reads from 1 data source (I_MasterDataChangeProcess) and exposes 8 fields with key field MasterDataChangeProcessUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MasterDataChangeProcess I_MasterDataChangeProcess from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_MasterDataChangeProcessStep _Step _Step.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
[0..1] I_MDChgProcPackageInformation _Packages _Packages.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _Packages.MDChgProcessStep = $projection.MDChgProcessCurrentStepNumber

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MD Change Process Progress Ratio view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcessUUID MasterDataChangeProcessUUID NodeID
MasterDataChangeProcess MasterDataChangeProcess Process ID
MDChgProcessCurrentStepNumber MDChgProcessCurrentStepNumber Step Number
MDChgProcessStatus MDChgProcessStatus Process Status
MDChgProcessIsErased MDChgProcessIsErased Process Erased
MDChangeProcessNumberOfSteps
MDChgProcessNumberOfPackages
MDChgProcTotalNumberOfPackages

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 I_MDChangeProcessProgressRatio.
-- 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 I_MDChangeProcessProgressRatio AS
SELECT
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessCurrentStepNumber,
  MDChgProcessStatus,
  MDChgProcessIsErased,
  count( distinct _Step.MDChgProcessStep ) AS MDChangeProcessNumberOfSteps,
  sum( case when _Packages.MDChangeProcessPackageStatus = '' then 0 else _Packages.MDChgProcessNumberOfPackages end ) AS MDChgProcessNumberOfPackages,
  sum( _Packages.MDChgProcessNumberOfPackages ) AS MDChgProcTotalNumberOfPackages
FROM I_MasterDataChangeProcess
LEFT OUTER JOIN C_MasterDataChangeProcessStep AS _Step ON _Step.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [0..*]
LEFT OUTER JOIN I_MDChgProcPackageInformation AS _Packages ON _Packages.MasterDataChangeProcess = MasterDataChangeProcess AND _Packages.MDChgProcessStep = MDChgProcessCurrentStepNumber  -- association [0..1]
;

Learn More