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