MMSRCSLBUSPART_D

Transparent Table Application Table
23 Fields 2 CDS Views

Draft table for entity R_SRCGSUPLRLISTBUSPARTNERTP

MMSRCSLBUSPART_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGSUPLRLISTBUSPARTNERTP. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgSuplrListBusPartnerDraft view_entity from EXTENSION BusPartner for SrcgSuplrList - Extension
R_SrcgSuplrListBusPartnerDraft view_entity from BASIC Bus Partner for SrcgSuplrList - Draft

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY srcgsuplrlistbuspartuuid vdm_srcslbusinesspartneruuid Business Partner GUID
businesspartneruuid vdm_businesspartneruuid Business Partner UUID
supplier lifnr Supplier
businesspartner vdm_businesspartner Business Partner
addressnumber adrnr Address
suppliercountrygroup vdm_suppliercountrygroup Country/Region Group
sourcingsupplierlistuuid vdm_supplierlistuuid Supplier List UUID
suplrlistsupplierismandatory vdm_supplierismandatory Mandatory Supplier
businesspartnerisblocked bu_xblck Central Block
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
supplierlistupdatetype vdm_suplrlupdatetype Update Type
isdeleted eloek Del. Indicator
suplrlistsuplrdeltnreasontext vdm_instslsupldeltnreasontext Supplier Deletion Reason
suplrlistsupplieraddedbyuser vdm_purchaserresponsibleuser Purchaser Resp
country land1 Country/Reg.
emailaddress ad_smtpadr E-Mail Address
supplierlistname vdm_supplierlistname Supplier List Name
suppliername md_supplier_name Name of Supplier

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_SRCGSUPLRLISTBUSPARTNERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCSLBUSPART_D (
    MANDT,                          -- Client [mandt]
    SRCGSUPLRLISTBUSPARTUUID,       -- Business Partner GUID [vdm_srcslbusinesspartneruuid]
    BUSINESSPARTNERUUID,            -- Business Partner UUID [vdm_businesspartneruuid]
    SUPPLIER,                       -- Supplier [lifnr]
    BUSINESSPARTNER,                -- Business Partner [vdm_businesspartner]
    ADDRESSNUMBER,                  -- Address [adrnr]
    SUPPLIERCOUNTRYGROUP,           -- Country/Region Group [vdm_suppliercountrygroup]
    SOURCINGSUPPLIERLISTUUID,       -- Supplier List UUID [vdm_supplierlistuuid]
    SUPLRLISTSUPPLIERISMANDATORY,   -- Mandatory Supplier [vdm_supplierismandatory]
    BUSINESSPARTNERISBLOCKED,       -- Central Block [bu_xblck]
    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]
    SUPPLIERLISTUPDATETYPE,         -- Update Type [vdm_suplrlupdatetype]
    ISDELETED,                      -- Del. Indicator [eloek]
    SUPLRLISTSUPLRDELTNREASONTEXT,  -- Supplier Deletion Reason [vdm_instslsupldeltnreasontext]
    SUPLRLISTSUPPLIERADDEDBYUSER,   -- Purchaser Resp [vdm_purchaserresponsibleuser]
    COUNTRY,                        -- Country/Reg. [land1]
    EMAILADDRESS,                   -- E-Mail Address [ad_smtpadr]
    SUPPLIERLISTNAME,               -- Supplier List Name [vdm_supplierlistname]
    SUPPLIERNAME,                   -- Name of Supplier [md_supplier_name]
    PRIMARY KEY (MANDT, SRCGSUPLRLISTBUSPARTUUID)
);

Learn More