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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	DOKAR	Document Type	nvarchar	3	Allow NULL?
3	DOKNR	Document number	nvarchar	25	Allow NULL?
4	DOKVR	Document Version	nvarchar	2	Allow NULL?
5	DOKTL	Document Part	nvarchar	3	Allow NULL?
6	ISHMPATDAT	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
7	ISHMPATNAM	IS-H: Patient Name	nvarchar	30	Allow NULL?
8	ISHMPATANR	IS-H: Form-of-Address Text	nvarchar	25	Allow NULL?
9	ISHMPATTIT	IS-H: Title	nvarchar	15	Allow NULL?
10	ISHMPATNNA	Patient Last Name	nvarchar	30	Allow NULL?
11	ISHMPATVNA	IS-H: Patient First Name	nvarchar	30	Allow NULL?
12	ISHMPATZNA	Text Length: 75 Characters	nvarchar	75	Allow NULL?
13	ISHMPATGES	IS-H: Sex Indicator - User-Specific	char	1	Allow NULL?
14	ISHMPATGST	IS-H: Sex Specification - User-Specific	nvarchar	10	Allow NULL?
15	ISHMPATGEB	IS-H: Birthdate	nvarchar	8	Allow NULL?
16	ISHMPATNUM	IS-H: Patient Number	nvarchar	10	Allow NULL?
17	ISHMPATP01	Check Digit for Patient	char	1	Allow NULL?
18	ISHMPATBER	IS-H: Patient Occupation	nvarchar	25	Allow NULL?
19	ISHMPATNAT	IS-H: Nationality	nvarchar	3	Allow NULL?
20	ISHMPATALT	Patient Age	nvarchar	3	Allow NULL?
21	ISHMPATALE	Unit of Age	char	1	Allow NULL?
22	ISHMPATLAN	IS-H: Country	nvarchar	3	Allow NULL?
23	ISHMPATPLZ	IS-H: Postal Code of City	nvarchar	10	Allow NULL?
24	ISHMPATORT	IS-H: City	nvarchar	40	Allow NULL?
25	ISHMPATOR2	IS-H: District	nvarchar	40	Allow NULL?
26	ISHMPATSTR	IS-H: Street	nvarchar	40	Allow NULL?
27	ISHMPATTEL	IS-H: Telephone Number	nvarchar	30	Allow NULL?
28	ISHMPATADR		nvarchar	70	Allow NULL?
29	ISHMPATAGA		nvarchar	70	Allow NULL?
30	ISHMPATAGN	IS-H: Employer Name	nvarchar	30	Allow NULL?
31	ISHMPATAGL	IS-H: Country	nvarchar	3	Allow NULL?
32	ISHMPATAGP	IS-H: Postal Code of City	nvarchar	10	Allow NULL?
33	ISHMPATAGO	IS-H: City	nvarchar	40	Allow NULL?
34	ISHMPATAGS	IS-H: Street	nvarchar	40	Allow NULL?
35	ISHMPATAGT	IS-H: Telephone Number	nvarchar	30	Allow NULL?
36	ISHMPATUVT	IS-H: Insurance Provider Name	nvarchar	40	Allow NULL?
37	ISHMPATUVN	IS-H: Insurance Provider	nvarchar	10	Allow NULL?
38	ISHMPATKVN	IS-H: Insurance Provider	nvarchar	10	Allow NULL?
39	ISHMPATKVT	IS-H: Insurance Provider Name	nvarchar	40	Allow NULL?
40	ISHMPATKVK	IS-H: Short Name of Business Partner	nvarchar	12	Allow NULL?
41	ISHMPATKVL	Error message text - long text of the error	nvarchar	70	Allow NULL?
42	ISHMPATFAL	IS-H: Case Number	nvarchar	10	Allow NULL?
43	ISHMPATF01	Check Digit for Case	char	1	Allow NULL?
44	ISHMPATFAR	IS-H: Case Type	char	1	Allow NULL?
45	ISHMPATFAT	IS-H: Text for Case Type	nvarchar	14	Allow NULL?
46	ISHMPATFBK	Treatment Category	nvarchar	6	Allow NULL?
47	ISHMPATADT	IS-H: Date of Movement	nvarchar	8	Allow NULL?
48	ISHMPATAZT	IS-H: Time of Movement	nvarchar	6	Allow NULL?
49	ISHMPATAPL	IS-H: Planned Indicator for Date of Movement	char	1	Allow NULL?
50	ISHMPATEDT	IS-H: Date of Movement	nvarchar	8	Allow NULL?
51	ISHMPATEZT	IS-H: Time of Movement	nvarchar	6	Allow NULL?
52	ISHMPATEPL	IS-H: Planned Indicator for Date of Movement	char	1	Allow NULL?
53	ISHMPATENR	Institution	nvarchar	4	Allow NULL?
54	ISHMPATEKB	IS-H: Short Text for Institution	nvarchar	15	Allow NULL?
55	ISHMPATFOE	IS-H: OU with Departmental Responsibility for Case	nvarchar	8	Allow NULL?
56	ISHMPATFOT	IS-H: Organizational Unit Short Text	nvarchar	12	Allow NULL?
57	ISHMPATPOE	Organizational Unit Assigned to Case	nvarchar	8	Allow NULL?
58	ISHMPATPOT	IS-H: Organizational Unit Short Text	nvarchar	12	Allow NULL?
59	ISHMPATLOE	IS-H: Organizational Unit that Performs the Service	nvarchar	8	Allow NULL?
60	ISHMPATAFO	Departmental Organizational Unit That Requests the Service	nvarchar	8	Allow NULL?
61	ISHMPATAPO	IS-H: Nursing Organizational Unit Requesting the Service	nvarchar	8	Allow NULL?
62	ISHMPATDOE	Documenting Organizational Unit	nvarchar	8	Allow NULL?
63	ISHMPATDOT	IS-H: Organizational Unit Short Text	nvarchar	12	Allow NULL?
64	PERSTAB	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
65	HAUSARZT	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
66	X00MHANAM	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
67	ISHMHANAM	IS-H: Last and first name of the family physician	nvarchar	40	Allow NULL?
68	ISHMHASTR	IS-H: Street Name and Street Number of Business Partner	nvarchar	30	Allow NULL?
69	ISHMHAORT	IS-H: City of Business Partner	nvarchar	25	Allow NULL?
70	ISHMHAPLZ	IS-H: Postal Code of Business Partner	nvarchar	10	Allow NULL?
71	EINWEISER	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
72	X00MEANAM	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
73	ISHMEANAM	IS-H: Last name and first name of referring physician	nvarchar	40	Allow NULL?
74	ISHMEAORT	IS-H: City of Business Partner	nvarchar	25	Allow NULL?
75	ISHMEAPLZ	IS-H: Postal Code of Business Partner	nvarchar	10	Allow NULL?
76	ISHMEASTR	IS-H: Street Name and Street Number of Business Partner	nvarchar	30	Allow NULL?
77	UNFALL	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
78	ISHMUNFBDT	IS-H: Date of Movement	nvarchar	8	Allow NULL?
79	ISHMUNFBZT	IS-H: Time of Movement	nvarchar	6	Allow NULL?
80	ISHMUNFNUM	IS-H: File Number / Processing Number for Accident	nvarchar	12	Allow NULL?
81	ISHMUNFART	IS-H: Accident Type	nvarchar	3	Allow NULL?
82	ISHMUNFDAT	Accident Date	nvarchar	8	Allow NULL?
83	ISHMUNFZET	IS-H: Time of Accident	nvarchar	6	Allow NULL?
84	ISHMUNFORT	IS-H: Accident Location	nvarchar	25	Allow NULL?
85	ISHMUNFRTN	IS-H: Number of the Emergency Service for Accident	nvarchar	15	Allow NULL?
86	ISHMUNFVER	IS-H: Third-Party Responsibility	char	1	Allow NULL?
87	ISHMUNFBEM	IS-H: Comment on Accident	nvarchar	50	Allow NULL?
88	ISHMUNFLTX	Indicator that Long Text Exists	char	1	Allow NULL?
89	UNTERSCHRS	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
90	ISHMVMAKRZ	Employee Responsible	nvarchar	10	Allow NULL?
91	ISHMVMANAM	Physician Name	nvarchar	50	Allow NULL?
92	UNTERSCHR2	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
93	X00MVMAKRZ	Employee Responsible	nvarchar	10	Allow NULL?
94	ISHMVMANA2	Physician Name	nvarchar	50	Allow NULL?
95	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	Allow NULL?
96	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	Allow NULL?
97	X01MVMAKRZ	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
98	X00MVMANA2	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
99	X02MVMAKRZ	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
100	X00MVMANAM	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
101	MITARBEITE	Reference Key of a Referenced Object	nvarchar	20	Allow NULL?
102	ISHMDIATAB	Reference Key of a Referenced Object	nvarchar	20	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

102 COLUMNS | 1 INDEXES | ERP 6.0 | N0FDBS0000000000 TABLE

TOP ERP 6.0 | N0FDBS0000000000 COLUMNS

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

102 COLUMNS | 1 INDEXES | ERP 6.0 | N0FDBS0000000000 TABLE

TOPERP 6.0 | N0FDBS0000000000 COLUMNS

TOPERP 6.0 | N0FDBS0000000000 INDEXES

TOP ERP 6.0 | N0FDBS0000000000 COLUMNS

TOP ERP 6.0 | N0FDBS0000000000 INDEXES