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
purchaserresponsibleperson vdm_purchaserresponsibleperson 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.

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]
    PURCHASERRESPONSIBLEPERSON,      -- Purchaser Responsible [vdm_purchaserresponsibleperson]
    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]
    PRIMARY KEY (MANDT, SUPPLIERLISTUUID)
);

Learn More