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 EBELN Purchasing Doc.
cntrlsuplrconfrefprmthbpoitm EBELP 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,   -- Purchasing Doc. [EBELN]
    CNTRLSUPLRCONFREFPRMTHBPOITM,    -- Item [EBELP]
    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