	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

134 COLUMNS | 1 INDEXES | ERP 6.0 | MEREQX TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Purchasing
1	ERP EHP7	6.0	MEREQX	134	1	Purchase Requisition Change Parameter	Purchasing

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BANFN, BNFPO, BSART, BSTYP, BSAKZ, LOEKZ, STATU, ESTKZ, FRGKZ, FRGZU, FRGST, EKGRP, ERNAM, ERDAT, AFNAM, TXZ01, MATNR, EMATN, WERKS, LGORT, BEDNR, MATKL, RESWK, MENGE, MEINS, BUMNG, BADAT, LPEIN, LFDAT, FRGDT, WEBAZ, PREIS, PEINH, PSTYP, KNTTP, KZVBR, KFLAG, VRTKZ, TWRKZ, WEPOS, WEUNB, REPOS, LIFNR, FLIEF, EKORG, VRTYP, KONNR, KTPNR, INFNR, ZUGBA, QUNUM, QUPOS, DISPO, SERNR, BVDAT, BATOL, BVDRK, EBELN, EBELP, BEDAT, BSMNG, LBLNI, BWTAR, XOBLR, EBAKZ, RSNUM, SOBKZ, ARSNR, ARSPS, FIXKZ, BMEIN, REVLV, VORAB, PACKNO, KANBA, BPUEB, CUOBJ, FRGGR, FRGRL, AKTNR, CHARG, UMSOK, VERID, FIPOS, FISTL, GEBER, KZKFG, SATNR, MNG02, DAT01, ATTYP, ADRNR, ADRN2, KUNNR, EMLIF, LBLKZ, KZBWS, WEARS, IDNLF, GSFRG, MPROF, KZFME, SPRAS, TECHS, MFRPN, MFRNR, EMNFR, FORDN, FORDP, PLIFZ, BERID, UZEIT, FKBER, GRANT_NBR, MEMORY, BANPR, RLWRT, BLCKD, REVNO, BLCKT, BESWK, EPROFILE, EPREFDOC, EPREFITM, GMMNG, WRTKZ, RESLO, KBLNR, KBLPOS, PRIO_URG, PRIO_REQ, MEMORYTYPE, ANZSN FROM MEREQX

TOP ERP 6.0 | MEREQX COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	BANFN	Purchase Requisition Number	nvarchar	10	CHAR	(N' ')	No		BANFN	Allow NULL?
3	BNFPO	Item Number of Purchase Requisition	nvarchar	5	NUMC	(N'00000')	No	*	BNFPO	Allow NULL?
4	BSART	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
5	BSTYP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
6	BSAKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
7	LOEKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
8	STATU	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
9	ESTKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
10	FRGKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
11	FRGZU	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
12	FRGST	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
13	EKGRP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
14	ERNAM	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
15	ERDAT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
16	AFNAM	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
17	TXZ01	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
18	MATNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
19	EMATN	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
20	WERKS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
21	LGORT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
22	BEDNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
23	MATKL	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
24	RESWK	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
25	MENGE	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
26	MEINS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
27	BUMNG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
28	BADAT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
29	LPEIN	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
30	LFDAT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
31	FRGDT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
32	WEBAZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
33	PREIS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
34	PEINH	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
35	PSTYP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
36	KNTTP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
37	KZVBR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
38	KFLAG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
39	VRTKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
40	TWRKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
41	WEPOS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
42	WEUNB	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
43	REPOS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
44	LIFNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
45	FLIEF	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
46	EKORG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
47	VRTYP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
48	KONNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
49	KTPNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
50	INFNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
51	ZUGBA	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
52	QUNUM	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
53	QUPOS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
54	DISPO	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
55	SERNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
56	BVDAT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
57	BATOL	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
58	BVDRK	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
59	EBELN	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
60	EBELP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
61	BEDAT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
62	BSMNG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
63	LBLNI	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
64	BWTAR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
65	XOBLR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
66	EBAKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
67	RSNUM	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
68	SOBKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
69	ARSNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
70	ARSPS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
71	FIXKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
72	BMEIN	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
73	REVLV	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
74	VORAB	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
75	PACKNO	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
76	KANBA	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
77	BPUEB	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
78	CUOBJ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
79	FRGGR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
80	FRGRL	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
81	AKTNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
82	CHARG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
83	UMSOK	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
84	VERID	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
85	FIPOS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
86	FISTL	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
87	GEBER	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
88	KZKFG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
89	SATNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
90	MNG02	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
91	DAT01	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
92	ATTYP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
93	ADRNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
94	ADRN2	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
95	KUNNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
96	EMLIF	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
97	LBLKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
98	KZBWS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
99	WEARS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
100	IDNLF	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
101	GSFRG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
102	MPROF	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
103	KZFME	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
104	SPRAS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
105	TECHS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
106	MFRPN	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
107	MFRNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
108	EMNFR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
109	FORDN	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
110	FORDP	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
111	PLIFZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
112	BERID	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
113	UZEIT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
114	FKBER	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
115	GRANT_NBR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
116	MEMORY	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
117	BANPR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
118	RLWRT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
119	BLCKD	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
120	REVNO	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
121	BLCKT	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
122	BESWK	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
123	EPROFILE	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
124	EPREFDOC	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
125	EPREFITM	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
126	GMMNG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
127	WRTKZ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
128	RESLO	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
129	KBLNR	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
130	KBLPOS	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
131	PRIO_URG	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
132	PRIO_REQ	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
133	MEMORYTYPE	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?
134	ANZSN	Updated information in related user data field	char	1	CHAR	(N' ')	Yes		BAPIUPDATE	Allow NULL?

TOP ERP 6.0 | MEREQX INDEXES

Name	Primary	Unique	Type	Columns
MEREQX~0	Yes	Yes	CLUSTERED	BNFPO, BANFN, 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

134 COLUMNS | 1 INDEXES | ERP 6.0 | MEREQX TABLE

TOP ERP 6.0 | MEREQX COLUMNS

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

134 COLUMNS | 1 INDEXES | ERP 6.0 | MEREQX TABLE

TOPERP 6.0 | MEREQX COLUMNS

TOPERP 6.0 | MEREQX INDEXES

TOP ERP 6.0 | MEREQX COLUMNS

TOP ERP 6.0 | MEREQX INDEXES