SAP ABAP Table TTXY (External tax interface: tax information)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FYTX (Package) Interface to external systems for tax calculation
Basic Data
Table Category TRANSP    Transparent table 
Transparent table TTXY   Table Relationship Diagram
Short Description External tax interface: tax information    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   Key: FI/CO Document Header  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure *
4 AWREF AWREF AWREF CHAR 10   0   Reference document number  
5 AWORG AWORG AWORG CHAR 10   0   Reference organisational units  
6 KPOSN KPOSN NUM6 NUMC 6   0   Condition Item Number  
7 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
8 SHPTO TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
9 .INCLUDE       0   0   US tax interface : Communication structure for tax calc.  
10 CLIENT MANDT MANDT CLNT 3   0   Client *
11 COMP_CODE BUKRS BUKRS CHAR 4   0   Company Code *
12 DIVISION GSBER GSBER CHAR 4   0   Business Area *
13 COUNTRY LANDTX LAND1 CHAR 3   0   Tax Departure Country *
14 DOC_NUMBER BELNR_D BELNR CHAR 10   0   Accounting Document Number  
15 POS_NO POSNR_VA POSNR NUMC 6   0   Sales Document Item *
16 ACCNT_NO KONTO KTO16 CHAR 16   0   Account number  
17 ACCNT_CLS KONTOCLASS CHAR10 CHAR 10   0   Classification item of an account (Customer/vendor)  
18 TAX_DATE DATE CHAR8 CHAR 8   0   Date in CHAR format  
19 REP_DATE DATE CHAR8 CHAR 8   0   Date in CHAR format  
20 TXJCD_ST TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
21 TXJCD_SF TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
22 TXJCD_POA TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
23 TXJCD_POO TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
24 TXJCD_IND TXJCDIND CHAR1 CHAR 1   0   Indicator: Jurisdiction code used for tax calculation  
25 PTP_IND PTP_IND CHAR1 CHAR 1   0   Indicator: Point of Title Passage  
26 APAR_IND APAR_IND CHAR1 CHAR 1   0   Indicator for A/P or A/R  
27 TXJCD_L1 LENGX_TXD NUM02 NUMC 2   0   Length of the Nth Part of the Tax Jurisdiction Code  
28 TXJCD_L2 LENGX_TXD NUM02 NUMC 2   0   Length of the Nth Part of the Tax Jurisdiction Code  
29 TXJCD_L3 LENGX_TXD NUM02 NUMC 2   0   Length of the Nth Part of the Tax Jurisdiction Code  
30 TXJCD_L4 LENGX_TXD NUM02 NUMC 2   0   Length of the Nth Part of the Tax Jurisdiction Code  
31 TAX_TYPE TAXTYPEXT CHAR1 CHAR 1   0   Indicator: Sales/use/rental/service/tax  
32 MATNR TAXMATNR18 CHAR18 CHAR 18   0   Material number with 18 characters  
33 PROD_CODE PROCD_TTXP CHAR10 CHAR 10   0   SAP internal product code (external interface)  
34 QUANTITY QUANT_13 CHAR13 CHAR 13   0   Quantity  
35 UNIT UNIT_3 CHAR3 CHAR 3   0   Unit  
36 AMOUNT BASAMOUNT CHAR15 CHAR 15   0   Tax base amount  
37 CURRENCY CURR_5 CHAR5 CHAR 5   0   Currency Key  
38 CURR_DEC CURDECCHAR CHAR3 CHAR 3   0   Number of decimal places for currency (characters)  
39 FREIGHT_AM FRTAMOUNT CHAR15 CHAR 15   0   Freight Amount  
40 EXEMPT_AMT EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
41 EXEMPT_IND EXTEXMTFLG CHAR1 CHAR 1   0   Indicator: Transaction is tax exempt/taxable  
42 CREDIT_IND EXTCREDFLG CHAR1 CHAR 1   0   Indicator: Tax credit  
43 UPDATE_IND UPDATE_FLG CHAR1 CHAR 1   0   Audit file update indicator (external interface)  
44 OVWRT_IND EXTOVRFLG CHAR1 CHAR 1   0   Overwrite indicator  
45 TAXPCT0 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
46 TAXPCT1 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
47 TAXPCT2 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
48 TAXPCT3 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
49 TAXPCT4 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
50 TAXPCT5 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
51 TAXPCT6 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
52 TAXPCT7 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
53 TAXPCT8 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
54 TAXPCT9 TAXPERCNT CHAR15 CHAR 15   0   Level n tax rate  
55 TAXPCOV TAXPERCNTG CHAR15 CHAR 15   0   Total tax rate  
56 TAXAMT0 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
57 TAXAMT1 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
58 TAXAMT2 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
59 TAXAMT3 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
60 TAXAMT4 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
61 TAXAMT5 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
62 TAXAMT6 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
63 TAXAMT7 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
64 TAXAMT8 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
65 TAXAMT9 TAXAMOUNT CHAR15 CHAR 15   0   Level n tax amount  
66 TAXAMOV TAXAMOUNTG CHAR15 CHAR 15   0   Total tax amount  
67 TAXBAS0 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
68 TAXBAS1 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
69 TAXBAS2 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
70 TAXBAS3 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
71 TAXBAS4 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
72 TAXBAS5 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
73 TAXBAS6 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
74 TAXBAS7 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
75 TAXBAS8 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
76 TAXBAS9 TAXBASE CHAR15 CHAR 15   0   Tax base amount level n  
77 EXMATFLG EXMATCODE CHAR2 CHAR 2   0   Code for material tax exemption  
78 EXCUSFLG EXCUSCODE CHAR2 CHAR 2   0   Code for customer tax exemption  
79 EXAMT0 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
80 EXAMT1 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
81 EXAMT2 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
82 EXAMT3 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
83 EXAMT4 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
84 EXAMT5 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
85 EXAMT6 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
86 EXAMT7 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
87 EXAMT8 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
88 EXAMT9 EXMTAMOUNT CHAR15 CHAR 15   0   Exempt amount  
89 EXCODE0 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
90 EXCODE1 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
91 EXCODE2 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
92 EXCODE3 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
93 EXCODE4 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
94 EXCODE5 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
95 EXCODE6 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
96 EXCODE7 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
97 EXCODE8 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
98 EXCODE9 EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
99 EXCERTIF EXCERTIF CHAR25 CHAR 25   0   Customer tax exemption certificate number defined in SAP  
100 EXREASON EXDETCODE CHAR2 CHAR 2   0   Tax Exemption Reason Code  
101 USER_DATA USER_DATA TEXT50 CHAR 50   0   User-specific field  
History
Last changed by/on SAP  20130529 
SAP Release Created in