SAP Table TTXY - External tax interface: tax information

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
AWTYP X AWTYP CHAR 3 5 0 Reference Transaction
AWREF X AWREF CHAR 8 10 0 Reference Document Number
AWORG X AWORG CHAR 18 10 0 Reference Organizational Units
KPOSN X KPOSN NUMC 28 6 0 Condition item number
MWSKZ X MWSKZ CHAR 34 2 0 Sales Tax Code
SHPTO X TXJCD CHAR 36 15 0 TTXJ Tax Jurisdiction
CLIENT MANDT CLNT 51 3 0 T000 Client
COMP_CODE BUKRS CHAR 54 4 0 T001 Company Code
DIVISION GSBER CHAR 58 4 0 TGSB Business Area
COUNTRY LANDTX CHAR 62 3 0 T005 Tax departure country
DOC_NUMBER BELNR_D CHAR 65 10 0 Accounting Document Number
POS_NO POSNR_VA NUMC 75 6 0 Sales Document Item
ACCNT_NO KONTO CHAR 81 16 0 Account number
ACCNT_CLS KONTOCLASS CHAR 97 10 0 Classification item of an account (Customer/vendor)
TAX_DATE DATE CHAR 107 8 0 Date in CHAR format
REP_DATE DATE CHAR 115 8 0 Date in CHAR format
TXJCD_ST TXJCD CHAR 123 15 0 TTXJ Tax Jurisdiction
TXJCD_SF TXJCD CHAR 138 15 0 TTXJ Tax Jurisdiction
TXJCD_POA TXJCD CHAR 153 15 0 TTXJ Tax Jurisdiction
TXJCD_POO TXJCD CHAR 168 15 0 TTXJ Tax Jurisdiction
TXJCD_IND TXJCDIND CHAR 183 1 0 Indicator: Jurisdiction code used for tax calculation
PTP_IND PTP_IND CHAR 184 1 0 Indicator: Point of Title Passage
APAR_IND APAR_IND CHAR 185 1 0 Indicator for A/P or A/R
TXJCD_L1 LENGX_TXD NUMC 186 2 0 Length of the Nth Part of the Tax Jurisdiction Code
TXJCD_L2 LENGX_TXD NUMC 188 2 0 Length of the Nth Part of the Tax Jurisdiction Code
TXJCD_L3 LENGX_TXD NUMC 190 2 0 Length of the Nth Part of the Tax Jurisdiction Code
TXJCD_L4 LENGX_TXD NUMC 192 2 0 Length of the Nth Part of the Tax Jurisdiction Code
TAX_TYPE TAXTYPEXT CHAR 194 1 0 Indicator: Sales/use/rental/service/tax
MATNR TAXMATNR18 CHAR 195 18 0 Material number with 18 characters
PROD_CODE PROCD_TTXP CHAR 213 10 0 SAP internal product code (external interface)
QUANTITY QUANT_13 CHAR 223 13 0 Quantity
UNIT UNIT_3 CHAR 236 3 0 Unit
AMOUNT BASAMOUNT CHAR 239 15 0 Tax base amount
CURRENCY CURR_5 CHAR 254 5 0 Currency Key
CURR_DEC CURDECCHAR CHAR 259 3 0 Number of decimal places for currency (characters)
FREIGHT_AM FRTAMOUNT CHAR 262 15 0 Freight Amount
EXEMPT_AMT EXMTAMOUNT CHAR 277 15 0 Exempt amount
EXEMPT_IND EXTEXMTFLG CHAR 292 1 0 Indicator: Transaction is tax exempt/taxable
CREDIT_IND EXTCREDFLG CHAR 293 1 0 Indicator: Tax credit
UPDATE_IND UPDATE_FLG CHAR 294 1 0 Audit file update indicator (external interface)
OVWRT_IND EXTOVRFLG CHAR 295 1 0 Overwrite indicator
TAXPCT0 TAXPERCNT CHAR 296 15 0 Level n tax rate
TAXPCT1 TAXPERCNT CHAR 311 15 0 Level n tax rate
TAXPCT2 TAXPERCNT CHAR 326 15 0 Level n tax rate
TAXPCT3 TAXPERCNT CHAR 341 15 0 Level n tax rate
TAXPCT4 TAXPERCNT CHAR 356 15 0 Level n tax rate
TAXPCT5 TAXPERCNT CHAR 371 15 0 Level n tax rate
TAXPCT6 TAXPERCNT CHAR 386 15 0 Level n tax rate
TAXPCT7 TAXPERCNT CHAR 401 15 0 Level n tax rate
TAXPCT8 TAXPERCNT CHAR 416 15 0 Level n tax rate
TAXPCT9 TAXPERCNT CHAR 431 15 0 Level n tax rate
TAXPCOV TAXPERCNTG CHAR 446 15 0 Total tax rate
TAXAMT0 TAXAMOUNT CHAR 461 15 0 Level n tax amount
TAXAMT1 TAXAMOUNT CHAR 476 15 0 Level n tax amount
TAXAMT2 TAXAMOUNT CHAR 491 15 0 Level n tax amount
TAXAMT3 TAXAMOUNT CHAR 506 15 0 Level n tax amount
TAXAMT4 TAXAMOUNT CHAR 521 15 0 Level n tax amount
TAXAMT5 TAXAMOUNT CHAR 536 15 0 Level n tax amount
TAXAMT6 TAXAMOUNT CHAR 551 15 0 Level n tax amount
TAXAMT7 TAXAMOUNT CHAR 566 15 0 Level n tax amount
TAXAMT8 TAXAMOUNT CHAR 581 15 0 Level n tax amount
TAXAMT9 TAXAMOUNT CHAR 596 15 0 Level n tax amount
TAXAMOV TAXAMOUNTG CHAR 611 15 0 Total tax amount
TAXBAS0 TAXBASE CHAR 626 15 0 Tax base amount level n
TAXBAS1 TAXBASE CHAR 641 15 0 Tax base amount level n
TAXBAS2 TAXBASE CHAR 656 15 0 Tax base amount level n
TAXBAS3 TAXBASE CHAR 671 15 0 Tax base amount level n
TAXBAS4 TAXBASE CHAR 686 15 0 Tax base amount level n
TAXBAS5 TAXBASE CHAR 701 15 0 Tax base amount level n
TAXBAS6 TAXBASE CHAR 716 15 0 Tax base amount level n
TAXBAS7 TAXBASE CHAR 731 15 0 Tax base amount level n
TAXBAS8 TAXBASE CHAR 746 15 0 Tax base amount level n
TAXBAS9 TAXBASE CHAR 761 15 0 Tax base amount level n
EXMATFLG EXMATCODE CHAR 776 2 0 Code for material tax exemption
EXCUSFLG EXCUSCODE CHAR 778 2 0 Code for customer tax exemption
EXAMT0 EXMTAMOUNT CHAR 780 15 0 Exempt amount
EXAMT1 EXMTAMOUNT CHAR 795 15 0 Exempt amount
EXAMT2 EXMTAMOUNT CHAR 810 15 0 Exempt amount
EXAMT3 EXMTAMOUNT CHAR 825 15 0 Exempt amount
EXAMT4 EXMTAMOUNT CHAR 840 15 0 Exempt amount
EXAMT5 EXMTAMOUNT CHAR 855 15 0 Exempt amount
EXAMT6 EXMTAMOUNT CHAR 870 15 0 Exempt amount
EXAMT7 EXMTAMOUNT CHAR 885 15 0 Exempt amount
EXAMT8 EXMTAMOUNT CHAR 900 15 0 Exempt amount
EXAMT9 EXMTAMOUNT CHAR 915 15 0 Exempt amount
EXCODE0 EXDETCODE CHAR 930 2 0 Tax Exemption Reason Code
EXCODE1 EXDETCODE CHAR 932 2 0 Tax Exemption Reason Code
EXCODE2 EXDETCODE CHAR 934 2 0 Tax Exemption Reason Code
EXCODE3 EXDETCODE CHAR 936 2 0 Tax Exemption Reason Code
EXCODE4 EXDETCODE CHAR 938 2 0 Tax Exemption Reason Code
EXCODE5 EXDETCODE CHAR 940 2 0 Tax Exemption Reason Code
EXCODE6 EXDETCODE CHAR 942 2 0 Tax Exemption Reason Code
EXCODE7 EXDETCODE CHAR 944 2 0 Tax Exemption Reason Code
EXCODE8 EXDETCODE CHAR 946 2 0 Tax Exemption Reason Code
EXCODE9 EXDETCODE CHAR 948 2 0 Tax Exemption Reason Code
EXCERTIF EXCERTIF CHAR 950 25 0 Customer tax exemption certificate number defined in SAP
EXREASON EXDETCODE CHAR 975 2 0 Tax Exemption Reason Code
USER_DATA USER_DATA CHAR 977 50 0 User-specific field

595386Resending transactions to Tax Audit File
1471238FI-CA: duplicate tax update to external tax system
307896Various issues related to Protege-Taxware Toolkit
395531External tax system: Correction programs