I_MDChgProcMatchGroupHist

DDL: I_MDCHGPROCMATCHGROUPHIST SQL: IMTCGRPHIST Type: view BASIC
8 Fields 1 Data Sources

MD Consolidation Historical Match Group

I_MDChgProcMatchGroupHist is a Basic CDS View that provides data about "MD Consolidation Historical Match Group" in SAP S/4HANA. It reads from 1 data source (mdc_match_grou_h) and exposes 8 fields with key fields MasterDataChangeProcess, MDChgProcessMatchGroupID, MDChgProcessSrceSystem, MDChgProcessSrceObject, MDChgProcessSrceObjectTypeCode.

Data Sources (1)

SourceAliasJoin Type
mdc_match_grou_h mdc_match_grou_h from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMTCGRPHIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MD Consolidation Historical Match Group view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess process_id Process Instance ID
KEY MDChgProcessMatchGroupID match_group_id Match Group
KEY MDChgProcessSrceSystem source_system Source System
KEY MDChgProcessSrceObject source_id UUID
KEY MDChgProcessSrceObjectTypeCode
MDChgProcMatchGrpIsBestRecord best_record Truth Value
MDChgProcMatchGrpApprvlStatus approval_status Status
MDChgProcMatchGroupApprover approver PPA Req Approver

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_MDChgProcMatchGroupHist.
-- 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.
-- SQL view name: IMTCGRPHIST

CREATE VIEW I_MDChgProcMatchGroupHist AS
SELECT
  process_id AS MasterDataChangeProcess,
  match_group_id AS MDChgProcessMatchGroupID,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  cast( '' as mdc_object_type_code ) AS MDChgProcessSrceObjectTypeCode,
  best_record AS MDChgProcMatchGrpIsBestRecord,
  approval_status AS MDChgProcMatchGrpApprvlStatus,
  approver AS MDChgProcMatchGroupApprover
FROM mdc_match_grou_h
;

Learn More