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
⤷ 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 |