SAP table DEFTAX_ITEM (Data for Deferred Taxes)

SAP table DEFTAX_ITEM has 10 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI,KTOSL,ZBUKR,ZBELN,ZGJAH,ZBUZE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

DEFTAX_ITEM foreign key relationships

Table Field Check Table Check Field
0 DEFTAX_ITEM BUKRS T001 Company Codes BUKRS
1 DEFTAX_ITEM HKONT SKB1 G/L account master (company code) MANDT
1 DEFTAX_ITEM HKONT SKB1 G/L account master (company code) BUKRS
0 DEFTAX_ITEM MANDT T000 Clients MANDT
1 DEFTAX_ITEM MWSKZ T007A Tax Keys KALSM
1 DEFTAX_ITEM MWSKZ T007A Tax Keys MWSKZ
0 DEFTAX_ITEM ZBUKR T001 Company Codes BUKRS