I_BPHierarchyProcKPIRecordType

DDL: I_BPHIERARCHYPROCKPIRECORDTYPE Type: view_entity
26 Fields 5 Data Sources 3 Associations

Process Data of BP Hierarchies – TP

I_BPHierarchyProcKPIRecordType is a CDS View that provides data about "Process Data of BP Hierarchies – TP" in SAP S/4HANA. It reads from 5 data sources (I_MDChgProcessStep, I_MDChgProcessStep, I_MDChgProcessStep, I_MDChgProcessStep, I_MDChgProcessStep) and exposes 26 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessStep. It has 3 associations to related views.

Data Sources (5)

SourceAliasJoin Type
I_MDChgProcessStep Step from
I_MDChgProcessStep Step union
I_MDChgProcessStep Step union
I_MDChgProcessStep Step union
I_MDChgProcessStep Step union

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_MDChgProcessOpenMatchGroup _OpenMatchGroup _OpenMatchGroup.MasterDataChangeProcess = MatchGroup.MasterDataChangeProcess and _OpenMatchGroup.MDChgProcessMatchGroupID = MatchGroup.MDChgProcessMatchGroupID
[0..1] I_MDChgProcKPIFilterRecordType _KPIRecordTypeText $projection.MDChgProcKPIRecordType = _KPIRecordTypeText.MDChangeProcKPIValueKey
[0..1] I_MDChgProcessStep _MTCStep $projection.MasterDataChangeProcess = _MTCStep.MasterDataChangeProcess and _MTCStep.MDChgProcessStepType = 'MTC' and _MTCStep.MDChgProcessSrceObjectTypeCode = '1405'

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Data of BP Hierarchies – TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess BPHierPrc MasterDataChangeProcess Process ID
KEY MDChgProcessStep BPHierPrc MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem BPHierPrc MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject BPHierPrc MDChgProcessSrceObject Source ID
MDChgProcKPIRecordType
MasterDataChangeProcess Process ID
KEY MDChgProcessStep BPHierPrc MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem BPHierPrc MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject BPHierPrc MDChgProcessSrceObject Source ID
MDChgProcKPIRecordType
MasterDataChangeProcess Process ID
KEY MDChgProcessStep BPHierPrc MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem BPHierPrc MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject BPHierPrc MDChgProcessSrceObject Source ID
MDChgProcKPIRecordType
MasterDataChangeProcess Process ID
KEY MDChgProcessStep BPHierPrc MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem BPHierPrc MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject BPHierPrc MDChgProcessSrceObject Source ID
MDChgProcKPIRecordType
MasterDataChangeProcess Process ID
KEY MDChgProcessStep BPHierPrc MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem BPHierPrc MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject BPHierPrc MDChgProcessSrceObject Source ID
MDChgProcKPIRecordType
_KPIRecordTypeText _KPIRecordTypeText

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_BPHierarchyProcKPIRecordType.
-- 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_BPHierarchyProcKPIRecordType AS
SELECT
  BPHierPrc.MasterDataChangeProcess AS MasterDataChangeProcess,
  BPHierPrc.MDChgProcessStep AS MDChgProcessStep,
  BPHierPrc.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  BPHierPrc.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  cast ('S' as mdc_kpi_filter_val ) AS MDChgProcKPIRecordType
FROM I_MDChgProcessStep AS Step
LEFT OUTER JOIN P_MDChgProcessOpenMatchGroup AS _OpenMatchGroup ON _OpenMatchGroup.MasterDataChangeProcess = MatchGroup.MasterDataChangeProcess AND _OpenMatchGroup.MDChgProcessMatchGroupID = MatchGroup.MDChgProcessMatchGroupID  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFilterRecordType AS _KPIRecordTypeText ON MDChgProcKPIRecordType = _KPIRecordTypeText.MDChangeProcKPIValueKey  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcessStep AS _MTCStep ON MasterDataChangeProcess = _MTCStep.MasterDataChangeProcess AND _MTCStep.MDChgProcessStepType = 'MTC' AND _MTCStep.MDChgProcessSrceObjectTypeCode = '1405'  -- association [0..1]
-- UNION with additional select branch(es): I_MDChgProcessStep
;

Learn More