MMPUR_SUPCONFH

Transparent Table Application Table
16 Fields 2 CDS Views

Supplier Confirmation Header

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
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