MMSRCSLBUSPART

Transparent Table Application Table
18 Fields 2 CDS Views

Suppliers in Sourcing Supplier List

MMSRCSLBUSPART is an SAP database table in S/4HANA. Suppliers in Sourcing Supplier List. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgSuplrListBusinessPartner view_entity from EXTENSION Bus Partner for Srcg Suplr List - Extn
R_SrcgSuplrListBusinessPartner view from BASIC Bus Partner for Sourcing Supplier List

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY srcgsuplrlistbuspartuuid vdm_srcslbusinesspartneruuid Business Partner GUID
businesspartneruuid vdm_businesspartneruuid Business Partner UUID
supplier vdm_lifnr Supplier
businesspartner vdm_businesspartner Business Partner
addressnumber adrnr Address
suppliercountrygroup vdm_suppliercountrygroup Country/Region Group
sourcingsupplierlistuuid vdm_srcgsupplierlistuuid UUID of Sourcing Supplier List
suplrlistsupplierismandatory vdm_supplierismandatory Mandatory Supplier
suplrlistreferenceobjectuuid vdm_suplrlrefobjectuuid Ref Object UUID
supplierlistreferenceobject vdm_suplrlrefobject Reference Object
suplrlistreferenceobjecttype vdm_suplrlrefobjecttype Ref Obj Type for Sourcing Supplier List
sourcesupplierlistuuid vdm_sourcesuplrlistuuid Src Suplr List UUID
sourcesupplierlisttype vdm_sourcesuplrlisttype Source Supplier List Type
suplrlistsupplieraddedbyuser vdm_purchaserresponsibleuser Purchaser Resp
supplierlistupdatetype vdm_suplrlupdatetype Update Type
isdeleted eloek Del. Indicator
suplrlistsuplrdeltnreasontext vdm_instslsupldeltnreasontext Supplier Deletion Reason

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.

-- Suppliers in Sourcing Supplier List
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCSLBUSPART (
    MANDT,                          -- Client [mandt]
    SRCGSUPLRLISTBUSPARTUUID,       -- Business Partner GUID [vdm_srcslbusinesspartneruuid]
    BUSINESSPARTNERUUID,            -- Business Partner UUID [vdm_businesspartneruuid]
    SUPPLIER,                       -- Supplier [vdm_lifnr]
    BUSINESSPARTNER,                -- Business Partner [vdm_businesspartner]
    ADDRESSNUMBER,                  -- Address [adrnr]
    SUPPLIERCOUNTRYGROUP,           -- Country/Region Group [vdm_suppliercountrygroup]
    SOURCINGSUPPLIERLISTUUID,       -- UUID of Sourcing Supplier List [vdm_srcgsupplierlistuuid]
    SUPLRLISTSUPPLIERISMANDATORY,   -- Mandatory Supplier [vdm_supplierismandatory]
    SUPLRLISTREFERENCEOBJECTUUID,   -- Ref Object UUID [vdm_suplrlrefobjectuuid]
    SUPPLIERLISTREFERENCEOBJECT,    -- Reference Object [vdm_suplrlrefobject]
    SUPLRLISTREFERENCEOBJECTTYPE,   -- Ref Obj Type for Sourcing Supplier List [vdm_suplrlrefobjecttype]
    SOURCESUPPLIERLISTUUID,         -- Src Suplr List UUID [vdm_sourcesuplrlistuuid]
    SOURCESUPPLIERLISTTYPE,         -- Source Supplier List Type [vdm_sourcesuplrlisttype]
    SUPLRLISTSUPPLIERADDEDBYUSER,   -- Purchaser Resp [vdm_purchaserresponsibleuser]
    SUPPLIERLISTUPDATETYPE,         -- Update Type [vdm_suplrlupdatetype]
    ISDELETED,                      -- Del. Indicator [eloek]
    SUPLRLISTSUPLRDELTNREASONTEXT,  -- Supplier Deletion Reason [vdm_instslsupldeltnreasontext]
    PRIMARY KEY (MANDT, SRCGSUPLRLISTBUSPARTUUID)
);

Learn More