I_MDChgProcStepProgressRatio

DDL: I_MDCHGPROCSTEPPROGRESSRATIO Type: view_entity
12 Fields 1 Data Sources 2 Associations

MDC Process Step Progr Ratio

I_MDChgProcStepProgressRatio is a CDS View that provides data about "MDC Process Step Progr Ratio" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcessStepTP) and exposes 12 fields with key field MDChgProcessStepUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcessStepTP I_MDChgProcessStepTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_MasterDataChangeProcess _Root _Root.MasterDataChangeProcessUUID = $projection.MasterDataChangeProcessUUID
[0..1] I_MDChgProcPackageInformation _Packages _Packages.MasterDataChangeProcess = $projection.MasterDataChangeProcess and _Packages.MDChgProcessStep = $projection.MDChgProcessStep

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MDC Process Step Progr Ratio view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID MDChgProcessStepUUID UUID
MasterDataChangeProcessUUID MasterDataChangeProcessUUID NodeID
MasterDataChangeProcess MasterDataChangeProcess Process ID
MDChgProcessStep MDChgProcessStep Step Number
MDChgProcessStepType MDChgProcessStepType VSS Sol. Step Type
MDChgProcessStepDescription MDChgProcessStepDescription Well Code Des.
MDChgProcessStepStatus MDChgProcessStepStatus Workflow Status
MDChgProcIsAdhocStep MDChgProcIsAdhocStep Ad hoc Step
MDChgProcessNumberOfPackages
MDChgProcTotalNumberOfPackages
_Root _Root
_Packages _Packages

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_MDChgProcStepProgressRatio.
-- 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_MDChgProcStepProgressRatio AS
SELECT
  MDChgProcessStepUUID,
  MasterDataChangeProcessUUID,
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessStepType,
  MDChgProcessStepDescription,
  MDChgProcessStepStatus,
  MDChgProcIsAdhocStep,
  sum( case when _Packages.MDChangeProcessPackageStatus = 'S' then _Packages.MDChgProcessNumberOfPackages else 0 end ) AS MDChgProcessNumberOfPackages,
  sum( _Packages.MDChgProcessNumberOfPackages ) AS MDChgProcTotalNumberOfPackages
FROM I_MDChgProcessStepTP
LEFT OUTER JOIN C_MasterDataChangeProcess AS _Root ON _Root.MasterDataChangeProcessUUID = MasterDataChangeProcessUUID  -- association [1..1]
LEFT OUTER JOIN I_MDChgProcPackageInformation AS _Packages ON _Packages.MasterDataChangeProcess = MasterDataChangeProcess AND _Packages.MDChgProcessStep = MDChgProcessStep  -- association [0..1]
;

Learn More