MMSUPLRLIST2_D

Transparent Table Application Table

Draft table for entity R_SUPPLIERLISTTP

MMSUPLRLIST2_D is an SAP database table in S/4HANA. Draft table for entity R_SUPPLIERLISTTP. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SupplierListD view_entity from EXTENSION Supplier List - Extension
R_SupplierListD view_entity from BASIC Supplier List - Draft

Fields (19)

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
purchaserrespworkagreement vdm_purchaserresponsible Purchaser Responsible
purchaserresponsibleuser vdm_purchaserresponsibleuser Purchaser Resp
createdbyuser vdm_createdbyuserid Created By
creationdatetime vdm_suplrlistcreatedate Created On
lastchangedbyuser vdm_lastchangedbyuserid Changed By
lastchangedatetime changedatetime Last Changed
supplierlistislatest vdm_suplrlistislatest Latest Supplier List
isdeleted vdm_suplrlistisdeleted Is Deleted
supplierlistispublic vdm_suplrlistispublic Is Public
supplierlisthasallcompanycodes vdm_suplrlhasallcompanycodes SL Company Codes
suplrlisthaspurchasingcategory vdm_suplrlhaspuc
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.

-- Draft table for entity R_SUPPLIERLISTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSUPLRLIST2_D (
    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]
    PURCHASERRESPWORKAGREEMENT,      -- Purchaser Responsible [vdm_purchaserresponsible]
    PURCHASERRESPONSIBLEUSER,        -- Purchaser Resp [vdm_purchaserresponsibleuser]
    CREATEDBYUSER,                   -- Created By [vdm_createdbyuserid]
    CREATIONDATETIME,                -- Created On [vdm_suplrlistcreatedate]
    LASTCHANGEDBYUSER,               -- Changed By [vdm_lastchangedbyuserid]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    SUPPLIERLISTISLATEST,            -- Latest Supplier List [vdm_suplrlistislatest]
    ISDELETED,                       -- Is Deleted [vdm_suplrlistisdeleted]
    SUPPLIERLISTISPUBLIC,            -- Is Public [vdm_suplrlistispublic]
    SUPPLIERLISTHASALLCOMPANYCODES,  -- SL Company Codes [vdm_suplrlhasallcompanycodes]
    SUPLRLISTHASPURCHASINGCATEGORY,  -- vdm_suplrlhaspuc
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [eopblocked]
    PRIMARY KEY (MANDT, SUPPLIERLISTUUID)
);