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