I_MDChgProcMatchGrpRecdCount

DDL: I_MDCHGPROCMATCHGRPRECDCOUNT Type: view_entity COMPOSITE
8 Fields 5 Data Sources

MD Cons Match Group Rec Count

I_MDChgProcMatchGrpRecdCount is a Composite CDS View that provides data about "MD Cons Match Group Rec Count" in SAP S/4HANA. It reads from 5 data sources (P_MDChgProcLastCmpltdMtchgStp, P_MDChgProcLastCmpltdMtchgStp, I_MDChgProcessStep, I_MasterDataChangeProcess, I_MDChgProcessStep) and exposes 8 fields with key fields MasterDataChangeProcess, MDChgProcessMatchGroupID, MDChgProcessSrceObjectTypeCode, MDChgProcessMatchGroupID, MDChgProcessSrceObjectTypeCode.

Data Sources (5)

SourceAliasJoin Type
P_MDChgProcLastCmpltdMtchgStp LastMTCStep inner
P_MDChgProcLastCmpltdMtchgStp LastMTCStep inner
I_MDChgProcessStep MatchingStep inner
I_MasterDataChangeProcess Process inner
I_MDChgProcessStep Step inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label MD Cons Match Group Rec Count view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MatchGroup MasterDataChangeProcess Process ID
KEY MDChgProcessMatchGroupID MatchGroup MDChgProcessMatchGroupID
KEY MDChgProcessSrceObjectTypeCode I_MDChgProcessStep MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessStep I_MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessMatchGroupID MatchGroup MDChgProcessMatchGroupID
KEY MDChgProcessSrceObjectTypeCode MatchGroup MDChgProcessSrceObjectTypeCode Bus. Obj. Type
MDChgProcessStep Step Number
MDChgProcessNmbrOfSrceRecords

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_MDChgProcMatchGrpRecdCount.
-- 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_MDChgProcMatchGrpRecdCount AS
SELECT
  MatchGroup.MasterDataChangeProcess AS MasterDataChangeProcess,
  MatchGroup.MDChgProcessMatchGroupID AS MDChgProcessMatchGroupID,
  Step.MDChgProcessSrceObjectTypeCode AS MDChgProcessSrceObjectTypeCode,
  Step.MDChgProcessStep AS MDChgProcessStep,
  count( * ) AS MDChgProcessNmbrOfSrceRecords
INNER JOIN P_MDChgProcLastCmpltdMtchgStp AS LastMTCStep ON /* join condition not captured in parsed metadata */
INNER JOIN I_MDChgProcessStep AS Step ON /* join condition not captured in parsed metadata */
INNER JOIN I_MasterDataChangeProcess AS Process ON /* join condition not captured in parsed metadata */
INNER JOIN I_MDChgProcessStep AS MatchingStep ON /* join condition not captured in parsed metadata */
;

Learn More