PTXPI

Transparent Table Application Table
45 Fields 3 CDS Views

Proposal Tax Posting Item Table

PTXPI is an SAP database table in S/4HANA. Proposal Tax Posting Item Table. It contains 45 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_PROPOSE_TAX view left_outer Tax Proposal Posting
I_CsgnmtAndSTOTaxPrpslItem view from BASIC Tax Proposal Posting Item
P_PTXPI view from BASIC Primary key switch for PTXPI

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ptxnr ptxnr Proposal Tax Posting UUID
KEY ptxit ptxit Proposal Tax Posting Item No.
werks werks_d Plant
umwrk umwrk Receiving plant
zeile mblpo Mat. Doc.Item
posnr posnr_vl Item
charg charg_d Batch
uecha uecha HghLevItmBatch
xchar xchar Batches
smblp nsdm_smblp Reversed Doc Item
matnr matnr Material
fkimg fkimg Invoiced Qty
vrkme vrkme Sales Unit
fklmg fklmg Bill.Qty in SKU
meins meins Base Unit
ntgew ntgew_15 Net Weight
gewei gewei Unit of Weight
fbuda fbuda Serv. Rend. Dte
kursk kursk Exchange Rate
netwr netwr_fp Net Value
vgtyp vbtypl_v Prec.Doc.Categ.
aubel vbeln_va Sales Document
aupos posnr_va Item
arktx arktx Item Descr.
pstyv pstyv Item Category
autyp vbtypl Document Cat.
brtwr brtwr_fp Gross Value
grwrt grwrt Statist. Value
spe_herkl herkl C/R of Origin
spe_herkr herkr Reg. of Origin
itm_comco /sapsll/comco Commodity Code
nsdm_kunnr nsdm_kunnr Customer SID
kunag kunag Sold-to Party
kunag_adr adrnr_ag Sold-To Address
kunwe kunwe Ship-to Party
kunwe_adr adrnr_we Ship-to address
ptxpiuuid ptxpiuuid UUID
version ver_id Version ID
knumv knumv Doc. Condition
kposn kposn Item
kalsm kalsmasd Pric. Procedure
umvkz umvkz Numerator
umvkn umvkn Denominat.
lifnr lifnr 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.

-- Proposal Tax Posting Item Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTXPI (
    MANDT,       -- Client [mandt]
    PTXNR,       -- Proposal Tax Posting UUID [ptxnr]
    PTXIT,       -- Proposal Tax Posting Item No. [ptxit]
    WERKS,       -- Plant [werks_d]
    UMWRK,       -- Receiving plant [umwrk]
    ZEILE,       -- Mat. Doc.Item [mblpo]
    POSNR,       -- Item [posnr_vl]
    CHARG,       -- Batch [charg_d]
    UECHA,       -- HghLevItmBatch [uecha]
    XCHAR,       -- Batches [xchar]
    SMBLP,       -- Reversed Doc Item [nsdm_smblp]
    MATNR,       -- Material [matnr]
    FKIMG,       -- Invoiced Qty [fkimg]
    VRKME,       -- Sales Unit [vrkme]
    FKLMG,       -- Bill.Qty in SKU [fklmg]
    MEINS,       -- Base Unit [meins]
    NTGEW,       -- Net Weight [ntgew_15]
    GEWEI,       -- Unit of Weight [gewei]
    FBUDA,       -- Serv. Rend. Dte [fbuda]
    KURSK,       -- Exchange Rate [kursk]
    NETWR,       -- Net Value [netwr_fp]
    VGTYP,       -- Prec.Doc.Categ. [vbtypl_v]
    AUBEL,       -- Sales Document [vbeln_va]
    AUPOS,       -- Item [posnr_va]
    ARKTX,       -- Item Descr. [arktx]
    PSTYV,       -- Item Category [pstyv]
    AUTYP,       -- Document Cat. [vbtypl]
    BRTWR,       -- Gross Value [brtwr_fp]
    GRWRT,       -- Statist. Value [grwrt]
    SPE_HERKL,   -- C/R of Origin [herkl]
    SPE_HERKR,   -- Reg. of Origin [herkr]
    ITM_COMCO,   -- Commodity Code [/sapsll/comco]
    NSDM_KUNNR,  -- Customer SID [nsdm_kunnr]
    KUNAG,       -- Sold-to Party [kunag]
    KUNAG_ADR,   -- Sold-To Address [adrnr_ag]
    KUNWE,       -- Ship-to Party [kunwe]
    KUNWE_ADR,   -- Ship-to address [adrnr_we]
    PTXPIUUID,   -- UUID [ptxpiuuid]
    VERSION,     -- Version ID [ver_id]
    KNUMV,       -- Doc. Condition [knumv]
    KPOSN,       -- Item [kposn]
    KALSM,       -- Pric. Procedure [kalsmasd]
    UMVKZ,       -- Numerator [umvkz]
    UMVKN,       -- Denominat. [umvkn]
    LIFNR,       -- Supplier [lifnr]
    PRIMARY KEY (MANDT, PTXNR, PTXIT)
);

Learn More