| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/VAT_TRANKEY | vat transaction keys input or output | 2 | TAX_TYPE | Tax Type | nvarchar | 1 | 0 | | |
2 | BBP_TAX | Tax Codes for Enterprise Buyer | 5 | TAX_TYPE | Tax Category (Only USA/Canada/Brazil) | nvarchar | 1 | 0 | | |
3 | BBP_TAXGROUP_FAV | User-Specific Favorites: Tax Groups for Tax Type | 5 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
4 | CBP_TAXCLASS | Obsolete... | 3 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
5 | CTCET_TAXCLASS | Assign Tax Group/Tax Type to SAP ECC Tax Classification-TCET | 3 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
6 | IDSAU_SHAREHOLD | Foreign Shareholders Percentages | 5 | TAX_TYPE | Tax Type for Company Activity | nvarchar | 4 | 0 | | |
7 | IDSAU_TAXRATES | Tax Rates valid for fiscal year | 3 | TAX_TYPE | Tax Type for Company Activity | nvarchar | 4 | 0 | | |
8 | OIUX8_NM_TAXDTL | Tax 2.0 - New Mexico Tax Details | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
9 | TCM_C_BPTAXCLASS | Assign Tax Group/Tax Type to SAP ECC Tax Classification BP | 3 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPBasic Functions |
10 | ETXDCI | External tax document: line item info | 18 | TAX_TYPE | Indicator: Sales/use/rental/service/tax | nvarchar | 1 | 0 | | |
11 | TTXY | External tax interface: tax information | 29 | TAX_TYPE | Indicator: Sales/use/rental/service/tax | nvarchar | 1 | 0 | | |
TOPBSI |
12 | BSIUDTT | HR-US: BSI test data (tax record) | 6 | TAX_TYPE | Tax Type | nvarchar | 2 | 0 | | |
TOPCentral Part of Product Master |
13 | CRMC_TAX_GROUP | Sales Taxes: Customizing | 4 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
14 | CRMC_TAX_GROUP_T | Sales Taxes: Customizing | 5 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
15 | CRMC_TAX_MAP | R/3 to CRM Assignment Table for Taxes | 4 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
16 | CRMC_TAX_MAP_BP | BP Tax Classification of Conditions: Mapping R/3 <-> CRM | 4 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
17 | CRMC_TAX_TEXT | Sales Taxes: Customizing | 2 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
18 | CRMM_PR_TAX | Product Sales Tax | 5 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
19 | CRMM_PR_TAXH | Product Sales Tax - History | 6 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPCountry-Specific Objects |
20 | COMC_R3_FIELDS | Assignment of R/3 material master fields to CFOP tax classif | 4 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPCustomer Master |
21 | TB070T_CM | Tax Classification: Tax Types per Country, Names | 4 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
22 | TB070_CM | Tax Classification: Tax Types per Country | 3 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
23 | TB071_CM | Tax Classification: Assignment of Tax Groups to Tax Types | 4 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
24 | TB072_CM | Tax Classification: Mapping R/3 <-> CRM | 4 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
25 | TB077_CM | Assignment of R/3 Field to CRM Tax Type | 3 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
26 | TB078_CM | Assignment of R/3 Field Value to CRM Tax Group | 3 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
TOPElectronic Data Interchange |
27 | PRICAT_K003Z | PRICAT: Catalog item basic data extras | 31 | TAX_TYPE | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
28 | WRF_PRICAT_TAX | Price Catalog Conversion Percent -> Classification | 6 | TAX_TYPE | Tax category (sales tax, federal sales tax,...) | nvarchar | 4 | 0 | | |
TOPGlobal Trade Services |
29 | /SAPSLL/PRTAX | Legal and Logistics Services: Product Master - Tax Groups | 6 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
30 | /SAPSLL/TLC_VAT | Import Turnover Tax Rates for Europe | 4 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
31 | /SAPSLL/TPRGPG | Mapping: Feeder System Product Tax Classification for Group | 7 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
32 | /SAPSLL/TPRVPG | Mapping: Feeder System Tax Classification Product | 7 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPLocalization |
33 | J_3R_FATAX | Transport Tax Data | 2 | TAX_TYPE | Tax Type | nvarchar | 1 | 0 | | |
34 | J_3R_FATAX_DECLH | Declaration Header (Transport, Property Tax) | 2 | TAX_TYPE | Tax Type | nvarchar | 1 | 0 | | |
TOPProduction and Revenue Accounting |
35 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 34 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
36 | OIUREP_TAX_SOL | Old tax reporting SOL configuration table | 3 | TAX_TYPE | Tax type | nvarchar | 2 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
37 | DFMCA_BRF910 | BRF: Create Tax Number | 7 | TAX_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
TOPRevenue |
38 | OIURV03_FRMTAX | Valuation Transactions Level 3 - Formula Tax Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
39 | OIURV03_TAXDTL | Valuation Tax Master Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
40 | OIURV03_TAXEMP | Valuation Tax Exempt Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
41 | OIURV03_TAXMKT | Valuation Tax Marketing Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
TOPSAP Business Partner |
42 | BUT_FRG0011 | Business Partner: Tax Classification | 5 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
43 | TB070 | Tax Classification: Tax Types per Country | 3 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
44 | TB070T | Tax Classification: Tax Types per Country, Descriptions | 4 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
45 | TB071 | Define Business Partner Tax Groups | 4 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
46 | TB071_T | Define Business Partner Tax Groups | 5 | TAX_TYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
47 | OIH_ETAX_GRP | Definition of Oil-Specific Product Tax Groups | 4 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
48 | OIH_ETAX_TB070 | Definition of Excise Tax Type per Country | 3 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
49 | OIH_ETAX_TB070T | Description of Excise Tax Type per Country | 4 | TAX_TYPE | Tax Classification: Tax Type | nvarchar | 4 | 0 | | |
TOPTax Reporting |
50 | OIUX1_ADJ_MKTC | Tax adjustments marketing costs for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
51 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
52 | OIUX1_ADJ_XMPC | Tax adjustment exemptions for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
53 | OIUX1_AGY_DEFN | Agency definition | 4 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
54 | OIUX1_TRN_MKTC | Tax transaction marketing costs for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
55 | OIUX1_TRN_MKTL | Tax transaction marketing costs for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
56 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
57 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
58 | OIUX1_TRN_XMPC | Tax transaction exemptions for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
59 | OIUX1_TRN_XMPL | Tax transaction exemptions for reporting | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
60 | OIUX1_TXCD_XREF | Cross reference between state tax codes and PRA entities | 5 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
61 | OIUX3_TX_OOSHST | Tax Reporting - Texas Out Of Statute Transaction History | 14 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
62 | OIUX3_TX_OOSTXN | Tax Reporting - Texas Out Of Statute Transactions | 14 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
63 | OIUX3_TX_PRDTB | Tax Reporting - Texas PRA Detail Txns-Tier Tax Below | 15 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
64 | OIUX3_TX_PRDTI | Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental | 15 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
65 | OIUX3_TX_PRDTN | Tax Reporting - Texas PRA Detail Txns - No Tier Tax | 15 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
66 | OIUX3_TX_TAXHST | Tax Reporting - Texas Tax History Transactions | 14 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
67 | OIUX3_TX_TAXSTG | Tax Reporting - Texas Tax Transaction Staging | 14 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
68 | OIUX3_TX_TAXTXN | Tax Reporting - Texas Tax Transactions | 14 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
69 | OIUX5_OK_TAX_RT | Tax 2.0 - Oklahoma Tax Rates | 2 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
TOPTransaction Tax Engine |
70 | TTEPD3_USITEM | Persistency TTE Document UsItem | 24 | TAX_TYPE | Indicator: Tax Category (Sales/Rental/Use/Lease) | nvarchar | 1 | 0 | | |
71 | TTEPDT_USITEM | Persistency TTE Document UsItem | 24 | TAX_TYPE | Indicator: Tax Category (Sales/Rental/Use/Lease) | nvarchar | 1 | 0 | | |
72 | TTESDT_USITEM | Output Exemptions | 24 | TAX_TYPE | Indicator: Tax Category (Sales/Rental/Use/Lease) | nvarchar | 1 | 0 | | |
TOPValuation |
73 | OIURV_DOC_FRMTAX | Valuation Transactions Level 3 - Formula Tax Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
74 | OIURV_DOC_TAXDTL | Valuation Tax Master Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
75 | OIURV_DOC_TAXEMP | Valuation Tax Exempt Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
76 | OIURV_DOC_TAXMKT | Valuation Tax Marketing Detail | 6 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
77 | OIURV_DO_DPSEVT | DOI Accounting Severance Tax Types Table | 5 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
78 | OIURV_STS | Severance tax statistics | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
79 | OIURV_STS_EMP | Severance Tax Statistics - Exempt | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
80 | OIURV_STS_MKT | Severance Tax Statistics - Marketing | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
81 | OIUVL_STS | Severance tax statistics | 3 | TAX_TYPE | Severance Tax Type | nvarchar | 2 | 0 | | |