MMPUR_CSUPCNFD

Transparent Table Application Table
25 Fields 1 CDS Views

Supplier Confirmation Detail

MMPUR_CSUPCNFD is an SAP database table in S/4HANA. Supplier Confirmation Detail. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CntrlSupplierConfLine view from BASIC Central Supplier Confirmation Lines

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY centralsupplierconfirmation MMPUR_CSUPLRCONFNO Confirmation
KEY centralsupplierconfirmationitm MMPUR_CSUPLRCONFITM Confirmation Item
KEY centralsupplierconfline MMPUR_CNTRLCONFLINE Confirmation Line
procurementhubsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
centralsuplrconflineuniqueid MMPUR_CNTRLCONFLINEUNQID Confirmation Line
suplrconfrefsequencenumber MMPUR_REFSUPPLCONFSEQNO ReferenceSeqNo
lastchangedatetime CHANGEDATETIME Last Changed
supplierconfirmationcategory EBTYP Confirm. Cat.
deliverydate BBEIN Delivery Date
delivdatecategory BBLPE Delivery Date
confirmedquantity BBMNG Quantity
purchaseorderquantityunit BSTME Order Unit
supplierconfirmationextnumber XBLNR_LONG Reference
startdate MMPUR_SERVPROC_PERIOD_START Start Date
enddate MMPUR_SERVPROC_PERIOD_END End Date
serviceperformer SERVICEPERFORMER Service Performer
expected_value COMMITMENT Expected Value
waers WAERS Currency
ematn EMATN MPN: Material
uzeit BBUZE Time
sgt_scat SGT_SCAT Stock Segment
handoverdate HANDOVER_DATE Handover Date
handovertime HANDOVER_TIME Handover Time
ext_last_changed_datetime MMPUR_EXT_CHANGEDATETIME External Change

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 Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CSUPCNFD (
    CLIENT,                          -- Client [MANDT]
    CENTRALSUPPLIERCONFIRMATION,     -- Confirmation [MMPUR_CSUPLRCONFNO]
    CENTRALSUPPLIERCONFIRMATIONITM,  -- Confirmation Item [MMPUR_CSUPLRCONFITM]
    CENTRALSUPPLIERCONFLINE,         -- Confirmation Line [MMPUR_CNTRLCONFLINE]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    CENTRALSUPLRCONFLINEUNIQUEID,    -- Confirmation Line [MMPUR_CNTRLCONFLINEUNQID]
    SUPLRCONFREFSEQUENCENUMBER,      -- ReferenceSeqNo [MMPUR_REFSUPPLCONFSEQNO]
    LASTCHANGEDATETIME,              -- Last Changed [CHANGEDATETIME]
    SUPPLIERCONFIRMATIONCATEGORY,    -- Confirm. Cat. [EBTYP]
    DELIVERYDATE,                    -- Delivery Date [BBEIN]
    DELIVDATECATEGORY,               -- Delivery Date [BBLPE]
    CONFIRMEDQUANTITY,               -- Quantity [BBMNG]
    PURCHASEORDERQUANTITYUNIT,       -- Order Unit [BSTME]
    SUPPLIERCONFIRMATIONEXTNUMBER,   -- Reference [XBLNR_LONG]
    STARTDATE,                       -- Start Date [MMPUR_SERVPROC_PERIOD_START]
    ENDDATE,                         -- End Date [MMPUR_SERVPROC_PERIOD_END]
    SERVICEPERFORMER,                -- Service Performer [SERVICEPERFORMER]
    EXPECTED_VALUE,                  -- Expected Value [COMMITMENT]
    WAERS,                           -- Currency [WAERS]
    EMATN,                           -- MPN: Material [EMATN]
    UZEIT,                           -- Time [BBUZE]
    SGT_SCAT,                        -- Stock Segment [SGT_SCAT]
    HANDOVERDATE,                    -- Handover Date [HANDOVER_DATE]
    HANDOVERTIME,                    -- Handover Time [HANDOVER_TIME]
    EXT_LAST_CHANGED_DATETIME,       -- External Change [MMPUR_EXT_CHANGEDATETIME]
    PRIMARY KEY (CLIENT, CENTRALSUPPLIERCONFIRMATION, CENTRALSUPPLIERCONFIRMATIONITM, CENTRALSUPPLIERCONFLINE)
);

Learn More