PPS_T_SPQHDR_EXT

Transparent Table Application Table

PPS: SP Quotation Header Extension Table

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPS_SrcgProjQtnHdrExtn view_entity from BASIC PPS fields on Srcg Proj Quotation Header

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sourcingprojectquotationuuid VDM_SRCGPROJQUOTATIONUUID Supplier Quotation 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)
ppssrcprjbindgperdenddatetime PPS_E_SP_BINDING_END_DATE End of BP
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
ppssrcprjbindgperdenddate PPS_E_SP_BINDG_PERD_END_DATE End of Binding Period
ppssmartdocumentnumber PPS_E_SMT_DOC_NUMBER Smart Document Number

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 Quotation 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_SPQHDR_EXT (
    MANDT,                          -- Client [MANDT]
    SOURCINGPROJECTQUOTATIONUUID,   -- Supplier Quotation UUID [VDM_SRCGPROJQUOTATIONUUID]
    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]
    PPSSRCPRJBINDGPERDENDDATETIME,  -- End of BP [PPS_E_SP_BINDING_END_DATE]
    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]
    PPSSRCPRJBINDGPERDENDDATE,      -- End of Binding Period [PPS_E_SP_BINDG_PERD_END_DATE]
    PPSSMARTDOCUMENTNUMBER,         -- Smart Document Number [PPS_E_SMT_DOC_NUMBER]
    PRIMARY KEY (MANDT, SOURCINGPROJECTQUOTATIONUUID)
);