PPS_T_SP_SUPREG

Transparent Table Application Table
14 Fields 1 CDS Views

Registered Supplier

PPS_T_SP_SUPREG is an SAP database table in S/4HANA. Registered Supplier. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPSSuplrListRegtrdSuplr view_entity from BASIC PPS Registered Supplier

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ppssupplierlistuuid PPS_E_REGISTRATIONINTERESTUUID Supplier Registration UUID
KEY businesspartner BU_PARTNER Bus. Partner
sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
supplier VDM_LIFNR Supplier
businesspartneruuid VDM_BUSINESSPARTNERUUID Business Partner UUID
createdbyuser PPS_E_SUPLRCREATEDBY User Name
creationdatetime PPS_E_SUPLRREGDATE Suuplier Regtrd On
ppssupplierregistrationstatus PPS_E_SUPPLIERSTATUS Supplier Status
ppssupplierrejectionreasontext PPS_E_REJECTIONREASON Rejection Reason
ppssupplierapprovaldatetime PPS_E_SUPLRAPPROVEDON Supplier Approved On
lastchangedatetime PPS_E_SUPLRLISTUPDATEDON Supplier Updated On
ppssuplrregistrationapprovedby PPS_E_SUPLRAPPROVEDBY Supplier Approved By
ppssuplrlistsuplrcrtdbybp PPS_E_SUPLRCRTDBYBP Created By

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.

-- Registered Supplier
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_T_SP_SUPREG (
    MANDT,                           -- Client [MANDT]
    PPSSUPPLIERLISTUUID,             -- Supplier Registration UUID [PPS_E_REGISTRATIONINTERESTUUID]
    BUSINESSPARTNER,                 -- Bus. Partner [BU_PARTNER]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    SUPPLIER,                        -- Supplier [VDM_LIFNR]
    BUSINESSPARTNERUUID,             -- Business Partner UUID [VDM_BUSINESSPARTNERUUID]
    CREATEDBYUSER,                   -- User Name [PPS_E_SUPLRCREATEDBY]
    CREATIONDATETIME,                -- Suuplier Regtrd On [PPS_E_SUPLRREGDATE]
    PPSSUPPLIERREGISTRATIONSTATUS,   -- Supplier Status [PPS_E_SUPPLIERSTATUS]
    PPSSUPPLIERREJECTIONREASONTEXT,  -- Rejection Reason [PPS_E_REJECTIONREASON]
    PPSSUPPLIERAPPROVALDATETIME,     -- Supplier Approved On [PPS_E_SUPLRAPPROVEDON]
    LASTCHANGEDATETIME,              -- Supplier Updated On [PPS_E_SUPLRLISTUPDATEDON]
    PPSSUPLRREGISTRATIONAPPROVEDBY,  -- Supplier Approved By [PPS_E_SUPLRAPPROVEDBY]
    PPSSUPLRLISTSUPLRCRTDBYBP,       -- Created By [PPS_E_SUPLRCRTDBYBP]
    PRIMARY KEY (MANDT, PPSSUPPLIERLISTUUID, BUSINESSPARTNER)
);

Learn More