ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting
1	ERP EHP7	6.0	KNB4	116	1	Customer Payment History	Financial Accounting

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
4	AUFZD	Date as from when the payment history was recorded	nvarchar	8	0	Allow NULL?
5	JAH01	Calendar Year	nvarchar	4	0	Allow NULL?
6	MON01	Calendar Month	nvarchar	2	0	Allow NULL?
7	AGS01	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
8	VZS01	Average arrears with cash discount payments	decimal	3	0
9	AGN01	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
10	VZN01	Average arrears with payments without cash discount taken	decimal	3	0
11	ANZ01	Number of Incoming Payments during the Period	decimal	3	0
12	JAH02	Calendar Year	nvarchar	4	0	Allow NULL?
13	MON02	Calendar Month	nvarchar	2	0	Allow NULL?
14	AGS02	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
15	VZS02	Average arrears with cash discount payments	decimal	3	0
16	AGN02	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
17	VZN02	Average arrears with payments without cash discount taken	decimal	3	0
18	ANZ02	Number of Incoming Payments during the Period	decimal	3	0
19	JAH03	Calendar Year	nvarchar	4	0	Allow NULL?
20	MON03	Calendar Month	nvarchar	2	0	Allow NULL?
21	AGS03	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
22	VZS03	Average arrears with cash discount payments	decimal	3	0
23	AGN03	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
24	VZN03	Average arrears with payments without cash discount taken	decimal	3	0
25	ANZ03	Number of Incoming Payments during the Period	decimal	3	0
26	JAH04	Calendar Year	nvarchar	4	0	Allow NULL?
27	MON04	Calendar Month	nvarchar	2	0	Allow NULL?
28	AGS04	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
29	VZS04	Average arrears with cash discount payments	decimal	3	0
30	AGN04	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
31	VZN04	Average arrears with payments without cash discount taken	decimal	3	0
32	ANZ04	Number of Incoming Payments during the Period	decimal	3	0
33	JAH05	Calendar Year	nvarchar	4	0	Allow NULL?
34	MON05	Calendar Month	nvarchar	2	0	Allow NULL?
35	AGS05	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
36	VZS05	Average arrears with cash discount payments	decimal	3	0
37	AGN05	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
38	VZN05	Average arrears with payments without cash discount taken	decimal	3	0
39	ANZ05	Number of Incoming Payments during the Period	decimal	3	0
40	JAH06	Calendar Year	nvarchar	4	0	Allow NULL?
41	MON06	Calendar Month	nvarchar	2	0	Allow NULL?
42	AGS06	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
43	VZS06	Average arrears with cash discount payments	decimal	3	0
44	AGN06	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
45	VZN06	Average arrears with payments without cash discount taken	decimal	3	0
46	ANZ06	Number of Incoming Payments during the Period	decimal	3	0
47	JAH07	Calendar Year	nvarchar	4	0	Allow NULL?
48	MON07	Calendar Month	nvarchar	2	0	Allow NULL?
49	AGS07	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
50	VZS07	Average arrears with cash discount payments	decimal	3	0
51	AGN07	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
52	VZN07	Average arrears with payments without cash discount taken	decimal	3	0
53	ANZ07	Number of Incoming Payments during the Period	decimal	3	0
54	JAH08	Calendar Year	nvarchar	4	0	Allow NULL?
55	MON08	Calendar Month	nvarchar	2	0	Allow NULL?
56	AGS08	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
57	VZS08	Average arrears with cash discount payments	decimal	3	0
58	AGN08	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
59	VZN08	Average arrears with payments without cash discount taken	decimal	3	0
60	ANZ08	Number of Incoming Payments during the Period	decimal	3	0
61	JAH09	Calendar Year	nvarchar	4	0	Allow NULL?
62	MON09	Calendar Month	nvarchar	2	0	Allow NULL?
63	AGS09	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
64	VZS09	Average arrears with cash discount payments	decimal	3	0
65	AGN09	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
66	VZN09	Average arrears with payments without cash discount taken	decimal	3	0
67	ANZ09	Number of Incoming Payments during the Period	decimal	3	0
68	JAH10	Calendar Year	nvarchar	4	0	Allow NULL?
69	MON10	Calendar Month	nvarchar	2	0	Allow NULL?
70	AGS10	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
71	VZS10	Average arrears with cash discount payments	decimal	3	0
72	AGN10	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
73	VZN10	Average arrears with payments without cash discount taken	decimal	3	0
74	ANZ10	Number of Incoming Payments during the Period	decimal	3	0
75	JAH11	Calendar Year	nvarchar	4	0	Allow NULL?
76	MON11	Calendar Month	nvarchar	2	0	Allow NULL?
77	AGS11	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
78	VZS11	Average arrears with cash discount payments	decimal	3	0
79	AGN11	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
80	VZN11	Average arrears with payments without cash discount taken	decimal	3	0
81	ANZ11	Number of Incoming Payments during the Period	decimal	3	0
82	JAH12	Calendar Year	nvarchar	4	0	Allow NULL?
83	MON12	Calendar Month	nvarchar	2	0	Allow NULL?
84	AGS12	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
85	VZS12	Average arrears with cash discount payments	decimal	3	0
86	AGN12	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
87	VZN12	Average arrears with payments without cash discount taken	decimal	3	0
88	ANZ12	Number of Incoming Payments during the Period	decimal	3	0
89	JAH13	Calendar Year	nvarchar	4	0	Allow NULL?
90	MON13	Calendar Month	nvarchar	2	0	Allow NULL?
91	AGS13	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
92	VZS13	Average arrears with cash discount payments	decimal	3	0
93	AGN13	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
94	VZN13	Average arrears with payments without cash discount taken	decimal	3	0
95	ANZ13	Number of Incoming Payments during the Period	decimal	3	0
96	JAH14	Calendar Year	nvarchar	4	0	Allow NULL?
97	MON14	Calendar Month	nvarchar	2	0	Allow NULL?
98	AGS14	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
99	VZS14	Average arrears with cash discount payments	decimal	3	0
100	AGN14	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
101	VZN14	Average arrears with payments without cash discount taken	decimal	3	0
102	ANZ14	Number of Incoming Payments during the Period	decimal	3	0
103	JAH15	Calendar Year	nvarchar	4	0	Allow NULL?
104	MON15	Calendar Month	nvarchar	2	0	Allow NULL?
105	AGS15	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
106	VZS15	Average arrears with cash discount payments	decimal	3	0
107	AGN15	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
108	VZN15	Average arrears with payments without cash discount taken	decimal	3	0
109	ANZ15	Number of Incoming Payments during the Period	decimal	3	0
110	JAH16	Calendar Year	nvarchar	4	0	Allow NULL?
111	MON16	Calendar Month	nvarchar	2	0	Allow NULL?
112	AGS16	Gross Total of Cleared Items without Cash Discount Loss	decimal	15	2
113	VZS16	Average arrears with cash discount payments	decimal	3	0
114	AGN16	Gross Total of Cleared Items with Cash Discount Not Taken	decimal	15	2
115	VZN16	Average arrears with payments without cash discount taken	decimal	3	0
116	ANZ16	Number of Incoming Payments during the Period	decimal	3	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

116 COLUMNS | 1 INDEXES | ERP 6.0 | KNB4 TABLE

TOP ERP 6.0 | KNB4 COLUMNS

TOP ERP 6.0 | KNB4 INDEXES

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

116 COLUMNS | 1 INDEXES | ERP 6.0 | KNB4 TABLE

TOPERP 6.0 | KNB4 COLUMNS

TOPERP 6.0 | KNB4 INDEXES

TOP ERP 6.0 | KNB4 COLUMNS

TOP ERP 6.0 | KNB4 INDEXES