MMSUPLRLBUSPART

Transparent Table Application Table
19 Fields 2 CDS Views

Supplier List Business Partner

MMSUPLRLBUSPART is an SAP database table in S/4HANA. Supplier List Business Partner. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SupplierListBusinessPartner view_entity from EXTENSION Business Partner for Suplr List - Extn
R_SupplierListBusinessPartner view from BASIC Business Partner for Supplier List

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY suplrlistbusinesspartneruuid VDM_SUPLRLBUSINESSPARTNERUUID Supplier List Business Partner UUID
businesspartneruuid VDM_BUSINESSPARTNERUUID Business Partner UUID
businesspartner VDM_BUSINESSPARTNER Business Partner
supplierlistuuid VDM_SUPPLIERLISTUUID Supplier List UUID
suplrlistsupplierismandatory VDM_SUPPLIERISMANDATORY Mandatory Supplier
createdbyuser VDM_CREATEDBYUSERID Created By
creationdatetime VDM_SUPLRLISTCREATEDATE Created On
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
lastchangedatetime CHANGEDATETIME Last Changed
supplierisproposed VDM_SUPPLIERISPROPOSED Supplier Is Proposed
supplier LIFNR Supplier
addressnumber ADRNR Address
suppliercountrygroup VDM_SUPPLIERCOUNTRYGROUP Country/Region Group
supplierproposedbyuser VDM_PROPOSEDBYUSERID Created By
suplrlistsuplrproposalaction VDM_SUPLRLSUPLRPRPSLACTION Supplier Proposal Action
suplrlistsuplrproposalstatus VDM_SUPLRLBUPAPROPSTATUS Prop. Suplr. status
isdeleted VDM_SUPLRLISTISDELETED Is Deleted
dummy_suplrlbupa_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 Business Partner
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSUPLRLBUSPART (
    MANDT,                         -- Client [MANDT]
    SUPLRLISTBUSINESSPARTNERUUID,  -- Supplier List Business Partner UUID [VDM_SUPLRLBUSINESSPARTNERUUID]
    BUSINESSPARTNERUUID,           -- Business Partner UUID [VDM_BUSINESSPARTNERUUID]
    BUSINESSPARTNER,               -- Business Partner [VDM_BUSINESSPARTNER]
    SUPPLIERLISTUUID,              -- Supplier List UUID [VDM_SUPPLIERLISTUUID]
    SUPLRLISTSUPPLIERISMANDATORY,  -- Mandatory Supplier [VDM_SUPPLIERISMANDATORY]
    CREATEDBYUSER,                 -- Created By [VDM_CREATEDBYUSERID]
    CREATIONDATETIME,              -- Created On [VDM_SUPLRLISTCREATEDATE]
    LASTCHANGEDBYUSER,             -- Changed By [VDM_LASTCHANGEDBYUSERID]
    LASTCHANGEDATETIME,            -- Last Changed [CHANGEDATETIME]
    SUPPLIERISPROPOSED,            -- Supplier Is Proposed [VDM_SUPPLIERISPROPOSED]
    SUPPLIER,                      -- Supplier [LIFNR]
    ADDRESSNUMBER,                 -- Address [ADRNR]
    SUPPLIERCOUNTRYGROUP,          -- Country/Region Group [VDM_SUPPLIERCOUNTRYGROUP]
    SUPPLIERPROPOSEDBYUSER,        -- Created By [VDM_PROPOSEDBYUSERID]
    SUPLRLISTSUPLRPROPOSALACTION,  -- Supplier Proposal Action [VDM_SUPLRLSUPLRPRPSLACTION]
    SUPLRLISTSUPLRPROPOSALSTATUS,  -- Prop. Suplr. status [VDM_SUPLRLBUPAPROPSTATUS]
    ISDELETED,                     -- Is Deleted [VDM_SUPLRLISTISDELETED]
    DUMMY_SUPLRLBUPA_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SUPLRLISTBUSINESSPARTNERUUID)
);

Learn More