TAX_ITEM - Tax Register Persistency

Tax Register Persistency information is stored in SAP table TAX_ITEM.
It is part of development package FIN_TAXREG_DB in software component FI-TXL-OPS. This development package consists of objects that can be grouped under "Tax Register DB".

Fields for table TAX_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
RCLNT	Client	X	MANDT	CLNT	6	T000
RBUKRS	Company Code	X	BUKRS	CHAR	8	T001
BELNR	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
GJAHR	Fiscal Year	X	GJAHR	NUMC	8
TAXRG_DOCLN	Number of Line Item within Tax Register	X	TXRG_BUZEI	NUMC	12
.INCLUDE	TRANSACTION_DETAILS			TXRG_TRANSACTION_DETAILS	0
TAX_COUNTRY	Tax Reporting Country/Region		FOT_TAX_COUNTRY	CHAR	6	T005
TAXATION_TYPE	Taxation Type		TXRG_TXN_TYPE	CHAR	10
TAXATION_REGIME	Tax Regime		TXRG_TXN_REGIME	CHAR	20
MATNR	Material Number		MATNR	CHAR	80	MARA
DESTINATION_COUNTRY	Country/Region of Destination for Delivery of Goods		EGBLD	CHAR	6	T005
SUPPLYING_COUNTRY	Supplying Country/Region for Delivery of Goods		EGLLD	CHAR	6	T005
DEF_TAX_DOC_NMBR	Deferred Tax Document Number		TXRG_DEF_TAX_DOCNUMBER	CHAR	20
DEF_TAX_DOC_FY	Fiscal Year of Deferred Tax Document		TXRG_DEF_TAX_DOC_FY	NUMC	8
DEF_TAX_ITEM	Deferred Tax Document Item Number		TXRG_DEF_TAX_ITM	NUMC	12
SRC_AWTYP	Source Document Type		FINS_SRC_AWTYP	CHAR	10	*
SRC_AWSYS	Source Document System		FINS_SRC_AWSYS	CHAR	20	*
SRC_AWORG	Organizational Unit of Source Document		FINS_SRC_AWORG	CHAR	20
SRC_AWREF	Source Document Number		FINS_SRC_AWREF	CHAR	20
SRC_AWITEM	Line Item in Source Document		FINS_SRC_AWITEM	NUMC	12
KTOSL	Transaction Key		KTOSL	CHAR	6
BLART	Document Type		BLART	CHAR	4	*
DRCRK	Debit/Credit Indicator		SHKZG	CHAR	2
DUE_CATEGORY	Due Category of TaxItem		TXRG_DUE_CATEGORY	CHAR	2
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
RACCT	Account Number		RACCT	CHAR	20	SKA1
CONDITION_TYPE	Condition Type		KSCHL	CHAR	8	T685
TAX_RATE	Tax Rate		TXRG_TAX_RATE	DEC	5
BUDAT	Posting Date in the Document		BUDAT	DATS	16
BLDAT	Document Date in Document		BLDAT	DATS	16
FULFILLDATE	Tax Fulfillment Date		FOT_FULFILLDATE	DATS	16
TAX_REPORTING_DATE	Tax Reporting Date		TXRG_TX_RPTG_DATE	DATS	16
TXDAT_FROM	Valid-From Date of the Tax Rate		FOT_TXDAT_FROM	DATS	16
LIFNR	Account Number of Supplier		LIFNR	CHAR	20	LFA1
KUNNR	Customer Number		KUNNR	CHAR	20	KNA1
TAX_GROUP	Group Indicator for Tax Line Items		TXGRP	NUMC	6
TAX_POSITION	Tax document item number		TAX_POSNR	NUMC	12
LINE_ITEM_STATUS	Line Item Status		TXRG_LINE_ITEM_STATUS	CHAR	2
EXEMPTION_RATE	Exemption Rate		TXRG_EXMP_RATE	DEC	5
EXEMPTION_REASON	Exemption Reason		TXRG_EXMP_REASON	CHAR	4
EXEMPTION_NUMBER	Exemption Number		TXRG_EXMP_NUMBER	CHAR	50
EXCHANGE_RATE	Exchange Rate		UKURS_CURR	DEC	5
EXCHANGE_RATE_TYPE	Exchange Rate Type		KURST_CURR	CHAR	8	TCURV
CURRENCY_EXCHANGE_DATE	Currency Exchange Date		TXRG_EXCHG_DATE	DATS	16
XDEFERRED_TAX	Indicator: Deferred Tax		TXRG_XDFRRD_TAX	CHAR	2
XREVERSING	Indicator: Item is Reversing Another Item		FINS_XREVERSING	CHAR	2
XREVERSED	Indicator: Item is Reversed		FINS_XREVERSED	CHAR	2
XTAX_AMT_MODIFD	Indicator: Tax Amount Modified		TXRG_XTXAMT_MODIFD	CHAR	2
XBASE_AMT_MODIFD	Indicator: Tax Base Amount Modified		TXRG_XTXBASEAMT_MODIFD	CHAR	2
.INCLUDE	CLEARING_DATA			TXRG_CLEARING_DATA	0
AUGBL	Document Number of the Clearing Document		AUGBL	CHAR	20
AUGDT	Clearing Date		AUGDT	DATS	16
AUGGJ	Fiscal Year of Clearing Document		AUGGJ	NUMC	8
TAX_PYBL_DOC_NMBR	Tax Payable Document Number		TXRG_TAXPYBL_DOCN	CHAR	20
TAX_PYBL_FISCAL_YEAR	Tax payable Fiscal Year		TXRG_TAXPYBL_FISCAL_YEAR	NUMC	8
TAX_PYBL_ITEM_NMBR	Item number in the payable document		TXRG_PYBL_ITEM_NMBR	NUMC	12
.INCLUDE	TRANSACTION_CURRENCIES			TXRG_TRANSACTION_CURRENCIES	0
BASE_AMT_CO_CRCY	Tax Base Amount in Company Code Currency		TXRG_BASE_AMT_CO_CRCY	CURR	12
TAX_AMT_CO_CRCY	Tax Amount in Company Code Currency		TXRG_TX_AMT_CO_CRCY	CURR	12
COMPANY_CODE_CURRENCY	Company Code Currency		FINS_CURRH	CUKY	10	TCURC
BASE_AMT_TRANS_CRCY	Tax Base Amount in Transaction Currency		TXRG_BASE_AMT_TRANS_CRCY	CURR	12
TAX_AMT_TRANS_CRCY	Tax Amount in Transaction Currency		TXRG_TX_AMT_TRANS_CRCY	CURR	12
TRANSACTION_CURRENCY	Transaction Currency		FINS_CURRW	CUKY	10	TCURC
BASE_AMT_RPTG_CRCY	Tax Base Amount in Reporting Currency		TXRG_BASE_AMT_RPTG_CRCY	CURR	12
TAX_AMT_RPTG_CRCY	Tax Amount in Reporting Currency		TXRG_TX_AMT_RPTG_CRCY	CURR	12
REPORTING_CURRENCY	Tax Reporting Currency		TXRG_CURRTR	CUKY	10	TCURC
.INCLUDE	TAX_ENTITY			TXRG_TAX_ENTITY	0
BP_TAXNUM	Business Partner Tax Number		BPTAXNUMXL	CHAR	120
ADDITIONAL_TAX_ENTITY_TYPE	Tax Entity Type		TXRG_ADDL_TAX_ENTITY_TYPE	CHAR	4
ADDITIONAL_TAX_ENTITY	Additional Tax Reporting Entity		TXRG_ADDL_TAX_ENTITY	CHAR	12
.INCLUDE	VAT			TXRG_GENERIC_VAT	0
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	T007A
XREVERSE_CHARGED	indicator: Is Reverse Charged?		TXRG_XREVERSE_CHARGED	CHAR	2
POSTING_INDICATOR	Posting indicator		STBKZ_007B	CHAR	2
XNONDEDUCTIBLE_TAX	Indicator: Tax not deductible		STAZF_007B	CHAR	2
MWART	Tax Type		MWART	CHAR	2