MMPUR_CSUPCNFI

Transparent Table Application Table
14 Fields 1 CDS Views

Supplier Confirmation Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CntrlSupplierConfItem view from BASIC Central Supplier Confirmation Item

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY centralsupplierconfirmation mmpur_csuplrconfno Confirmation
KEY centralsupplierconfirmationitm mmpur_csuplrconfitm Confirmation Item
procurementhubsourcesystem mmpur_d_source_sys Connected System ID
cntrlsuplrconfitemuniqueid mmpur_cntrlconfitmunqid Confirmation Item
cntrlsuplrconfrefprmthbrpldpo mmpur_refpurchaseorder Purchase Order
cntrlsuplrconfrefprmthbpoitm mmpur_refpurchaseorderitem Purchase Order Item
lastchangedatetime changedatetime Last Changed
supplierconfirmednetprice mmpur_ext_net_price Confirmed Price
documentcurrency waers Currency
suplrconfitemexternalreference mmpur_ext_supplier_refid Supplier Reference
ext_last_changed_datetime mmpur_ext_changedatetime External Change
itemrejectedbysupplier abskz Rejection Ind.
cntrlsuplrconfacknnumber labnr Order Acknowl.

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_CSUPCNFI (
    CLIENT,                          -- Client [mandt]
    CENTRALSUPPLIERCONFIRMATION,     -- Confirmation [mmpur_csuplrconfno]
    CENTRALSUPPLIERCONFIRMATIONITM,  -- Confirmation Item [mmpur_csuplrconfitm]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [mmpur_d_source_sys]
    CNTRLSUPLRCONFITEMUNIQUEID,      -- Confirmation Item [mmpur_cntrlconfitmunqid]
    CNTRLSUPLRCONFREFPRMTHBRPLDPO,   -- Purchase Order [mmpur_refpurchaseorder]
    CNTRLSUPLRCONFREFPRMTHBPOITM,    -- Purchase Order Item [mmpur_refpurchaseorderitem]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    SUPPLIERCONFIRMEDNETPRICE,       -- Confirmed Price [mmpur_ext_net_price]
    DOCUMENTCURRENCY,                -- Currency [waers]
    SUPLRCONFITEMEXTERNALREFERENCE,  -- Supplier Reference [mmpur_ext_supplier_refid]
    EXT_LAST_CHANGED_DATETIME,       -- External Change [mmpur_ext_changedatetime]
    ITEMREJECTEDBYSUPPLIER,          -- Rejection Ind. [abskz]
    CNTRLSUPLRCONFACKNNUMBER,        -- Order Acknowl. [labnr]
    PRIMARY KEY (CLIENT, CENTRALSUPPLIERCONFIRMATION, CENTRALSUPPLIERCONFIRMATIONITM)
);

Learn More