	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

100 columns | B1 8.8 | DEDVATSUMS

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPInventory and Production
1	IGE1	Goods Issue - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
2	IGE2	Goods Issue - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
3	IGE3	Goods Issue - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
4	IGN1	Goods Receipt - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
5	IGN2	Goods Receipt - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
6	IGN3	Goods Receipt - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
7	WTR1	Inventory Transfer - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
8	WTR2	Inventory Transfer - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
9	WTR3	Inventory Transfer - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
TOPMarketing Documents
10	ADO1	A/R Invoice (Rows) - History	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
11	ADO13	A/R Invoice Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
12	ADO2	A/R Invoice - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
13	ADO3	A/R Invoice - Freight - History	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
14	CIN1	Correction Invoice - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
15	CIN13	Correction Invoice Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
16	CIN2	A/R Correction Invoice - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
17	CIN3	A/R Correction Invoice - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
18	CPI1	A/P Correction Invoice - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
19	CPI13	A/P Correction Invoice Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
20	CPI2	A/P Correction Invoice - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
21	CPI3	A/P Correction Invoice - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
22	CPV1	A/P Correction Invoice Reversal - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
23	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
24	CPV2	A/P Correction Invoice Reversal - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
25	CPV3	A/P Correction Invoice Reversal - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
26	CSI1	A/R Correction Invoice - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
27	CSI13	A/R Correction Invoice Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
28	CSI2	A/R Corr Inv - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
29	CSI3	A/R Correction Invoice - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
30	CSV1	A/R Correction Invoice Reversal - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
31	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
32	CSV2	A/R Correction Invoice Reversal - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
33	CSV3	A/R Correction Invoice Reversal - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
34	DLN1	Delivery - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
35	DLN13	Delivery Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
36	DLN2	Delivery Notes - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
37	DLN3	Delivery Notes - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
38	DPI1	A/R Down Payment - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
39	DPI13	A/R Down Payment Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
40	DPI2	A/R Down Payment - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
41	DPI3	A/R Down Payment - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
42	DPO1	A/P Down Payment - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
43	DPO13	A/P Down Payment Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
44	DPO2	A/P Down Payment - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
45	DPO3	A/P Down Payment - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
46	DRF1	Draft - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
47	DRF13	Draft Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
48	DRF2	Draft - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
49	DRF3	Draft - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
50	IEI1	Incoming Excise Invoice - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
51	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
52	IEI2	Incoming Excise Invoice - Freight - History - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
53	IEI3	IEI - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
54	IGE13	Goods Issue Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
55	IGN13	Goods Receipt Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
56	INV1	A/R Invoice - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
57	INV13	A/R Invoice Rows - Distributed Freights	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
58	INV2	A/R Invoice - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
59	INV3	A/R Invoice - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
60	OEI1	Outgoing Excise Invoice - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
61	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
62	OEI2	OEI - Freight Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
63	OEI3	OEI - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
64	PCH1	A/P Invoice - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
65	PCH13	A/P Invoice Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
66	PCH2	A/P Invoice - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
67	PCH3	A/P Invoice - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
68	PDN1	Goods Receipt PO - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
69	PDN13	Goods Receipt PO Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
70	PDN2	Goods Receipt PO - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
71	PDN3	Goods Receipt PO - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
72	POR1	Purchase Order - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
73	POR13	Purchase Order Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
74	POR2	Purchase Order - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
75	POR3	Purchase Order - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
76	QUT1	Sales Quotation - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
77	QUT13	Sales Quotation Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
78	QUT2	Sales Quotation - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
79	QUT3	Sales Quotation - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
80	RDN1	Returns - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
81	RDN13	Returns Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
82	RDN2	Return - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
83	RDN3	Return - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
84	RDR1	Sales Order - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
85	RDR13	Sales Order Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
86	RDR2	Sales Order - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
87	RDR3	Sales Order - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
88	RIN1	A/R Credit Memo - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
89	RIN13	A/R Credit Memo Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
90	RIN2	A/R Credit Memo - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
91	RIN3	A/R Credit Memo - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
92	RPC1	A/P Credit Memo - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
93	RPC13	A/P Credit Memo Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
94	RPC2	A/P Credit Memo Rows - Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
95	RPC3	A/P Credit Memo - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
96	RPD1	Goods Return - Rows	85	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
97	RPD13	Goods Returns Rows - Distributed Expenses	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
98	RPD2	Goods Return - Freight - Rows	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
99	RPD3	Goods Return - Freight	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6
100	WTR13	Inventory Transfer Rows - Distributed Freights	21	DedVatSumS	Deductible Tax Amount (SC)	Num	19	6

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

100 columns | B1 8.8 | DEDVATSUMS