TTXY - External tax interface: tax information

External tax interface: tax information information is stored in SAP table TTXY.
It is part of development package FYTX in software component FI-GL-GL. This development package consists of objects that can be grouped under "Interface to external systems for tax calculation".

Fields for table TTXY

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		ACCHD_KEY	0
MANDT	Client	X	MANDT	CLNT	6	*
AWTYP	Reference procedure	X	AWTYP	CHAR	10	*
AWREF	Reference document number	X	AWREF	CHAR	20
AWORG	Reference Organizational Units	X	AWORG	CHAR	20
KPOSN	Condition item number	X	KPOSN	NUMC	12
MWSKZ	Tax on sales/purchases code	X	MWSKZ	CHAR	4
SHPTO	Tax Jurisdiction	X	TXJCD	CHAR	30
.INCLUDE				COM_TAX	0
CLIENT	Client		MANDT	CLNT	6	*
COMP_CODE	Company Code		BUKRS	CHAR	8
DIVISION	Business Area		GSBER	CHAR	8	*
COUNTRY	Tax Departure Country/Region		LANDTX	CHAR	6	*
DOC_NUMBER	Document Number of an Accounting Document		BELNR_D	CHAR	20
POS_NO	Sales Document Item		POSNR_VA	NUMC	12
ACCNT_NO	Account number		KONTO	CHAR	32
ACCNT_CLS	Classification Item of an Account (Customer/Vendor)		KONTOCLASS	CHAR	20
TAX_DATE	Date in CHAR Format		DATE	CHAR	16
REP_DATE	Date in CHAR Format		DATE	CHAR	16
TXJCD_ST	Tax Jurisdiction		TXJCD	CHAR	30	*
TXJCD_SF	Tax Jurisdiction		TXJCD	CHAR	30	*
TXJCD_POA	Tax Jurisdiction		TXJCD	CHAR	30	*
TXJCD_POO	Tax Jurisdiction		TXJCD	CHAR	30	*
TXJCD_IND	Indicator: Jurisdiction Code Used for Tax Calculation		TXJCDIND	CHAR	2
PTP_IND	Indicator: Point of Title Passage		PTP_IND	CHAR	2
APAR_IND	Indicator for A/P or A/R		APAR_IND	CHAR	2
TXJCD_L1	Length of the Nth Part of the Tax Jurisdiction Code		LENGX_TXD	NUMC	4
TXJCD_L2	Length of the Nth Part of the Tax Jurisdiction Code		LENGX_TXD	NUMC	4
TXJCD_L3	Length of the Nth Part of the Tax Jurisdiction Code		LENGX_TXD	NUMC	4
TXJCD_L4	Length of the Nth Part of the Tax Jurisdiction Code		LENGX_TXD	NUMC	4
TAX_TYPE	Indicator: Sales/Use/Rental/Service/... Tax		TAXTYPEXT	CHAR	2
MATNR	Material number with 18 characters		TAXMATNR18	CHAR	36
PROD_CODE	SAP Internal Product Code (External Interface)		PROCD_TTXP	CHAR	20
QUANTITY	Quantity		QUANT_13	CHAR	26
UNIT	Unit		UNIT_3	CHAR	6
AMOUNT	Tax Base Amount		BASAMOUNT_CS	CHAR	30
CURRENCY	Currency Key		CURR_5	CHAR	10
CURR_DEC	Number of Decimal Places for Currency (Characters)		CURDECCHAR	CHAR	6
FREIGHT_AM	Freight Amount		FRTAMOUNT_CS	CHAR	30
EXEMPT_AMT	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXEMPT_IND	Indicator: Transaction Is Tax Exempt/Taxable		EXTEXMTFLG	CHAR	2
CREDIT_IND	Indicator: Tax Credit		EXTCREDFLG	CHAR	2
UPDATE_IND	Audit File Update Indicator (External Interface)		UPDATE_FLG	CHAR	2
OVWRT_IND	Overwrite Indicator		EXTOVRFLG	CHAR	2
TAXPCT0	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT1	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT2	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT3	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT4	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT5	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT6	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT7	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT8	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCT9	Level n Tax Rate		TAXPERCNT	CHAR	30
TAXPCOV	Total Tax Rate		TAXPERCNTG	CHAR	30
TAXAMT0	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT1	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT2	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT3	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT4	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT5	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT6	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT7	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT8	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMT9	Level n Tax Amount		TAXAMOUNT_CS	CHAR	30
TAXAMOV	Total Tax Amount		TAXAMOUNTG_CS	CHAR	30
TAXBAS0	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS1	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS2	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS3	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS4	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS5	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS6	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS7	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS8	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
TAXBAS9	Tax Base Amount Level n		TAXBASE_CS	CHAR	30
EXMATFLG	Code for Material Tax Exemption		EXMATCODE	CHAR	4
EXCUSFLG	Code for Customer Tax Exemption		EXCUSCODE	CHAR	4
EXAMT0	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT1	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT2	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT3	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT4	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT5	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT6	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT7	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT8	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXAMT9	Exempt Amount		EXMTAMOUNT_CS	CHAR	30
EXCODE0	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE1	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE2	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE3	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE4	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE5	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE6	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE7	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE8	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCODE9	Tax Exemption Reason Code		EXDETCODE	CHAR	4
EXCERTIF	Customer tax exemption certificate number defined in SAP		EXCERTIF	CHAR	50
EXREASON	Tax Exemption Reason Code		EXDETCODE	CHAR	4
USER_DATA	User-Specific Field		USER_DATA	CHAR	100
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16