MMPUR_SUPCONFD

Transparent Table Application Table
24 Fields 1 CDS Views

Supplier Confirmation Detail

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SupplierConfirmationLine view from BASIC Supplier Confirmation Line

Fields (24)

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
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_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]
    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, CONFIRMATION_ID, CONFIRMATION_ITEM, CONFIRMATION_LINE)
);

Learn More