I_BPProcessKPIRecordType

DDL: I_BPPROCESSKPIRECORDTYPE Type: view_entity TRANSACTIONAL
5 Fields 3 Data Sources 3 Associations

MD Chg Proc Record Type KPI of a Record

I_BPProcessKPIRecordType is a Transactional CDS View that provides data about "MD Chg Proc Record Type KPI of a Record" in SAP S/4HANA. It reads from 3 data sources (I_BusinessPartnerProcess, I_MasterDataChangeProcess, I_MDChgProcessStep) and exposes 5 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 3 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_BusinessPartnerProcess BusinessPartner inner
I_MasterDataChangeProcess Process inner
I_MDChgProcessStep Step from

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 = '147' or _MTCStep.MDChgProcessSrceObjectTypeCode = '986' )

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label MD Chg Proc Record Type KPI of a Record view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_BusinessPartnerProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_BusinessPartnerProcess MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_BusinessPartnerProcess MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_BusinessPartnerProcess MDChgProcessSrceObject Source ID
_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_BPProcessKPIRecordType.
-- 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_BPProcessKPIRecordType AS
SELECT
  BusinessPartner.MasterDataChangeProcess AS MasterDataChangeProcess,
  BusinessPartner.MDChgProcessStep AS MDChgProcessStep,
  BusinessPartner.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  BusinessPartner.MDChgProcessSrceObject AS MDChgProcessSrceObject
FROM I_MDChgProcessStep AS Step
INNER JOIN I_MasterDataChangeProcess AS Process ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartnerProcess AS BusinessPartner ON /* join condition not captured in parsed metadata */
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 = '147' OR _MTCStep.MDChgProcessSrceObjectTypeCode = '986' )  -- association [0..1]
;

Learn More