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