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	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
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

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Mandant	nvarchar	3	Allow NULL?
2	EINRI	IS-H: Einrichtung	nvarchar	4	Allow NULL?
3	FACNUM	ISH NL Sammelrechnung nummer	nvarchar	8	Allow NULL?
4	VBELN	Faktura	nvarchar	10	Allow NULL?
5	POSNR	Fakturaposition	nvarchar	6	Allow NULL?
6	RECID		nvarchar	10	Allow NULL?
7	PATNR	IS-H: Patientennummer	nvarchar	10	Allow NULL?
8	LEIST_S	Leistung innerhalb eines Leistungskataloges	nvarchar	10	Allow NULL?
9	LNRLS_S	IS-H: Laufende Nummer der Leistung	nvarchar	10	Allow NULL?
10	KENMRK		nvarchar	2	Allow NULL?
11	IDENT		nvarchar	12	Allow NULL?
12	BSNNR		nvarchar	9	Allow NULL?
13	KKSNR		nvarchar	4	Allow NULL?
14	VERSNR		nvarchar	15	Allow NULL?
15	MACHNR		nvarchar	15	Allow NULL?
16	DRST		char	1	Allow NULL?
17	GBDAT		nvarchar	8	Allow NULL?
18	PRSCOD		nvarchar	3	Allow NULL?
19	EXTNR		nvarchar	6	Allow NULL?
20	ISHBEGDT		nvarchar	8	Allow NULL?
21	ISHENDDT		nvarchar	8	Allow NULL?
22	PRVLNR		nvarchar	2	Allow NULL?
23	ZORGPROD		nvarchar	9	Allow NULL?
24	TRJNR		nvarchar	15	Allow NULL?
25	TRJBEGDT		nvarchar	8	Allow NULL?
26	TRJENDDT		nvarchar	8	Allow NULL?
27	AFCODE		nvarchar	2	Allow NULL?
28	SUBTRJNR		nvarchar	15	Allow NULL?
29	VERWDAT		nvarchar	8	Allow NULL?
30	VERWCOD		nvarchar	2	Allow NULL?
31	AGNUM		nvarchar	8	Allow NULL?
32	ZRGCOD		nvarchar	4	Allow NULL?
33	AGNUM2		nvarchar	8	Allow NULL?
34	REFTRJNR		nvarchar	15	Allow NULL?
35	FKIMG		nvarchar	4	Allow NULL?
36	ZORGT		nvarchar	6	Allow NULL?
37	ZORGVRT		char	1	Allow NULL?
38	ZORGVR		nvarchar	3	Allow NULL?
39	DIAGNLIST		nvarchar	3	Allow NULL?
40	DIAGN		nvarchar	7	Allow NULL?
41	DKAT		nvarchar	3	Allow NULL?
42	DKEY		nvarchar	7	Allow NULL?
43	CLAIM_ACPT		char	1	Allow NULL?
44	TOELPRES		nvarchar	3	Allow NULL?
45	HERDECL		nvarchar	2	Allow NULL?
46	ACT_AUT		char	1	Allow NULL?
47	ACT_ORA		char	1	Allow NULL?
48	DECSPEC		nvarchar	4	Allow NULL?
49	KKSCOD		nvarchar	8	Allow NULL?
50	ZPT		nvarchar	200	Allow NULL?
51	ZPV		nvarchar	12	Allow NULL?
52	CERTV		nvarchar	12	Allow NULL?
53	GROUID		nvarchar	3	Allow NULL?
54	GROUV		nvarchar	12	Allow NULL?
55	TABLV		nvarchar	20	Allow NULL?
56	GROUT		char	1	Allow NULL?
57	LEIST		nvarchar	10	Allow NULL?
58	LNRLS		nvarchar	15	Allow NULL?
59	ZORGPADCOD		nvarchar	2	Allow NULL?
60	DIAGNLIST3		nvarchar	3	Allow NULL?
61	PARA_REFD		nvarchar	8	Allow NULL?
62	PARA_SOORT		nvarchar	3	Allow NULL?
63	PARA_SECOND		char	1	Allow NULL?
64	PARA_END_RN		nvarchar	2	Allow NULL?
65	UNFKZ		char	1	Allow NULL?
66	SHKZG		char	1	Allow NULL?
67	REFNR_REC		nvarchar	20	Allow NULL?
68	REFNR_PREC		nvarchar	20	Allow NULL?
69	RESRV1		nvarchar	15	Allow NULL?

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

69 COLUMNS | 1 INDEXES | ERP 6.0 | NNL_ZH308_V9_R04 TABLE

TOP ERP 6.0 | NNL_ZH308_V9_R04 COLUMNS

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

69 COLUMNS | 1 INDEXES | ERP 6.0 | NNL_ZH308_V9_R04 TABLE

TOPERP 6.0 | NNL_ZH308_V9_R04 COLUMNS

TOPERP 6.0 | NNL_ZH308_V9_R04 INDEXES

TOP ERP 6.0 | NNL_ZH308_V9_R04 COLUMNS

TOP ERP 6.0 | NNL_ZH308_V9_R04 INDEXES