PTXPTAX

Transparent Table Application Table
15 Fields 2 CDS Views

Proposal Tax Posting Table - Tax Data

PTXPTAX is an SAP database table in S/4HANA. Proposal Tax Posting Table - Tax Data. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_PROPOSE_TAX view left_outer Tax Proposal Posting
I_CsgnmtAndSTOTxPrpslTaxItem view from BASIC Tax Proposal Posting Tax Data

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ptxnr ptxnr Proposal Tax Posting UUID
KEY ptxit ptxit Proposal Tax Posting Item No.
KEY subno subno Sequence Number
taxbas taxbas Tax Base Amount (Net Value)
taxcode mwskz Tax Code
conditiontype kscha Condition Type
accountkey kvsl1 Account Key
taxdate taxdate Taxation Date
taxrate tax_rate Tax Rate
taxamt taxamt Tax Amount
is_input_tax is_input_tax Input Tax
taxcountry fot_tax_country Tax Ctry/Reg.
txdat_from fot_txdat_from Tax Rate Valid-From
condcalctype krech Calculat.Type

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 Table - Tax Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTXPTAX (
    MANDT,          -- Client [mandt]
    PTXNR,          -- Proposal Tax Posting UUID [ptxnr]
    PTXIT,          -- Proposal Tax Posting Item No. [ptxit]
    SUBNO,          -- Sequence Number [subno]
    TAXBAS,         -- Tax Base Amount (Net Value) [taxbas]
    TAXCODE,        -- Tax Code [mwskz]
    CONDITIONTYPE,  -- Condition Type [kscha]
    ACCOUNTKEY,     -- Account Key [kvsl1]
    TAXDATE,        -- Taxation Date [taxdate]
    TAXRATE,        -- Tax Rate [tax_rate]
    TAXAMT,         -- Tax Amount [taxamt]
    IS_INPUT_TAX,   -- Input Tax [is_input_tax]
    TAXCOUNTRY,     -- Tax Ctry/Reg. [fot_tax_country]
    TXDAT_FROM,     -- Tax Rate Valid-From [fot_txdat_from]
    CONDCALCTYPE,   -- Calculat.Type [krech]
    PRIMARY KEY (MANDT, PTXNR, PTXIT, SUBNO)
);

Learn More