MMPUR_SUPCONFI

Transparent Table Application Table
15 Fields 1 CDS Views

Supplier Confirmation Item

MMPUR_SUPCONFI is an SAP database table in S/4HANA. Supplier Confirmation Item. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SupplierConfirmationItem view from BASIC Supplier Confirmation Item

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY confirmation_id MMPUR_SUPPLIERCONFNO Confirmation
KEY confirmation_item MMPUR_SUPPLIERCONFITEM Confirmation Item
uniqueid MMPUR_CONFITEMUNIQUEID Confirmation Item
ref_purchase_order MMPUR_REFPURCHASEORDER Purchase Order
ref_item MMPUR_REFPURCHASEORDERITEM Purchase Order Item
last_changed_datetime CHANGEDATETIME Last Changed
ext_net_price MMPUR_EXT_NET_PRICE Confirmed Price
waers WAERS Currency
ext_supplier_refid MMPUR_EXT_SUPPLIER_REFID Supplier Reference
abskz ABSKZ Rejection Ind.
ext_last_changed_datetime MMPUR_EXT_CHANGEDATETIME External Change
labnr LABNR Order Acknowl.
ext_orderpr_un MMPUR_EXT_ORDERPR_UN Order Price Un.
ext_price_unit MMPUR_EXT_PRICE_UNIT Ext Price Unit

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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_SUPCONFI (
    CLIENT,                     -- Client [MANDT]
    CONFIRMATION_ID,            -- Confirmation [MMPUR_SUPPLIERCONFNO]
    CONFIRMATION_ITEM,          -- Confirmation Item [MMPUR_SUPPLIERCONFITEM]
    UNIQUEID,                   -- Confirmation Item [MMPUR_CONFITEMUNIQUEID]
    REF_PURCHASE_ORDER,         -- Purchase Order [MMPUR_REFPURCHASEORDER]
    REF_ITEM,                   -- Purchase Order Item [MMPUR_REFPURCHASEORDERITEM]
    LAST_CHANGED_DATETIME,      -- Last Changed [CHANGEDATETIME]
    EXT_NET_PRICE,              -- Confirmed Price [MMPUR_EXT_NET_PRICE]
    WAERS,                      -- Currency [WAERS]
    EXT_SUPPLIER_REFID,         -- Supplier Reference [MMPUR_EXT_SUPPLIER_REFID]
    ABSKZ,                      -- Rejection Ind. [ABSKZ]
    EXT_LAST_CHANGED_DATETIME,  -- External Change [MMPUR_EXT_CHANGEDATETIME]
    LABNR,                      -- Order Acknowl. [LABNR]
    EXT_ORDERPR_UN,             -- Order Price Un. [MMPUR_EXT_ORDERPR_UN]
    EXT_PRICE_UNIT,             -- Ext Price Unit [MMPUR_EXT_PRICE_UNIT]
    PRIMARY KEY (CLIENT, CONFIRMATION_ID, CONFIRMATION_ITEM)
);

Learn More