MDC_MATCH_GROU_H

Transparent Table Application Table
13 Fields 1 CDS Views

Historical Table for Match Groups

MDC_MATCH_GROU_H is an SAP database table in S/4HANA. Historical Table for Match Groups. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDChgProcMatchGroupHist view from BASIC MD Consolidation Historical Match Group

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY match_group_id MDC_MATCH_GROUP_ID Match Group
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
best_record ABAP_BOOLEAN Truth Value
approval_status MDC_APPROVAL_STATUS Approval Status
approver MDC_APPROVER Approver
approved_at MDC_APPROVAL_TIMESTAMP Approved at
original_match_group_id MDC_MATCH_GROUP_ID Match Group
previous_decision MDC_PREVIOUS_DECISION previous decision
previous_process_id MDC_PROCESS_ID Process ID
previous_match_group_id MDC_MATCH_GROUP_ID Match Group

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Historical Table for Match Groups
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDC_MATCH_GROU_H (
    CLIENT,                   -- Client [MANDT]
    PROCESS_ID,               -- Process ID [MDC_PROCESS_ID]
    MATCH_GROUP_ID,           -- Match Group [MDC_MATCH_GROUP_ID]
    SOURCE_SYSTEM,            -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                -- Source ID [MDC_SOURCE_ID]
    BEST_RECORD,              -- Truth Value [ABAP_BOOLEAN]
    APPROVAL_STATUS,          -- Approval Status [MDC_APPROVAL_STATUS]
    APPROVER,                 -- Approver [MDC_APPROVER]
    APPROVED_AT,              -- Approved at [MDC_APPROVAL_TIMESTAMP]
    ORIGINAL_MATCH_GROUP_ID,  -- Match Group [MDC_MATCH_GROUP_ID]
    PREVIOUS_DECISION,        -- previous decision [MDC_PREVIOUS_DECISION]
    PREVIOUS_PROCESS_ID,      -- Process ID [MDC_PROCESS_ID]
    PREVIOUS_MATCH_GROUP_ID,  -- Match Group [MDC_MATCH_GROUP_ID]
    PRIMARY KEY (CLIENT, PROCESS_ID, MATCH_GROUP_ID, SOURCE_SYSTEM, SOURCE_ID)
);

Learn More