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

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Purchasing
1	ERP EHP7	6.0	EKBE	81	3	History per Purchasing Document	Purchasing

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	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	No	EKKO	EBELN	Allow NULL?
3	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	No	EKPO	EBELP	Allow NULL?
4	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	No		DZEKKN	Allow NULL?
5	VGABE	Transaction/event type, purchase order history	char	1	0	CHAR	(N' ')	No		VGABE	Allow NULL?
6	GJAHR	Material Document Year	nvarchar	4	0	NUMC	(N'0000')	No		MJAHR	Allow NULL?
7	BELNR	Number of Material Document	nvarchar	10	0	CHAR	(N' ')	No		MBLNR	Allow NULL?
8	BUZEI	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	No		MBLPO	Allow NULL?
9	BEWTP	PO history category	char	1	0	CHAR	(N' ')	Yes	T163B	BEWTP	Allow NULL?
10	BWART	Movement Type (Inventory Management)	nvarchar	3	0	CHAR	(N' ')	Yes	T156	BWART	Allow NULL?
11	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
12	MENGE	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
13	BPMNG	Quantity in purchase order price unit	decimal	13	3	QUAN	((0))	Yes		MENGE_BPR
14	DMBTR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
15	WRBTR	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
16	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
17	AREWR	GR/IR account clearing value in local currency	decimal	13	2	CURR	((0))	Yes		AREWR
18	WESBS	Goods Receipt Blocked Stock in Order Unit	decimal	13	3	QUAN	((0))	Yes		WESBS
19	BPWES	Quantity in GR blocked stock in order price unit	decimal	13	3	QUAN	((0))	Yes		BPWES
20	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
21	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
22	ELIKZ	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
23	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
24	LFGJA	Fiscal Year of a Reference Document	nvarchar	4	0	NUMC	(N'0000')	Yes		LFBJA	Allow NULL?
25	LFBNR	Document No. of a Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes		LFBNR	Allow NULL?
26	LFPOS	Item of a Reference Document	nvarchar	4	0	NUMC	(N'0000')	Yes		LFPOS	Allow NULL?
27	GRUND	Reason for Movement	nvarchar	4	0	NUMC	(N'0000')	Yes	T157D	MB_GRBEW	Allow NULL?
28	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	DATS	(N'00000000')	Yes		CPUDT	Allow NULL?
29	CPUTM	Time of Entry	nvarchar	6	0	TIMS	(N'000000')	Yes		CPUTM	Allow NULL?
30	REEWR	Invoice Value Entered (in Local Currency)	decimal	13	2	CURR	((0))	Yes		REEWR
31	EVERE	Compliance with Shipping Instructions	nvarchar	2	0	CHAR	(N' ')	Yes	T027C	EVERE	Allow NULL?
32	REFWR	Invoice value in foreign currency	decimal	13	2	CURR	((0))	Yes		REFWR
33	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
34	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
35	XWSBR	Reversal of GR allowed for GR-based IV despite invoice	char	1	0	CHAR	(N' ')	Yes		XWSBR	Allow NULL?
36	ETENS	Sequential Number of Vendor Confirmation	nvarchar	4	0	NUMC	(N'0000')	Yes		ETENS	Allow NULL?
37	KNUMV	Number of the document condition	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMV	Allow NULL?
38	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
39	LSMNG	Quantity in Unit of Measure from Delivery Note	decimal	13	3	QUAN	((0))	Yes		LSMNG
40	LSMEH	Unit of Measure From Delivery Note	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LSMEH	Allow NULL?
41	EMATN	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	EMATNR	Allow NULL?
42	AREWW	Clearing value on GR/IR clearing account (transac. currency)	decimal	13	2	CURR	((0))	Yes		AREWW
43	HSWAE	Local currency key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	HSWAE	Allow NULL?
44	BAMNG	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
45	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
46	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
47	XWOFF	Calculation of val. open	char	1	0	CHAR	(N' ')	Yes		XWOFF	Allow NULL?
48	XUNPL	Unplanned Account Assignment from Invoice Verification	char	1	0	CHAR	(N' ')	Yes		XUNPL	Allow NULL?
49	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
50	SRVPOS	Service number	nvarchar	18	0	CHAR	(N' ')	Yes	*	SRVPOS	Allow NULL?
51	PACKNO	Package Number of Service	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PACKNO_EKBE	Allow NULL?
52	INTROW	Line Number of Service	nvarchar	10	0	NUMC	(N'0000000000')	Yes		INTROW_EKBE	Allow NULL?
53	BEKKN	Number of PO Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		BEKKN	Allow NULL?
54	LEMIN	Returns Indicator	char	1	0	CHAR	(N' ')	Yes		SRVRET	Allow NULL?
55	AREWB	Clearing Value on GR/IR Account in PO Currency	decimal	13	2	CURR	((0))	Yes		AREWB
56	REWRB	Invoice Amount in PO Currency	decimal	13	2	CURR	((0))	Yes		REWRB
57	SAPRL	SAP Release	nvarchar	4	0	CHAR	(N' ')	Yes		SAPRL	Allow NULL?
58	MENGE_POP	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
59	BPMNG_POP	Quantity in purchase order price unit	decimal	13	3	QUAN	((0))	Yes		MENGE_BPR
60	DMBTR_POP	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
61	WRBTR_POP	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
62	WESBB	Valuated Goods Receipt Blocked Stock in Order Unit	decimal	13	3	QUAN	((0))	Yes		WESBB
63	BPWEB	Quantity in Valuated GR Blocked Stock in Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPWEB
64	WEORA	Acceptance At Origin	char	1	0	CHAR	(N' ')	Yes		WEORA	Allow NULL?
65	AREWR_POP	GR/IR account clearing value in local currency	decimal	13	2	CURR	((0))	Yes		AREWR
66	KUDIF	Exchange Rate Difference Amount	decimal	13	2	CURR	((0))	Yes		KUDIF
67	RETAMT_FC	Retention Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		RET_AMT_FC
68	RETAMT_LC	Retention Amount in Company Code Currency	decimal	13	2	CURR	((0))	Yes		RET_AMT_LC
69	RETAMTP_FC	Posted Retention Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		RET_AMT_POST_FC
70	RETAMTP_LC	Posted Security Retention Amount in Company Code Currency	decimal	13	2	CURR	((0))	Yes		RET_AMT_POST_LC
71	XMACC	Multiple Account Assignment	char	1	0	CHAR	(N' ')	Yes		XMACC	Allow NULL?
72	WKURS	Exchange Rate	decimal	9	5	DEC	((0))	Yes		WKURS
73	INV_ITEM_ORIGIN	Origin of an Invoice Item	char	1	0	CHAR	(N' ')	Yes		INV_ITM_ORIGIN	Allow NULL?
74	VBELN_ST	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VL	Allow NULL?
75	VBELP_ST	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VL	Allow NULL?
76	SGT_SCAT	Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_SCAT	Allow NULL?
77	ET_UPD	Procedure for Updating the Schedule Line Quantity	char	1	0	CHAR	(N' ')	Yes		ET_UPD1	Allow NULL?
78	J_SC_DIE_COMP_F	Depreciation completion flag	char	1	0	CHAR	(N' ')	Yes		/SAPNEA/J_SC_DIE_COMP_F	Allow NULL?
79	WRF_CHARSTC1	Characteristic Value 1	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC1	Allow NULL?
80	WRF_CHARSTC2	Characteristic Value 2	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC2	Allow NULL?
81	WRF_CHARSTC3	Characteristic Value 3	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC3	Allow NULL?

Name	Primary	Unique	Type	Columns
EKBE~0	Yes	Yes	CLUSTERED	BUZEI, BELNR, GJAHR, VGABE, ZEKKN, EBELP, EBELN, MANDT
EKBE~A	No	No	NONCLUSTERED	LFBNR, LFGJA, MANDT
EKBE~B	No	No	NONCLUSTERED	XBLNR, MANDT

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

81 COLUMNS | 3 INDEXES | ERP 6.0 | EKBE TABLE

TOP ERP 6.0 | EKBE COLUMNS

TOP ERP 6.0 | EKBE 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

81 COLUMNS | 3 INDEXES | ERP 6.0 | EKBE TABLE

TOPERP 6.0 | EKBE COLUMNS

TOPERP 6.0 | EKBE INDEXES

TOP ERP 6.0 | EKBE COLUMNS

TOP ERP 6.0 | EKBE INDEXES