MMSPPUBDSPLRL

Transparent Table Application Table
15 Fields 2 CDS Views

Sourcing Project Published Supplier List

MMSPPUBDSPLRL is an SAP database table in S/4HANA. Sourcing Project Published Supplier List. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgProjPubdSupplierList view_entity from EXTENSION Bus Part in Pubd Suplr List in SrcPrj - Extn
R_SrcgProjPubdSuplrListBP view from BASIC Bus Part in Pubd Suplr List in Srcg Proj

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY srcgprojpubdsuplrlistuuid vdm_srcgprojpubdsuplrlistuuid Published Supplier List UUID
sourcingprojectuuid vdm_sourcingprojectuuid Sourcing Project UUID
srcgsuplrlistbuspartuuid vdm_srcslbusinesspartneruuid Business Partner GUID
sourcingsupplierlistuuid vdm_srcgsupplierlistuuid UUID of Sourcing Supplier List
supplierlistuuid vdm_supplierlistuuid Supplier List UUID
sourcingprojectisrefused vdm_sourcingprojectisrefused Participation Declined
srcgprojsupplierlockstatus vdm_srcgprojsupplierlockstatus Supplier Lock Status
srcgprojparticipationstatus vdm_srcgprojparticipationsts Supplier Participation Status
qtnextendedlatestsubmsndtetime vdm_qtnextlatestsubmdtetime Submission Deadline
srcgprojsuplrpartcipndclnrsn mm_pur_srcgproj_reason Reason
srcgprojpubdsuplrlistsuplrsts vdm_srcgprojpbdsplrlistsplrsts Supplier Status
srcgprojpubdsuplrinsrtdatetime vdm_srcgprojpbdsplrinsrtdtetim Added On
sourcingorigin vdm_sourcingorigin Sourcing Origin
sourcingscenario vdm_sourcingscenario Integration Scenario

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.

-- Sourcing Project Published Supplier List
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPPUBDSPLRL (
    MANDT,                           -- Client [mandt]
    SRCGPROJPUBDSUPLRLISTUUID,       -- Published Supplier List UUID [vdm_srcgprojpubdsuplrlistuuid]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [vdm_sourcingprojectuuid]
    SRCGSUPLRLISTBUSPARTUUID,        -- Business Partner GUID [vdm_srcslbusinesspartneruuid]
    SOURCINGSUPPLIERLISTUUID,        -- UUID of Sourcing Supplier List [vdm_srcgsupplierlistuuid]
    SUPPLIERLISTUUID,                -- Supplier List UUID [vdm_supplierlistuuid]
    SOURCINGPROJECTISREFUSED,        -- Participation Declined [vdm_sourcingprojectisrefused]
    SRCGPROJSUPPLIERLOCKSTATUS,      -- Supplier Lock Status [vdm_srcgprojsupplierlockstatus]
    SRCGPROJPARTICIPATIONSTATUS,     -- Supplier Participation Status [vdm_srcgprojparticipationsts]
    QTNEXTENDEDLATESTSUBMSNDTETIME,  -- Submission Deadline [vdm_qtnextlatestsubmdtetime]
    SRCGPROJSUPLRPARTCIPNDCLNRSN,    -- Reason [mm_pur_srcgproj_reason]
    SRCGPROJPUBDSUPLRLISTSUPLRSTS,   -- Supplier Status [vdm_srcgprojpbdsplrlistsplrsts]
    SRCGPROJPUBDSUPLRINSRTDATETIME,  -- Added On [vdm_srcgprojpbdsplrinsrtdtetim]
    SOURCINGORIGIN,                  -- Sourcing Origin [vdm_sourcingorigin]
    SOURCINGSCENARIO,                -- Integration Scenario [vdm_sourcingscenario]
    PRIMARY KEY (MANDT, SRCGPROJPUBDSUPLRLISTUUID)
);

Learn More