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
Industry Specific :: SAP Healthcare - Industry-Specific Components for Hospitals :: SAP Ambulatory Care Management
1	ERP EHP7	6.0	N3DV2KNE	106	1	PMD: N3DA_KNEB BG: KNEB - ErgBericht Knie Version 7.1.01	SAP Ambulatory Care Management

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Mandant	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	DOKAR	Dokumentart	nvarchar	3	CHAR	(N' ')	No	*	DOKAR	Allow NULL?
3	DOKNR	Dokumentnummer	nvarchar	25	CHAR	(N' ')	No	*	DOKNR	Allow NULL?
4	DOKVR	Dokumentversion	nvarchar	2	CHAR	(N' ')	No		DOKVR	Allow NULL?
5	DOKTL	Teildokument	nvarchar	3	CHAR	(N' ')	No		DOKTL_D	Allow NULL?
6	N3DV2ANL01	DU-Nummer des ursprünglichen D/H-Berichtes	nvarchar	33	CHAR	(N' ')	Yes		N3BG_ANL1	Allow NULL?
7	N3DV2ANL02	Datum des entsprechenden Durchgangsarzt-/H-Arztberichtes	nvarchar	8	DATS	(N'00000000')	Yes		N3BG_ANL2	Allow NULL?
8	N3DV2VIN01	Nachnahme des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN01	Allow NULL?
9	N3DV2VIN02	Vorname des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN02	Allow NULL?
10	N3DV2VIN04	Geschlecht des Versicherten	char	1	CHAR	(N' ')	Yes		N3DV2VIN04	Allow NULL?
11	N3DV2VIN09	Geburtsdatum des Versicherten	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2VIN09	Allow NULL?
12	N3DV2VIN10	Telefon des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN10	Allow NULL?
13	N3DV2VIN03	Staatsangehörigkeit des Versicherten	nvarchar	3	CHAR	(N' ')	Yes		N3DV2VIN03	Allow NULL?
14	N3DV2VIN08	Länderkennzeichen des Versicherten	nvarchar	3	CHAR	(N' ')	Yes		N3DV2VIN08	Allow NULL?
15	N3DV2VIN05	PLZ des Versicherten	nvarchar	6	CHAR	(N' ')	Yes		N3DV2VIN05	Allow NULL?
16	N3DV2VIN06	Ort des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN06	Allow NULL?
17	N3DV2VIN07	Strasse und Hausnummer des Versicherten	nvarchar	46	CHAR	(N' ')	Yes		N3DV2VIN07	Allow NULL?
18	N3DV2VIN11	Versichertennummer der GKV	nvarchar	12	CHAR	(N' ')	Yes		N3DV2VIN11	Allow NULL?
19	N3DV2UVT01	Namensangaben	nvarchar	80	CHAR	(N' ')	Yes		N3BG_NAME	Allow NULL?
20	N3DV2UVT02	IK-Nummer des UV-Trägers	nvarchar	9	CHAR	(N' ')	Yes		N3DV2UVT02	Allow NULL?
21	N3DV2UVT05	Aktenzeichen des UV-Trägers	nvarchar	65	CHAR	(N' ')	Yes		N3DV2UVT05	Allow NULL?
22	N3DV2UVT04	Unfalltag	nvarchar	10	CHAR	(N' ')	Yes		N3DV2UVT04	Allow NULL?
23	N3DV2UVT03	Erstellungsdatum des Berichtes	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2UVT03	Allow NULL?
24	N3DV2ABS01	Namensangaben	nvarchar	80	CHAR	(N' ')	Yes		N3BG_NAME	Allow NULL?
25	N3DV2ABS06	Telefon des Absenders	nvarchar	30	CHAR	(N' ')	Yes		N3DV2ABS06	Allow NULL?
26	N3DV2ABS05	Länderkennzeichen des Absenders	nvarchar	3	CHAR	(N' ')	Yes		N3DV2ABS05	Allow NULL?
27	N3DV2ABS03	PLZ des Absenders	nvarchar	6	CHAR	(N' ')	Yes		N3DV2ABS03	Allow NULL?
28	N3DV2ABS04	Ort des Absenders	nvarchar	30	CHAR	(N' ')	Yes		N3DV2ABS04	Allow NULL?
29	N3DV2ABS02	Strasse und Nr. des Absenders	nvarchar	46	CHAR	(N' ')	Yes		N3DV2ABS02	Allow NULL?
30	N3DV2ABS07	Name des Ansprechpartners	nvarchar	30	CHAR	(N' ')	Yes		N3DV2ABS07	Allow NULL?
31	N3DV2TKN01	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
32	N3DV2TKN02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
33	N3DV2VNE01	Unfall gemeldet	char	1	CHAR	(N' ')	Yes		N3DV2VNE01	Allow NULL?
34	N3DV2VNE02	Unfall gemeldet am	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2VNE02	Allow NULL?
35	N3DV2VNE03	Zeitpunkt Arbeitseinstellung	char	1	CHAR	(N' ')	Yes		N3DV2VNE03	Allow NULL?
36	N3DV2VNE04	Datum der Arbeitseinstellung	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2VNE04	Allow NULL?
37	N3DV2VNE05	Art der Fortbewegung	char	1	CHAR	(N' ')	Yes		N3DV2VNE05	Allow NULL?
38	N3DV2VNE06	BG: allgemeines Datumsfeld für diverse Angaben in Formularen	nvarchar	8	DATS	(N'00000000')	Yes		N3BG_DATS	Allow NULL?
39	N3DV2VNE07	Erste ärztliche Untersuchung um	nvarchar	6	TIMS	(N'000000')	Yes		N3DV2VNE07	Allow NULL?
40	N3DV2VNE08	Erste ärztliche Untersuchung durch	nvarchar	60	CHAR	(N' ')	Yes		N3DV2VNE08	Allow NULL?
41	N3DV2BND01	Äußere Verletzungszeichen	char	1	CHAR	(N' ')	Yes		N3DV2BND01	Allow NULL?
42	N3DV2BND02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
43	N3DV2BND03	Blutergussverfärbung	char	1	CHAR	(N' ')	Yes		N3DV2BND03	Allow NULL?
44	N3DV2BND04	Blutergußverfärbung	char	1	CHAR	(N' ')	Yes		N3BG_BE14	Allow NULL?
45	N3DV2BND05	Weichteilschwellung	char	1	CHAR	(N' ')	Yes		N3DV2BND05	Allow NULL?
46	N3DV2BND06	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
47	N3DV2BND07	Kapselverdickung	char	1	CHAR	(N' ')	Yes		N3DV2BND07	Allow NULL?
48	N3DV2BND08	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
49	N3DV2BND09	Schleimbeutelbeteiligung	char	1	CHAR	(N' ')	Yes		N3DV2BND09	Allow NULL?
50	N3DV2BND10	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
51	N3DV2BND12	Druckempfindlichkeit	char	1	CHAR	(N' ')	Yes		N3DV2BND12	Allow NULL?
52	N3DV2BND13	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
53	N3DV2BND11	grobe Prüfung der Haut	char	1	CHAR	(N' ')	Yes		N3DV2BND11	Allow NULL?
54	N3DV2BND14	Innenbandführung	char	1	CHAR	(N' ')	Yes		N3DV2BND14	Allow NULL?
55	N3DV2BND15	Außenbandführung	char	1	CHAR	(N' ')	Yes		N3DV2BND15	Allow NULL?
56	N3DV2BND16	Schubladenzeichen	char	1	CHAR	(N' ')	Yes		N3DV2BND16	Allow NULL?
57	N3DV2BND17	Bandführung Gegenseite	char	1	CHAR	(N' ')	Yes		N3DV2BND17	Allow NULL?
58	N3DV2BND18	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
59	N3DV2BND19	Einklemmungserscheinungen	char	1	CHAR	(N' ')	Yes		N3DV2BND19	Allow NULL?
60	N3DV2BND20	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
61	N3DV2BND21	Meniskusbeteiligung	char	1	CHAR	(N' ')	Yes		N3DV2BND21	Allow NULL?
62	N3DV2BND22	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
63	N3DV2BND24	Gelenkgeräusche links	char	1	CHAR	(N' ')	Yes		N3DV2BND24	Allow NULL?
64	N3DV2BND23	Gelenkgeräusche rechts	char	1	CHAR	(N' ')	Yes		N3DV2BND23	Allow NULL?
65	N3DV2BND25	Gelenkgräusche beidseitig gleich stark	char	1	CHAR	(N' ')	Yes		N3DV2BND25	Allow NULL?
66	N3DV2BND26	Bewegungsmass rechts Linker Wert Streckung	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND26	Allow NULL?
67	N3DV2BND27	Bewegungsmass rechts Mittelwert	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND27	Allow NULL?
68	N3DV2BND28	Bewegungsmass rechts Beugung	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND28	Allow NULL?
69	N3DV2BND29	Bewegungsmass links Streckung	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND29	Allow NULL?
70	N3DV2BND30	Bewegungsmass links Mittelwert	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND30	Allow NULL?
71	N3DV2BND31	Bewegungsmass links Beugung	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND31	Allow NULL?
72	N3DV2BND32	Umfangmasse Oberschenkel rechts	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND32	Allow NULL?
73	N3DV2BND33	Umfangmasse Oberschenkel links	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND33	Allow NULL?
74	N3DV2BND34	Umfangmasse Kniescheibenmitte	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND34	Allow NULL?
75	N3DV2BND35	Umfangmasse Kniescheibenmitte links	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND35	Allow NULL?
76	N3DV2BND36	Gelenkerguss	char	1	CHAR	(N' ')	Yes		N3DV2BND36	Allow NULL?
77	N3DV2BND37	Punktion	char	1	CHAR	(N' ')	Yes		N3DV2BND37	Allow NULL?
78	N3DV2BND38	Punktion Menge in ml	nvarchar	4	CHAR	(N' ')	Yes		N3DV2BND38	Allow NULL?
79	N3DV2BND39	Punktat	char	1	CHAR	(N' ')	Yes		N3DV2BND39	Allow NULL?
80	N3DV2BND41	Bakteriologische Untersuchung	char	1	CHAR	(N' ')	Yes		N3DV2BND41	Allow NULL?
81	N3DV2BND42	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
82	N3DV2BND43	CRP	char	1	CHAR	(N' ')	Yes		N3DV2BND43	Allow NULL?
83	N3DV2BND44	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
84	N3DV2BES01	Eintritt der Beschwerden	char	1	CHAR	(N' ')	Yes		N3DV2BES01	Allow NULL?
85	N3DV2BES02	Datum der Beschwerden	nvarchar	10	CHAR	(N' ')	Yes		N3DV2BES02	Allow NULL?
86	N3DV2BES03	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
87	N3DV2UUK01	Unfallunabhängige Erkrankungen	char	1	CHAR	(N' ')	Yes		N3DV2UUK01	Allow NULL?
88	N3DV2UUK02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
89	N3DV2UUK03	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
90	N3DV2UUK04	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
91	N3DV2UUK05	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
92	N3DV2UUK06	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
93	N3DV2UUK07	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
94	N3DV2SPB01	Sportliche Betätigung	char	1	CHAR	(N' ')	Yes		N3DV2SPB01	Allow NULL?
95	N3DV2SPB02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
96	N3DV2BFB01	Untertagetätigkeit	char	1	CHAR	(N' ')	Yes		N3DV2BFB01	Allow NULL?
97	N3DV2BFB02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
98	N3DV2BFB03	Kniende Tätigkeit	char	1	CHAR	(N' ')	Yes		N3DV2BFB03	Allow NULL?
99	N3DV2BFB04	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
100	N3DV2BBV01	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
101	N3DV2WME01	Weitere Maßnahmen erforderlich	char	1	CHAR	(N' ')	Yes		N3DV2WME01	Allow NULL?
102	N3DV2WME02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
103	N3DV2WUB01	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
104	N3DV2BND40	Punktat Aussehen	char	1	CHAR	(N' ')	Yes		N3DVBND40	Allow NULL?
105	N3DV3VIN12	Personalunfall Ja/Nein	char	1	CHAR	(N' ')	Yes		N3DV3VIN12	Allow NULL?
106	N3DV2NOT01	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	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

106 COLUMNS | 1 INDEXES | ERP 6.0 | N3DV2KNE TABLE

TOP ERP 6.0 | N3DV2KNE COLUMNS

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

106 COLUMNS | 1 INDEXES | ERP 6.0 | N3DV2KNE TABLE

TOPERP 6.0 | N3DV2KNE COLUMNS

TOPERP 6.0 | N3DV2KNE INDEXES

TOP ERP 6.0 | N3DV2KNE COLUMNS

TOP ERP 6.0 | N3DV2KNE INDEXES