SAP Table VAT_ITEM_COND

Condition Record for Tax Calculation

VAT_ITEM_COND (Condition Record for Tax Calculation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VAT_ITEM_COND to other SAP tables.

Source: VAT_ITEM_COND (Condition Record for Tax Calculation)

VAT_ITEM_COND table fields

Field Data element Checktable Datatype Length Decimals
ITEMNR External-tax document number XTAX_DOCUMENT_NUMBER CHAR 12 0
BUKRS Company Code BUKRS CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
KSCHL Condition Type KSCHL CHAR 4 0
KTOSL Transaction Key KTOSL CHAR 3 0
KNUMH Condition record number KNUMH CHAR 10 0
KBETR Rate (condition amount or percentage) KBETR CURR 11 2
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS CUKY 5 0
TXJLV Tax jurisdiction code level TXJCD_LEVEL CHAR 1 0
TXJCD_ST Tax Jurisdiction TXJCD CHAR 15 0
HKONT General Ledger Account HKONT CHAR 10 0
FWBAS Tax Base Amount in Document Currency FWBAS CURR 13 2
FWSTE Tax Amount in Document Currency FWSTE CURR 13 2
FWCAL Tax Amount in Document Currency FWSTE CURR 13 2
NDDST Tax Amount in Document Currency FWSTE CURR 13 2
NDDPE Rate (condition amount or percentage) KBETR CURR 11 2
NDNST Tax Amount in Document Currency FWSTE CURR 13 2
NDNPE Rate (condition amount or percentage) KBETR CURR 11 2
DEDST Tax Amount in Document Currency FWSTE CURR 13 2
DEDPE Rate (condition amount or percentage) KBETR CURR 11 2
KSCHL_DEP Condition dependency KSCHL_DEP CHAR 4 0
PROPR T007B STRU 0 0
MANDT Client MANDT CLNT 3 0
KTOSL Internal processing key KTOSL_007B CHAR 3 0
STGRP Tax type STGRP_007B CHAR 1 0
1 Output tax
2 Input tax
3 Additional tax
4 Not relevant to tax
STAZF Indicator: Tax not deductible STAZF_007B CHAR 1 0
X Yes
NULL No
STBKZ Posting indicator STBKZ_007B CHAR 1 0
1 No posting required
2 Separate line item
3 Distribute to relevant expense/revenue items
STNSK Tax not relevant to cash discount STNSK_007B CHAR 1 0
X Yes
NULL No