1. Home
  2. Resources
  3. SAP Tables
  4. DTFITX_4 - Data Transfer: Tax Data According to BW (New)

SAP Table DTFITX_4

Data Transfer: Tax Data According to BW (New)

DTFITX_4 (Data Transfer: Tax Data According to BW (New)) 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 DTFITX_4 to other SAP tables.

DTFITX_4 table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
UMKRS Sales/Purchases Tax Group UMKRS CHAR 4 0
FISCPER Fiscal year / period RSFISCPER NUMC 7 0
FISCVAR Fiscal year variant RSFISCVAR CHAR 2 0
BELNR Accounting Document Number BELNR_BIW CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
KTOPL Chart of Accounts KTOPL CHAR 4 0
BLART Document Type BLART CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
XBLNR Reference Document Number XBLNR CHAR 16 0
WAERS Currency Key WAERS CUKY 5 0
MLDWAER Currency Key WAERS CUKY 5 0
VATTAXGROUP Group Number for Tax Amounts STEGRUNO NUMC 2 0
PSATZ Tax Rate VATTAXRATE CURR 11 2
KONWA Rate unit (currency or percentage) KONWA CUKY 5 0
STMELDETYP Control Message Type STMELDETYP CHAR 1 0
0 Confirmed as Input Tax
1 Confirmed as Output Tax
HWBAS Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS Tax base amount in document currency FWBAS_BSES CURR 15 2
HWSTE Tax Amount in Local Currency HWSTE CURR 13 2
FWSTE Tax Amount in Document Currency FWSTE CURR 13 2
MARK_NAF Selection of Non-Deductible Input Tax MARK_NAF CHAR 1 0
X Yes
NULL No
TKONT General Ledger Account HKONT CHAR 10 0
LOHNIND Subcontracting Indicator LOHNINDI CHAR 1 0
STCEG VAT Registration Number STCEG CHAR 20 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
EGRKZ EU Code / Code EGRKZ CHAR 1 0
NULL Non-EU-Relevant
1 Delivery of Goods Within the EU
2 Services Within the EU
3 Subcontracting Within the EU
4 Output Tax for Services within the EU
5 Reverse Charge EU: Service with Tax with Zero Balance
6 HU: Triangular Deal with Country Outside the EU
7 As for value '1', but tax balance zero
8 As for value '3', but tax balance zero
9 Acquisition Tax or General Tax with Zero Balance
A Reverse Charge with Tax with Zero Balance
M Spain: EU Goods Delivery - After Tax-Exempt Import
H EU Goods Delivery - After Tax-Exempt Import by Fiscal Agent
B Non-EU-Relevant, No Check on Input Tax Acct/Output Tax Acct
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
LSTML Country for Tax Return LAND1_STML CHAR 3 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWKEY Reference Key AWKEY CHAR 20 0
GJAHR Fiscal Year GJAHR NUMC 4 0
HKONT General Ledger Account HKONT CHAR 10 0
KBETR Rate (condition amount or percentage) where no scale exists KBETR_KOND CURR 11 2
KTOSL Transaction Key KTOSL CHAR 3 0
LWBAS Tax Base in Country Currency LWBAS_BSET CURR 15 2
LWSTE Tax Amount in Country Currency LWSTE_BSET CURR 13 2
MANDT Client MANDT CLNT 3 0
MONAT Fiscal Period MONAT NUMC 2 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit