MMPUR_SUPCONFD

Transparent Table Application Table
22 Fields 1 CDS Views

Supplier Confirmation Detail

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SupplierConfirmationLine view from BASIC Supplier Confirmation Line

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY confirmation_id mmpur_supplierconfno Confirmation
KEY confirmation_item mmpur_supplierconfitem Confirmation Item
KEY confirmation_line mmpur_supplierconfline Confirmation Line
uniqueid mmpur_conflineuniqueid Confirmation Line
ref_sequence_number mmpur_refsupplconfseqno ReferenceSeqNo
last_changed_datetime changedatetime Last Changed
ebtyp ebtyp Confirm. Cat.
eindt bbein Delivery Date
lpein bblpe Delivery Date
menge bbmng Quantity
meins bstme Order Unit
xblnr xblnr_long Reference
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_SUPCONFD (
    CLIENT,                     -- Client [mandt]
    CONFIRMATION_ID,            -- Confirmation [mmpur_supplierconfno]
    CONFIRMATION_ITEM,          -- Confirmation Item [mmpur_supplierconfitem]
    CONFIRMATION_LINE,          -- Confirmation Line [mmpur_supplierconfline]
    UNIQUEID,                   -- Confirmation Line [mmpur_conflineuniqueid]
    REF_SEQUENCE_NUMBER,        -- ReferenceSeqNo [mmpur_refsupplconfseqno]
    LAST_CHANGED_DATETIME,      -- Last Changed [changedatetime]
    EBTYP,                      -- Confirm. Cat. [ebtyp]
    EINDT,                      -- Delivery Date [bbein]
    LPEIN,                      -- Delivery Date [bblpe]
    MENGE,                      -- Quantity [bbmng]
    MEINS,                      -- Order Unit [bstme]
    XBLNR,                      -- Reference [xblnr_long]
    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, CONFIRMATION_ID, CONFIRMATION_ITEM, CONFIRMATION_LINE)
);

Learn More