PPS_T_SP_HDR_EXT

Transparent Table Application Table

PPS: SP Header Extension Table

PPS_T_SP_HDR_EXT is an SAP database table in S/4HANA. PPS: SP Header Extension Table. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPS_SrcgProjHdrExtn view_entity from BASIC PPS fields on Sourcing Project Header

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
ppshdrretentiontype RETTP Retention
ppshdrretentionpercent RETPZ Retention %
ppshdrdownpaymenttype ME_DPTYP Down Payment
ppshdrdownpaymentpercent ME_DPPCNT Down Payment %
ppshdrdownpaymentdays PPS_E_DOWN_PAYMENT_TIME Dwn Payt Time (Days)
ppssmartnumberheader PPS_E_SMT_SMART_NUMBER Smart Number
ppssmartdocumentnumber PPS_E_SMT_DOC_NUMBER Smart Document Number
ppssmartnumberheaderismanual XFELD Checkbox
ppsrevisionreasoncode RSCOD Reason for Change
ppsrevisioncomment PPS_E_VER_REASON_TEXT Revision Comment
ppsmodificationtype PPS_E_MODI_TYPE Modification Type
ppsmodificationtypetext PPS_E_MODI_TEXT Reason Text
ppssrcgprojnmbrofmodification PPS_E_MODI_NUMBER_SP Modif Number
ppssrcgprojproceduretype PPS_E_SP_PROC_TYPE Procedure Type
ppsguaranteedminimumamount PPS_E_GUARANTEE_MIN_AMT Guar Min Amt
ppsguaranteedminimumcurrency PPS_E_GUARANTEE_MIN_CURR Guar Min Curr
ppsisguaranteedminimumforitem PPS_E_GUARANTEE_MIN_ENABLED Guar Min
ppsperdofperfstartdate PPS_E_PEROP_START_DATE Period of Performance Start Date
ppsperdofperfenddate PPS_E_PEROP_END_DATE Period of Performance End Date
ppssrcgprojstrtdatetime PPS_E_SP_START_DATE Start Date
ppssrcgprojopngdatetime PPS_E_SP_OPENING_DATE Opening Date
ppssrcprjsuplrregnddlndatetime PPS_E_SP_REGISTRATION_DEADLINE Registration Deadline
ppssrcprjbindgperdenddate PPS_E_SP_BINDG_PERD_END_DATE End of Binding Period
ppssrcgprojprepublishsts PPS_E_PRE_PUBLISH_STS Pre-Publish Status

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.

-- PPS: SP Header Extension Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_T_SP_HDR_EXT (
    MANDT,                           -- Client [MANDT]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    PPSHDRRETENTIONTYPE,             -- Retention [RETTP]
    PPSHDRRETENTIONPERCENT,          -- Retention % [RETPZ]
    PPSHDRDOWNPAYMENTTYPE,           -- Down Payment [ME_DPTYP]
    PPSHDRDOWNPAYMENTPERCENT,        -- Down Payment % [ME_DPPCNT]
    PPSHDRDOWNPAYMENTDAYS,           -- Dwn Payt Time (Days) [PPS_E_DOWN_PAYMENT_TIME]
    PPSSMARTNUMBERHEADER,            -- Smart Number [PPS_E_SMT_SMART_NUMBER]
    PPSSMARTDOCUMENTNUMBER,          -- Smart Document Number [PPS_E_SMT_DOC_NUMBER]
    PPSSMARTNUMBERHEADERISMANUAL,    -- Checkbox [XFELD]
    PPSREVISIONREASONCODE,           -- Reason for Change [RSCOD]
    PPSREVISIONCOMMENT,              -- Revision Comment [PPS_E_VER_REASON_TEXT]
    PPSMODIFICATIONTYPE,             -- Modification Type [PPS_E_MODI_TYPE]
    PPSMODIFICATIONTYPETEXT,         -- Reason Text [PPS_E_MODI_TEXT]
    PPSSRCGPROJNMBROFMODIFICATION,   -- Modif Number [PPS_E_MODI_NUMBER_SP]
    PPSSRCGPROJPROCEDURETYPE,        -- Procedure Type [PPS_E_SP_PROC_TYPE]
    PPSGUARANTEEDMINIMUMAMOUNT,      -- Guar Min Amt [PPS_E_GUARANTEE_MIN_AMT]
    PPSGUARANTEEDMINIMUMCURRENCY,    -- Guar Min Curr [PPS_E_GUARANTEE_MIN_CURR]
    PPSISGUARANTEEDMINIMUMFORITEM,   -- Guar Min [PPS_E_GUARANTEE_MIN_ENABLED]
    PPSPERDOFPERFSTARTDATE,          -- Period of Performance Start Date [PPS_E_PEROP_START_DATE]
    PPSPERDOFPERFENDDATE,            -- Period of Performance End Date [PPS_E_PEROP_END_DATE]
    PPSSRCGPROJSTRTDATETIME,         -- Start Date [PPS_E_SP_START_DATE]
    PPSSRCGPROJOPNGDATETIME,         -- Opening Date [PPS_E_SP_OPENING_DATE]
    PPSSRCPRJSUPLRREGNDDLNDATETIME,  -- Registration Deadline [PPS_E_SP_REGISTRATION_DEADLINE]
    PPSSRCPRJBINDGPERDENDDATE,       -- End of Binding Period [PPS_E_SP_BINDG_PERD_END_DATE]
    PPSSRCGPROJPREPUBLISHSTS,        -- Pre-Publish Status [PPS_E_PRE_PUBLISH_STS]
    PRIMARY KEY (MANDT, SOURCINGPROJECTUUID)
);