	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

108 columns | ERP 6.0 | TAXTYP

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CN/CTXSAPD0001	Country/Cost Center/Product Usage	24	TAXTYP	Tax Type	nvarchar	4	0
2	/1CN/CTXSAPD0002	Country/Order/Product Usage	24	TAXTYP	Tax Type	nvarchar	4	0
3	/1CN/CTXSAPD0003	Country/Product Usage	26	TAXTYP	Tax Type	nvarchar	4	0
4	/1CN/CTXSAPD0004	Country	25	TAXTYP	Tax Type	nvarchar	4	0
5	/1CN/CTXSAPD0201	Country/Tax Code	26	TAXTYP	Tax Type	nvarchar	4	0
6	/1CN/CTXSAPR0100	Country/Product Tax Group/Business Partner Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
7	/1CN/CTXSAPR0103	Country/Product Tax Group	23	TAXTYP	Tax Type	nvarchar	4	0
8	/1CN/CTXSAPR0104	Country	22	TAXTYP	Tax Type	nvarchar	4	0
9	/1CN/CTXSAPR0105	Country/Tax Event	23	TAXTYP	Tax Type	nvarchar	4	0
10	/1CN/CTXSAPR0106	Country/Region/Product Tax Group/Business Partner Tax Group	25	TAXTYP	Tax Type	nvarchar	4	0
11	/1CN/CTXSAPR0107	Country/Tax Event/ST Jurisdiction Code	24	TAXTYP	Tax Type	nvarchar	4	0
12	/1CN/CTXSAPR0108	Country/Region/Product Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
13	/1CN/CTXSAPR0110	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	24	TAXTYP	Tax Type	nvarchar	4	0
14	/1CN/CTXSAPR0111	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code	24	TAXTYP	Tax Type	nvarchar	4	0
15	/1CN/CTXSAPR0112	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code	25	TAXTYP	Tax Type	nvarchar	4	0
16	/1CN/CTXSAPR0113	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group	25	TAXTYP	Tax Type	nvarchar	4	0
17	/1CN/CTXSAPR0120	Country/Tax Tariff Code	23	TAXTYP	Tax Type	nvarchar	4	0
18	/1CN/CTXSAPR0130	Country/3L Jur.Code	23	TAXTYP	Tax Type	nvarchar	4	0
19	/1CN/CTXSAPR0131	Country/3L Jur.Code/Product Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
20	/1CN/CTXSAPR0140	Country/Tax Event/Jurisdiction Code	24	TAXTYP	Tax Type	nvarchar	4	0
21	/1CN/CTXSAPR0201	Country/Tax Code	23	TAXTYP	Tax Type	nvarchar	4	0
22	/1CN/CTXSAPRBR01	Country/Tax Tariff Code	23	TAXTYP	Tax Type	nvarchar	4	0
23	/1CN/CTXSAPRBR02	Country/Product Tax Group	23	TAXTYP	Tax Type	nvarchar	4	0
24	/1CN/CTXSAPRBR03	Country/Product Tax Group/Business Partner Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
25	/1CN/CTXSAPRBR10	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	24	TAXTYP	Tax Type	nvarchar	4	0
26	/1CN/CTXSAPRBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	25	TAXTYP	Tax Type	nvarchar	4	0
27	/1CN/CTXSAPRBR12	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group	25	TAXTYP	Tax Type	nvarchar	4	0
28	/1CN/CTXSAPRBR20	Country/2L Jur.Code	23	TAXTYP	Tax Type	nvarchar	4	0
29	/1CN/CTXSAPRBR21	Country/2L Jur.Code/Product Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
30	/1CN/CTXSAPRIN03	Country/Tax Tariff Code/Business Partner ID	24	TAXTYP	Tax Type	nvarchar	4	0
31	/1CN/CTXSAPRIN04	Recipient Country/Tax Tariff Code/Business Partner ID	24	TAXTYP	Tax Type	nvarchar	4	0
32	/1CN/CTXSAPRIN06	Country/Spl Reg./Rec Region/Tax Group/Tax Group	26	TAXTYP	Tax Type	nvarchar	4	0
33	/1CN/CTXSAPRIN07	Country/Partner ID/Recip. Tax Region/Tax Group	25	TAXTYP	Tax Type	nvarchar	4	0
34	/1CN/CTXSAPS0100	Country/Business Process	23	TAXTYP	Tax Type	nvarchar	4	0
35	/1CN/CTXSAPS0101	Country/Bus. Transaction	23	TAXTYP	Tax Type	nvarchar	4	0
36	/1CN/CTXSAPS0102	Country/Bus. Transaction	23	TAXTYP	Tax Type	nvarchar	4	0
37	/1CN/CTXSAPW0201	Country/Tax Code	23	TAXTYP	Tax Type	nvarchar	4	0
38	/1CN/CTXSAPW0202	Country/Business Partner Tax Group	23	TAXTYP	Tax Type	nvarchar	4	0
39	/1CN/CTXSAPX0100	Country/Region	23	TAXTYP	Tax Type	nvarchar	4	0
40	/1CN/CTXSAPX0101	Country/Supplier BP ID/Business Partner ID	24	TAXTYP	Tax Type	nvarchar	4	0
41	/1CN/CTXSAPX0102	Country/Business Partner Tax Group	23	TAXTYP	Tax Type	nvarchar	4	0
42	/1CN/CTXSAPX0103	Country/Supplier BP ID/Business Partner ID/Product Tax Group	25	TAXTYP	Tax Type	nvarchar	4	0
43	/1CN/CTXSAPX0104	Recipient Country/Recipient Tax Region/Locat. Relationship	24	TAXTYP	Tax Type	nvarchar	4	0
44	/1CN/CTXSAPX0105	Country/Product Tax Group	23	TAXTYP	Tax Type	nvarchar	4	0
45	/1CN/CTXSAPX0106	Country/Region/Product Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
46	/1CN/CTXSAPX0140	Country/Product Tax Group/Jurisdiction Code	24	TAXTYP	Tax Type	nvarchar	4	0
47	/1CN/CTXSAPX0141	Country/Business Partner Tax Group/Jurisdiction Code	24	TAXTYP	Tax Type	nvarchar	4	0
48	/1CN/CTXSAPX0146	Country/Region/Product Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
49	/1CN/CTXSAPX0147	Country/Region/Business Partner Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
50	/1CN/CTXSAPX0148	Country	22	TAXTYP	Tax Type	nvarchar	4	0
51	/1CN/CTXSAPXBR01	Country/Tax Tariff Code	23	TAXTYP	Tax Type	nvarchar	4	0
52	/1CN/CTXSAPXBR02	Country/Product Tax Group	23	TAXTYP	Tax Type	nvarchar	4	0
53	/1CN/CTXSAPXBR03	Country/Product Tax Group/Business Partner Tax Group	24	TAXTYP	Tax Type	nvarchar	4	0
54	/1CN/CTXSAPXBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	25	TAXTYP	Tax Type	nvarchar	4	0
TOPLocalization
55	J_1BAJ	Tax types	2	TAXTYP	Tax Type	nvarchar	4	0
56	J_1BAJT	Tax types - Description	3	TAXTYP	Tax Type	nvarchar	4	0
57	J_1BNFEPARKTAX	Nota fiscal electronica: Invoice create failed	17	TAXTYP	Tax Type	nvarchar	4	0
58	J_1BNFSTX	Nota Fiscal tax per item	4	TAXTYP	Tax Type	nvarchar	4	0
59	J_1BNFTXCOND	Tax Condition Interface for Notas Fiscais	5	TAXTYP	Tax Type	nvarchar	4	0
60	J_1BPOSCOUPONS	POS-Database Coupons (Brazilian)	8	TAXTYP	Tax Type	nvarchar	4	0
61	J_1BPOSREDUCTION	POS-Database Reduction (Brazilian)	17	TAXTYP	Tax Type	nvarchar	4	0
62	J_1B_CIAP_OBJECT	CIAP document data	5	TAXTYP	Tax Type	nvarchar	4	0
TOPTariffs, Duties and Permits
63	OIH_J1B_SDTXCD	SD tax code for ICMS ST calculation	3	TAXTYP	Tax Type	nvarchar	4	0
TOPTransaction Tax Engine
64	TTE2C_BPTXGRP	Business Partner Tax Group	4	TAXTYP	Tax Type	nvarchar	4	0
65	TTE2C_BPTXGRP_T	Description for Business Partner Tax Group	5	TAXTYP	Tax Type	nvarchar	4	0
66	TTE2C_DEDREAS	Deductibility Reason	3	TAXTYP	Tax Type	nvarchar	4	0
67	TTE2C_DEDREAS_T	Description for Deductibility Reason	4	TAXTYP	Tax Type	nvarchar	4	0
68	TTE2C_PRTXGRP	Product Tax Group	4	TAXTYP	Tax Type	nvarchar	4	0
69	TTE2C_PRTXGRP_T	Product Tax Group Description	5	TAXTYP	Tax Type	nvarchar	4	0
70	TTE2C_RETLVL	Jurisdiction Level	3	TAXTYP	Tax Type	nvarchar	4	0
71	TTE2C_RETLVL_T	Jurisdiction Level Description	4	TAXTYP	Tax Type	nvarchar	4	0
72	TTE2C_TAXTYP_DET	Tax Type Determination	4	TAXTYP	Tax Type	nvarchar	4	0
73	TTE2C_TAXTYP_T	Tax Type Description	4	TAXTYP	Tax Type	nvarchar	4	0
74	TTE2C_TAX_MAP	Mapping between Tax Type and Procedure	8	TAXTYP	Tax Type	nvarchar	4	0
75	TTEC_ACCUM_PER	Accumulation Period	3	TAXTYP	Tax Type	nvarchar	4	0
76	TTEC_AGGREG	[Obsolete] Aggregation Rule For Tax Amounts	3	TAXTYP	Tax Type	nvarchar	4	0
77	TTEC_DEDREAS	[Obsolete] Deductibility Reason	6	TAXTYP	Tax Type	nvarchar	4	0
78	TTEC_DEDREAS_T	[Obsolete] Description for Deductibility Reason	7	TAXTYP	Tax Type	nvarchar	4	0
79	TTEC_INCIDENCE	Tax Incidence	3	TAXTYP	Tax Type	nvarchar	4	0
80	TTEC_INCIDENCE_T	Tax Incidence in Tax Transaction Engine	4	TAXTYP	Tax Type	nvarchar	4	0
81	TTEC_LEGTXT	Legal Text	3	TAXTYP	Tax Type	nvarchar	4	0
82	TTEC_LEGTXT_T	Legal Text	4	TAXTYP	Tax Type	nvarchar	4	0
83	TTEC_PATXGRP	Partner Tax Group	5	TAXTYP	Tax Type	nvarchar	4	0
84	TTEC_PATXGRP_T	Description for Partner Tax Group	6	TAXTYP	Tax Type	nvarchar	4	0
85	TTEC_PRC_TAX_MAP	[3.x only] Mapping between Tax Type and Procedure	3	TAXTYP	Tax Type	nvarchar	4	0
86	TTEC_PRTXGRP	Product Tax Group	5	TAXTYP	Tax Type	nvarchar	4	0
87	TTEC_PRTXGRP_T	Product Tax Group Description	6	TAXTYP	Tax Type	nvarchar	4	0
88	TTEC_RATE_ID	Rate IDs	3	TAXTYP	Tax Type	nvarchar	4	0
89	TTEC_RATE_ID_T	Rate IDs	4	TAXTYP	Tax Type	nvarchar	4	0
90	TTEC_RNDRULE	Rounding Rules	3	TAXTYP	Tax Type	nvarchar	4	0
91	TTEC_ROUNDING	Rounding Decimals: Exceptions	6	TAXTYP	Tax Type	nvarchar	4	0
92	TTEC_TAXCODE_3	Assign TTE Entities to Tax Code	5	TAXTYP	Tax Type	nvarchar	4	0
93	TTEC_TAXTYP	Tax Type	3	TAXTYP	Tax Type	nvarchar	4	0
94	TTEC_TAXTYP_DET	[Obsolete] Tax Types by Tax Event	5	TAXTYP	Tax Type	nvarchar	4	0
95	TTEC_TAXTYP_T	[Obsolete] Tax Type Description	4	TAXTYP	Tax Type	nvarchar	4	0
96	TTEM_TAXTYP_EXT	Mapping TTE Tax Types to External Tax Types	3	TAXTYP	Tax Type	nvarchar	4	0
97	TTEPDT_EXEMPVALU	Persistency TTE Document Item Exemption Value	5	TAXTYP	Tax Type	nvarchar	4	0
98	TTEPDT_PATAXCL	Persistency TTE Document business partner tax class.	6	TAXTYP	Tax Type	nvarchar	4	0
99	TTEPDT_PRTAXCL	Persistency TTE Document product tax class.	6	TAXTYP	Tax Type	nvarchar	4	0
100	TTEPDT_TAXEL	Persistency TTE Document / Item tax element	7	TAXTYP	Tax Type	nvarchar	4	0
101	TTEPDT_TAXVALUE	Persistency TTE Document / Item tax value	7	TAXTYP	Tax Type	nvarchar	4	0
102	TTESDT_ACCUMVALU	Document business partner accum. values of with. tax.	5	TAXTYP	Tax Type	nvarchar	4	0
103	TTESDT_EXEMPVALU	Document business partner exemption values for with. tax.	5	TAXTYP	Tax Type	nvarchar	4	0
104	TTESDT_PATAXCL	Document business partner tax class.	6	TAXTYP	Tax Type	nvarchar	4	0
105	TTESDT_PRTAXCL	Document product tax class.	6	TAXTYP	Tax Type	nvarchar	4	0
106	TTESDT_TAXEL	Document / Item tax element	7	TAXTYP	Tax Type	nvarchar	4	0
107	TTESDT_TAXVALUE	Document / Item tax value	7	TAXTYP	Tax Type	nvarchar	4	0
108	TTE_WT_ACCUMVALU	AP-TTE accumulated base amounts and withholding tax amounts	5	TAXTYP	Tax Type	nvarchar	4	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

108 columns | ERP 6.0 | TAXTYP