PTXPH

Transparent Table Application Table
43 Fields 4 CDS Views

Proposal Tax Posting Header Table

PTXPH is an SAP database table in S/4HANA. Proposal Tax Posting Header Table. It contains 43 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_PROPOSE_TAX view from Tax Proposal Posting
I_CsgnmtAndSTOTaxPrpsl view from BASIC Tax Proposal Posting Header
I_GdsMvtGnrtdCustCsgnmtReg view inner BASIC Consignment Register from Goods Movement
I_TaxProposalPosting view from BASIC Interface for Tax Proposal Posting

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ptxnr ptxnr Proposal Tax Posting UUID
ptxtype ptxtype Process Type
ptxsubtype ptxsubtype Consignment Type
mblnr mblnr Material Doc.
mjahr mjahr Mat. Doc. Year
hdr_counter hdr_counter Matl. Doc. Header Counter
vbeln vbeln_vl Delivery
waerk waerk Doc. Currency
bukrs bukrs Company Code
smbln nsdm_smbln Reversed Mat Doc
sjahr nsdm_sjahr Reversed Doc Year
cr_counter cr_counter Canc./Rev. Matl Doc. Header
budat wadat_ist Actual GI Date
cpudt cpudt Entered On
cputm cputm Entered at
kunnr kunnr Customer
otaxcnty otaxcnty Tax Departure Ctry/Reg.
itaxcnty itaxcnty Tax Destination Ctry/Reg.
taxstatus taxstatus Tax Posting Status
reversecode reversecode Reversal Code
cancelcode cancelcode Cancellation Code
belnr belnr_d Document Number
gjahr gjahr Fiscal Year
fibudat fibudat Posting Date in FI Document
stceg stceg VAT Reg. No.
ostceg ostceg CoCd VAT in Tax Departure C/R
istceg istceg CoCd VAT No. in Tax Dest. C/R
ernam ernam Created By
erdat erdat Created On
erzet erzet Time
upnam upnam Changed By
updat updat Changed on
uptim uptim Changed At
inco1 inco1 Incoterms
kurrf kurrf Exch.Rate Acct.
land1 lland Dest. Ctry/Reg
regio regio Region
grwcu grwcu Currency
vkorg vkorg Sales Org.
obelnr belnr_dep Dep Cnty Acc No
ibelnr belnr_des Des Cnty Acc No
lfdat lfdat Delivery date

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 Header Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTXPH (
    MANDT,        -- Client [mandt]
    PTXNR,        -- Proposal Tax Posting UUID [ptxnr]
    PTXTYPE,      -- Process Type [ptxtype]
    PTXSUBTYPE,   -- Consignment Type [ptxsubtype]
    MBLNR,        -- Material Doc. [mblnr]
    MJAHR,        -- Mat. Doc. Year [mjahr]
    HDR_COUNTER,  -- Matl. Doc. Header Counter [hdr_counter]
    VBELN,        -- Delivery [vbeln_vl]
    WAERK,        -- Doc. Currency [waerk]
    BUKRS,        -- Company Code [bukrs]
    SMBLN,        -- Reversed Mat Doc [nsdm_smbln]
    SJAHR,        -- Reversed Doc Year [nsdm_sjahr]
    CR_COUNTER,   -- Canc./Rev. Matl Doc. Header [cr_counter]
    BUDAT,        -- Actual GI Date [wadat_ist]
    CPUDT,        -- Entered On [cpudt]
    CPUTM,        -- Entered at [cputm]
    KUNNR,        -- Customer [kunnr]
    OTAXCNTY,     -- Tax Departure Ctry/Reg. [otaxcnty]
    ITAXCNTY,     -- Tax Destination Ctry/Reg. [itaxcnty]
    TAXSTATUS,    -- Tax Posting Status [taxstatus]
    REVERSECODE,  -- Reversal Code [reversecode]
    CANCELCODE,   -- Cancellation Code [cancelcode]
    BELNR,        -- Document Number [belnr_d]
    GJAHR,        -- Fiscal Year [gjahr]
    FIBUDAT,      -- Posting Date in FI Document [fibudat]
    STCEG,        -- VAT Reg. No. [stceg]
    OSTCEG,       -- CoCd VAT in Tax Departure C/R [ostceg]
    ISTCEG,       -- CoCd VAT No. in Tax Dest. C/R [istceg]
    ERNAM,        -- Created By [ernam]
    ERDAT,        -- Created On [erdat]
    ERZET,        -- Time [erzet]
    UPNAM,        -- Changed By [upnam]
    UPDAT,        -- Changed on [updat]
    UPTIM,        -- Changed At [uptim]
    INCO1,        -- Incoterms [inco1]
    KURRF,        -- Exch.Rate Acct. [kurrf]
    LAND1,        -- Dest. Ctry/Reg [lland]
    REGIO,        -- Region [regio]
    GRWCU,        -- Currency [grwcu]
    VKORG,        -- Sales Org. [vkorg]
    OBELNR,       -- Dep Cnty Acc No [belnr_dep]
    IBELNR,       -- Des Cnty Acc No [belnr_des]
    LFDAT,        -- Delivery date [lfdat]
    PRIMARY KEY (MANDT, PTXNR)
);

Learn More