	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

81 columns | ERP 6.0 | TAX_TYPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
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

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

81 columns | ERP 6.0 | TAX_TYPE