MMSUPLRLIST

Transparent Table Application Table
21 Fields 2 CDS Views

Supplier List Header

MMSUPLRLIST is an SAP database table in S/4HANA. Supplier List Header. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SupplierList view_entity from EXTENSION Supplier List - Extension
R_SupplierList view from BASIC Supplier List

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY supplierlistuuid VDM_SUPPLIERLISTUUID Supplier List UUID
supplierlist VDM_SUPPLIERLIST Supplier List
supplierlistversion VDM_SUPPLIERLISTVERSION Suplr List Version
supplierlisttype VDM_SUPPLIERLISTTYPE Supplier List Type
supplierlistname VDM_SUPPLIERLISTNAME Supplier List Name
suplrlistlifecyclestatus VDM_SUPLRLISTLFCYCSTS SL Lifecycle Status
purchaserresponsible VDM_PURCHASERRESPONSIBLE Purchaser Responsible
purchaserrespworkagreement VDM_PURCHASERRESPONSIBLE Purchaser Responsible
supplierlistislatest VDM_SUPLRLISTISLATEST Latest Supplier List
supplierlistispublic VDM_SUPLRLISTISPUBLIC Is Public
supplierlisthasallcompanycodes VDM_SUPLRLHASALLCOMPANYCODES SL Company Codes
materialgroup MATKL Material Group
createdbyuser VDM_CREATEDBYUSERID Created By
creationdatetime VDM_SUPLRLISTCREATEDATE Created On
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
lastchangedatetime CHANGEDATETIME Last Changed
purchaserresponsibleuser VDM_PURCHASERRESPONSIBLEUSER Purchaser Resp
isdeleted VDM_SUPLRLISTISDELETED Is Deleted
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
dummy_suplrlisthdr_incl_eew_ps CFD_DUMMY Dummy

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 List Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSUPLRLIST (
    MANDT,                           -- Client [MANDT]
    SUPPLIERLISTUUID,                -- Supplier List UUID [VDM_SUPPLIERLISTUUID]
    SUPPLIERLIST,                    -- Supplier List [VDM_SUPPLIERLIST]
    SUPPLIERLISTVERSION,             -- Suplr List Version [VDM_SUPPLIERLISTVERSION]
    SUPPLIERLISTTYPE,                -- Supplier List Type [VDM_SUPPLIERLISTTYPE]
    SUPPLIERLISTNAME,                -- Supplier List Name [VDM_SUPPLIERLISTNAME]
    SUPLRLISTLIFECYCLESTATUS,        -- SL Lifecycle Status [VDM_SUPLRLISTLFCYCSTS]
    PURCHASERRESPONSIBLE,            -- Purchaser Responsible [VDM_PURCHASERRESPONSIBLE]
    PURCHASERRESPWORKAGREEMENT,      -- Purchaser Responsible [VDM_PURCHASERRESPONSIBLE]
    SUPPLIERLISTISLATEST,            -- Latest Supplier List [VDM_SUPLRLISTISLATEST]
    SUPPLIERLISTISPUBLIC,            -- Is Public [VDM_SUPLRLISTISPUBLIC]
    SUPPLIERLISTHASALLCOMPANYCODES,  -- SL Company Codes [VDM_SUPLRLHASALLCOMPANYCODES]
    MATERIALGROUP,                   -- Material Group [MATKL]
    CREATEDBYUSER,                   -- Created By [VDM_CREATEDBYUSERID]
    CREATIONDATETIME,                -- Created On [VDM_SUPLRLISTCREATEDATE]
    LASTCHANGEDBYUSER,               -- Changed By [VDM_LASTCHANGEDBYUSERID]
    LASTCHANGEDATETIME,              -- Last Changed [CHANGEDATETIME]
    PURCHASERRESPONSIBLEUSER,        -- Purchaser Resp [VDM_PURCHASERRESPONSIBLEUSER]
    ISDELETED,                       -- Is Deleted [VDM_SUPLRLISTISDELETED]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    DUMMY_SUPLRLISTHDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SUPPLIERLISTUUID)
);

Learn More