SAP Table DEFTAX_ITEM

Data for Deferred Taxes

DEFTAX_ITEM (Data for Deferred Taxes) 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 DEFTAX_ITEM to other SAP tables.

Source: DEFTAX_ITEM (Data for Deferred Taxes)

DEFTAX_ITEM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
KTOSL Transaction Key KTOSL CHAR 3 0
ZBUKR Company Code BUKRS T001 CHAR 4 0
ZBELN Accounting Document Number BELNR_D CHAR 10 0
ZGJAH Fiscal Year GJAHR NUMC 4 0
ZBUZE Number of Line Item Within Accounting Document BUZEI NUMC 3 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
HKONT General Ledger Account HKONT SKB1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
KBETR Tax Rate KBETR_TAX CURR 11 2
HWBTR Gross Amount in Local Currency HWBTR_DEFTAX_ITEM CURR 15 2
FWBTR Gross Amount in Document Currency FWBTR_DEFTAX_ITEM CURR 15 2
HWSTE Tax Amount in Local Currency HWSTE CURR 13 2
FWSTE Tax Amount in Document Currency FWSTE CURR 13 2
LWBTR Gross Amount in National Currency LWBTR_DEFTAX_ITEM CURR 15 2
LWSTE Tax Amount in Country Currency LWSTE_BSET CURR 13 2
HZBET Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FZBET Tax base amount in document currency FWBAS_BSES CURR 15 2
LZBET Tax Base in Country Currency LWBAS_BSET CURR 15 2
HTEIL Part. Amt of Gross Amount in Local Currency to be Reported HTEIL_DEFTAX_ITEM CURR 15 2
FTEIL Part.Amt of Gross Amount in Document Currency to be Reported FTEIL_DEFTAX_ITEM CURR 15 2
LTEIL Part. Amt of Gross Amt in National Currency to be Reported LTEIL_DEFTAX_ITEM CURR 15 2
HTEIS Partial Amt of Tax Amount in Local Currency to be Reported HTEIS_DEFTAX_ITEM CURR 15 2
FTEIS Partial Amount of Tax Amount in Document Currency to be Rep. FTEIS_DEFTAX_ITEM CURR 15 2
LTEIS Part. Amt of Tax Amount in National Currency to be Reported LTEIS_DEFTAX_ITEM CURR 15 2
HSKON Cash Discount Amount of Payment in Local Currency HSKON_DEFTAX_ITEM CURR 15 2
FSKON Cash Discount Amount of Payment in Document Currency FSKON_DEFTAX_ITEM CURR 15 2
LSKON Cash Discount Amount of Payment in National Currency LSKON_DEFTAX_ITEM CURR 15 2
HSTRU Backdated Tax Calculation Amount in Local Currency HSTRU_DEFTAX_ITEM CURR 15 2
FSTRU Backdated Tax Calculation Amount in Document Currency FSTRU_DEFTAX_ITEM CURR 15 2
LSTRU Backdated Tax Calculation Amount in National Currency LSTRU_DEFTAX_ITEM CURR 15 2
LWAER Country currency WAERS_005 CUKY 5 0
XAUSG Relevant Document Has Been Cleared XAUSE CHAR 1 0
X Yes
NULL No
STMD1 Date from which Advance Tax Reporting Must Be Executed STMD1 DATS 8 0
STMD2 Date on Which the Tax Return Was Made STMDT_BSET DATS 8 0
STMT2 Time of Program Run for the Tax Return STMTI_BSET CHAR 6 0
REFERENCE Reference Field REF_DEFTAX_ITEM CHAR 20 0
LINE_TYPE Line category REF_LINE_TYPE CHAR 2 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
CBELN Clearing document number BELNR_C CHAR 10 0
CGJAH Clearing document fiscal year GJAHR_C NUMC 4 0
TBELN Tax transfer document BELNR_T CHAR 10 0
TGJAH Transfer document fiscal year GJAHR_T NUMC 4 0
RBELN Tax transfer reversal document BELNR_R CHAR 10 0
RGJAH Reversal document year GJAHR_R NUMC 4 0

DEFTAX_ITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DEFTAX_ITEM BUKRS DEFTAX_ITEM MANDT T001 Company Codes MANDT
DEFTAX_ITEM BUKRS DEFTAX_ITEM BUKRS T001 Company Codes BUKRS
DEFTAX_ITEM HKONT DEFTAX_ITEM MANDT SKB1 G/L account master (company code) MANDT
DEFTAX_ITEM HKONT DEFTAX_ITEM BUKRS SKB1 G/L account master (company code) BUKRS
DEFTAX_ITEM HKONT DEFTAX_ITEM HKONT SKB1 G/L account master (company code) SAKNR
DEFTAX_ITEM MANDT DEFTAX_ITEM MANDT T000 Clients MANDT
DEFTAX_ITEM MWSKZ DEFTAX_ITEM MANDT T007A Tax Keys MANDT
DEFTAX_ITEM MWSKZ T005 KALSM T007A Tax Keys KALSM
DEFTAX_ITEM MWSKZ DEFTAX_ITEM MWSKZ T007A Tax Keys MWSKZ
DEFTAX_ITEM ZBUKR DEFTAX_ITEM MANDT T001 Company Codes MANDT
DEFTAX_ITEM ZBUKR DEFTAX_ITEM ZBUKR T001 Company Codes BUKRS