	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

131 columns | B1 9.2 | TAXTYPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Default Value	Constraints
TOPBanking
1	TPW2	Payable Information	4	TaxType	Tax Type	Int	11	0
TOPFinance
2	ADPA	Fixed Asset Depreciation Areas - History	15	TaxType	Tax Type	Int	11	0
3	AJD1	Journal Entry - History - Rows	72	TaxType	Tax Type	Int	6	0	0
4	AVT1	Tax Definition	7	TaxType	Tax Type (VAT or Stamp)	VarChar	1	0	V	S=Stamp, V=VAT
5	AVTG	Tax Definition	22	TaxType	Tax Type (VAT or Stamp)	VarChar	1	0	V	S=Stamp, V=VAT
6	BOX1	Box Definition - Rows	8	TaxType	Acquisition / Reverse Tax Type	VarChar	1	0	B	B=Input Tax and Output Tax, I=Input Tax, O=Output Tax
7	BTF1	Journal Voucher - Rows	72	TaxType	Tax Type	Int	6	0	0
8	JDT1	Journal Entry - Rows	72	TaxType	Tax Type	Int	6	0	0
9	ODPA	Fixed Asset Depreciation Areas	15	TaxType	Tax Type	Int	11	0
10	OVTG	Tax Definition	22	TaxType	Tax Type (VAT or Stamp)	VarChar	1	0	V	S=Stamp, V=VAT
11	RCR1	Recurring Postings - Rows	14	TaxType	Tax Type	Int	6	0	0
12	TAX1	VAT Transactions - Rows	11	TaxType	Tax Type	VarChar	1	0	Y	D=Deferred Tax Offset Transaction, N=No Tax, O=Tax Offset Transaction, P=DPM Request Tax Offset Transaction, R=Reverse Tax Offset Transaction, U=Use Tax, Y=Regular
13	TRT1	Posting Templates - Rows	12	TaxType	Tax Type	Int	6	0	0
14	UTX1	Unreported VAT Transactions - Rows	11	TaxType	Tax Type	VarChar	1	0	Y	D=Deferred Tax Offset Transaction, N=No Tax, O=Tax Offset Transaction, P=DPM Request Tax Offset Transaction, R=Reverse Tax Offset Transaction, U=Use Tax, Y=Regular
15	VTG1	Tax Definition	7	TaxType	Tax Type (VAT or Stamp)	VarChar	1	0	V	S=Stamp, V=VAT
TOPInventory and Production
16	AITM	Items - History	210	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
17	IGE1	Goods Issue - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
18	IGE13	Goods Issue Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
19	IGE2	Goods Issue - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
20	IGE3	Goods Issue - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
21	IGN1	Goods Receipt - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
22	IGN13	Goods Receipt Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
23	IGN2	Goods Receipt - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
24	IGN3	Goods Receipt - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
25	OITM	Items	210	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
26	SITM	Items	210	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
27	UITM	Items	210	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
28	WTQ1	Inventory Transfer Request - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
29	WTQ13	Inventory Transfer Request Rows - Distributed Freights	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
30	WTQ2	Inventory Transfer Request - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
31	WTQ3	Inventory Transfer Request - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
32	WTR1	Inventory Transfer - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
33	WTR13	Inventory Transfer Rows - Distributed Freights	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
34	WTR2	Inventory Transfer - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
35	WTR3	Inventory Transfer - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
TOPMarketing Documents
36	ADO1	A/R Invoice (Rows) - History	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
37	ADO13	A/R Invoice Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
38	ADO2	A/R Invoice - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
39	ADO3	A/R Invoice - Freight - History	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
40	CIN1	Correction Invoice - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
41	CIN13	Correction Invoice Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
42	CIN2	A/R Correction Invoice - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
43	CIN3	A/R Correction Invoice - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
44	CPI1	A/P Correction Invoice - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
45	CPI13	A/P Correction Invoice Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
46	CPI2	A/P Correction Invoice - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
47	CPI3	A/P Correction Invoice - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
48	CPV1	A/P Correction Invoice Reversal - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
49	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
50	CPV2	A/P Correction Invoice Reversal - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
51	CPV3	A/P Correction Invoice Reversal - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
52	CSI1	A/R Correction Invoice - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
53	CSI13	A/R Correction Invoice Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
54	CSI2	A/R Corr Inv - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
55	CSI3	A/R Correction Invoice - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
56	CSV1	A/R Correction Invoice Reversal - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
57	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
58	CSV2	A/R Correction Invoice Reversal - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
59	CSV3	A/R Correction Invoice Reversal - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
60	DLN1	Delivery - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
61	DLN13	Delivery Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
62	DLN2	Delivery Notes - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
63	DLN3	Delivery Notes - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
64	DPI1	A/R Down Payment - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, O=Offset Tax, U=Use Tax, Y=Regular Tax
65	DPI13	A/R Down Payment Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
66	DPI2	A/R Down Payment - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
67	DPI3	A/R Down Payment - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
68	DPO1	A/P Down Payment - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, O=Offset Tax, U=Use Tax, Y=Regular Tax
69	DPO13	A/P Down Payment Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
70	DPO2	A/P Down Payment - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
71	DPO3	A/P Down Payment - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
72	DRF1	Draft - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
73	DRF13	Draft Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
74	DRF2	Draft - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
75	DRF3	Draft - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
76	IEI1	Incoming Excise Invoice - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
77	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
78	IEI2	Incoming Excise Invoice - Freight - History - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
79	IEI3	IEI - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
80	INV1	A/R Invoice - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
81	INV13	A/R Invoice Rows - Distributed Freights	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
82	INV2	A/R Invoice - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
83	INV3	A/R Invoice - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
84	OEI1	Outgoing Excise Invoice - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
85	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
86	OEI2	OEI - Freight Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
87	OEI3	OEI - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
88	PCH1	A/P Invoice - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
89	PCH13	A/P Invoice Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
90	PCH2	A/P Invoice - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
91	PCH3	A/P Invoice - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
92	PDN1	Goods Receipt PO - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
93	PDN13	Goods Receipt PO Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
94	PDN2	Goods Receipt PO - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
95	PDN3	Goods Receipt PO - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
96	POR1	Purchase Order - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
97	POR13	Purchase Order Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
98	POR2	Purchase Order - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
99	POR3	Purchase Order - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
100	PQT1	Purchase Quotation - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
101	PQT13	Purchase Quotation Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
102	PQT2	Purchase Quotation - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
103	PQT3	Purchase Quotation - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
104	PRQ1	Purchase Request - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
105	PRQ13	Purchase Request Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
106	PRQ2	Purchase Request - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
107	PRQ3	Purchase Request - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
108	QUT1	Sales Quotation - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
109	QUT13	Sales Quotation Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
110	QUT2	Sales Quotation - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
111	QUT3	Sales Quotation - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
112	RDN1	Returns - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
113	RDN13	Returns Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
114	RDN2	Return - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
115	RDN3	Return - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
116	RDR1	Sales Order - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
117	RDR13	Sales Order Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
118	RDR2	Sales Order - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
119	RDR3	Sales Order - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
120	RIN1	A/R Credit Memo - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
121	RIN13	A/R Credit Memo Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
122	RIN2	A/R Credit Memo - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
123	RIN3	A/R Credit Memo - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
124	RPC1	A/P Credit Memo - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
125	RPC13	A/P Credit Memo Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
126	RPC2	A/P Credit Memo Rows - Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
127	RPC3	A/P Credit Memo - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
128	RPD1	Goods Return - Rows	101	TaxType	Tax Type	VarChar	1	0		N=No Tax, U=Use Tax, Y=Regular Tax
129	RPD13	Goods Returns Rows - Distributed Expenses	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Normal Tax
130	RPD2	Goods Return - Freight - Rows	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax
131	RPD3	Goods Return - Freight	24	TaxType	Tax Type	VarChar	1	0	Y	N=No Tax, U=Use Tax, Y=Regular Tax

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

131 columns | B1 9.2 | TAXTYPE