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	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

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	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

B1 8.8: Top 10 requests

	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

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

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