| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CN/CTXSAPR0106 | Country/Region/Product Tax Group/Business Partner Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
2 | /1CN/CTXSAPR0108 | Country/Region/Product Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
3 | /1CN/CTXSAPX0100 | Country/Region | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
4 | /1CN/CTXSAPX0106 | Country/Region/Product Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
5 | /1CN/CTXSAPX0146 | Country/Region/Product Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
6 | /1CN/CTXSAPX0147 | Country/Region/Business Partner Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
TOPCentral Part of Product Master |
7 | CRMC_TAX_GROUP | Sales Taxes: Customizing | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
8 | CRMC_TAX_GROUP_T | Sales Taxes: Customizing | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
9 | CRMC_TAX_MAP | R/3 to CRM Assignment Table for Taxes | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
10 | CRMC_TAX_MAP_BP | BP Tax Classification of Conditions: Mapping R/3 <-> CRM | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
11 | CRMM_PR_TAX | Product Sales Tax | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
12 | CRMM_PR_TAXH | Product Sales Tax - History | 5 | TAX_REG | Region | nvarchar | 3 | 0 | | |
TOPCustomer Master |
13 | TB071_CM | Tax Classification: Assignment of Tax Groups to Tax Types | 3 | TAX_REG | Tax Classification: Region | nvarchar | 3 | 0 | | |
14 | TB072_CM | Tax Classification: Mapping R/3 <-> CRM | 3 | TAX_REG | Tax Classification: Region | nvarchar | 3 | 0 | | |
TOPGlobal Trade Services |
15 | /SAPSLL/PRTAX | Legal and Logistics Services: Product Master - Tax Groups | 5 | TAX_REG | Region Key for Tax Gruops | nvarchar | 3 | 0 | | |
16 | /SAPSLL/TLC_VAT | Import Turnover Tax Rates for Europe | 3 | TAX_REG | Region Key for Tax Gruops | nvarchar | 3 | 0 | | |
TOPSAP Business Partner |
17 | BUT_FRG0011 | Business Partner: Tax Classification | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
18 | TB071 | Define Business Partner Tax Groups | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
19 | TB071_T | Define Business Partner Tax Groups | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
TOPTransaction Tax Engine |
20 | TTE2C_BPTXGRP | Business Partner Tax Group | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
21 | TTE2C_BPTXGRP_T | Description for Business Partner Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
22 | TTE2C_PRTXGRP | Product Tax Group | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
23 | TTE2C_PRTXGRP_T | Product Tax Group Description | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
24 | TTEC_AUTHORITY | Tax Authority | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
25 | TTEC_AUTHORITY_T | Tax Authority | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
26 | TTEC_DEDREAS | [Obsolete] Deductibility Reason | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
27 | TTEC_DEDREAS_T | [Obsolete] Description for Deductibility Reason | 5 | TAX_REG | Region | nvarchar | 3 | 0 | | |
28 | TTEC_EXEMPREAS | Exemption reason | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
29 | TTEC_EXEMPREAS_T | Exemption reason | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
30 | TTEC_FISCCODE | Fiscal Code | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
31 | TTEC_FISCCODE_T | Description Fiscal Code | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
32 | TTEC_PATXGRP | Partner Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
33 | TTEC_PATXGRP_T | Description for Partner Tax Group | 5 | TAX_REG | Region | nvarchar | 3 | 0 | | |
34 | TTEC_PRTXGRP | Product Tax Group | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
35 | TTEC_PRTXGRP_T | Product Tax Group Description | 5 | TAX_REG | Region | nvarchar | 3 | 0 | | |
36 | TTEC_TAX_REG | Tax Region | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
37 | TTEC_TAX_REG_T | Tax Region Name | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
38 | TTEC_USAGE | [Obsolete] Usage | 3 | TAX_REG | Region | nvarchar | 3 | 0 | | |
39 | TTEC_USAGE_T | [Obsolete] Usage Description | 4 | TAX_REG | Region | nvarchar | 3 | 0 | | |
40 | TTEM_BPTXGRP2 | Mapping: Business Partner Tax Group | 5 | TAX_REG | Region | nvarchar | 3 | 0 | | |
41 | TTEM_PRTXGRP2 | Mapping: Product Tax Group | 5 | TAX_REG | Region | nvarchar | 3 | 0 | | |