MMPUR_SUPCONFH

Transparent Table Application Table
16 Fields 3 CDS Views

Supplier Confirmation Header

MMPUR_SUPCONFH is an SAP database table in S/4HANA. Supplier Confirmation Header. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_SupplierConfirmation view from EXTENSION Supplier Confirmation - Extension
m_v_supconfh_eop view from Relevant fields for setting the EOP-Flag in CONF
R_SupplierConfirmation view from BASIC Supplier Confirmation Header

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY confirmation_id mmpur_supplierconfno Confirmation
ref_purchase_order mmpur_refpurchaseorder Purchase Order
ernam ernam Created By
erdat erdat Created On
last_changed_datetime changedatetime Last Changed
bsart esart Document Type
ekorg ekorg Purchasing Org.
ekgrp bkgrp Purch. Group
iseopblocked eopblocked Busin. Purp. Cmpltd.
supplconfprocstate mmpur_supplconfstate Processing Status
lifnr elifn Supplier
ext_supplier_refid mmpur_ext_supplier_refid Supplier Reference
ext_last_changed_datetime mmpur_ext_changedatetime External Change
ext_system_id mmpur_extreferencesystemid Ext. Ref. System
creation_type mmpur_creation_type Creation Type

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.

-- Supplier Confirmation Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_SUPCONFH (
    CLIENT,                     -- Client [mandt]
    CONFIRMATION_ID,            -- Confirmation [mmpur_supplierconfno]
    REF_PURCHASE_ORDER,         -- Purchase Order [mmpur_refpurchaseorder]
    ERNAM,                      -- Created By [ernam]
    ERDAT,                      -- Created On [erdat]
    LAST_CHANGED_DATETIME,      -- Last Changed [changedatetime]
    BSART,                      -- Document Type [esart]
    EKORG,                      -- Purchasing Org. [ekorg]
    EKGRP,                      -- Purch. Group [bkgrp]
    ISEOPBLOCKED,               -- Busin. Purp. Cmpltd. [eopblocked]
    SUPPLCONFPROCSTATE,         -- Processing Status [mmpur_supplconfstate]
    LIFNR,                      -- Supplier [elifn]
    EXT_SUPPLIER_REFID,         -- Supplier Reference [mmpur_ext_supplier_refid]
    EXT_LAST_CHANGED_DATETIME,  -- External Change [mmpur_ext_changedatetime]
    EXT_SYSTEM_ID,              -- Ext. Ref. System [mmpur_extreferencesystemid]
    CREATION_TYPE,              -- Creation Type [mmpur_creation_type]
    PRIMARY KEY (CLIENT, CONFIRMATION_ID)
);

Learn More