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	N3DV2STE	96	1	PMD: N3DA_STEB BG: STEB - ErgBericht Strom 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	N3DV2ABS01	Namensangaben	nvarchar	80	CHAR	(N' ')	Yes		N3BG_NAME	Allow NULL?
7	N3DV2ABS02	Strasse und Nr. des Absenders	nvarchar	46	CHAR	(N' ')	Yes		N3DV2ABS02	Allow NULL?
8	N3DV2ABS03	PLZ des Absenders	nvarchar	6	CHAR	(N' ')	Yes		N3DV2ABS03	Allow NULL?
9	N3DV2ABS04	Ort des Absenders	nvarchar	30	CHAR	(N' ')	Yes		N3DV2ABS04	Allow NULL?
10	N3DV2ABS05	Länderkennzeichen des Absenders	nvarchar	3	CHAR	(N' ')	Yes		N3DV2ABS05	Allow NULL?
11	N3DV2ABS06	Telefon des Absenders	nvarchar	30	CHAR	(N' ')	Yes		N3DV2ABS06	Allow NULL?
12	N3DV2ABS07	Name des Ansprechpartners	nvarchar	30	CHAR	(N' ')	Yes		N3DV2ABS07	Allow NULL?
13	N3DV2ANL01	DU-Nummer des ursprünglichen D/H-Berichtes	nvarchar	33	CHAR	(N' ')	Yes		N3BG_ANL1	Allow NULL?
14	N3DV2ANL02	Datum des entsprechenden Durchgangsarzt-/H-Arztberichtes	nvarchar	8	DATS	(N'00000000')	Yes		N3BG_ANL2	Allow NULL?
15	N3DV2VIN01	Nachnahme des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN01	Allow NULL?
16	N3DV2VIN02	Vorname des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN02	Allow NULL?
17	N3DV2VIN04	Geschlecht des Versicherten	char	1	CHAR	(N' ')	Yes		N3DV2VIN04	Allow NULL?
18	N3DV2VIN09	Geburtsdatum des Versicherten	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2VIN09	Allow NULL?
19	N3DV2VIN10	Telefon des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN10	Allow NULL?
20	N3DV2VIN03	Staatsangehörigkeit des Versicherten	nvarchar	3	CHAR	(N' ')	Yes		N3DV2VIN03	Allow NULL?
21	N3DV2VIN08	Länderkennzeichen des Versicherten	nvarchar	3	CHAR	(N' ')	Yes		N3DV2VIN08	Allow NULL?
22	N3DV2VIN05	PLZ des Versicherten	nvarchar	6	CHAR	(N' ')	Yes		N3DV2VIN05	Allow NULL?
23	N3DV2VIN06	Ort des Versicherten	nvarchar	30	CHAR	(N' ')	Yes		N3DV2VIN06	Allow NULL?
24	N3DV2VIN07	Strasse und Hausnummer des Versicherten	nvarchar	46	CHAR	(N' ')	Yes		N3DV2VIN07	Allow NULL?
25	N3DV2VIN11	Versichertennummer der GKV	nvarchar	12	CHAR	(N' ')	Yes		N3DV2VIN11	Allow NULL?
26	N3DV2UVT01	Namensangaben	nvarchar	80	CHAR	(N' ')	Yes		N3BG_NAME	Allow NULL?
27	N3DV2UVT02	IK-Nummer des UV-Trägers	nvarchar	9	CHAR	(N' ')	Yes		N3DV2UVT02	Allow NULL?
28	N3DV2UVT05	Aktenzeichen des UV-Trägers	nvarchar	65	CHAR	(N' ')	Yes		N3DV2UVT05	Allow NULL?
29	N3DV2UVT04	Unfalltag	nvarchar	10	CHAR	(N' ')	Yes		N3DV2UVT04	Allow NULL?
30	N3DV2UVT03	Erstellungsdatum des Berichtes	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2UVT03	Allow NULL?
31	N3DV2EIN01	Eingetroffen am	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2EIN01	Allow NULL?
32	N3DV2EIN02	Eintreffzeit	nvarchar	6	TIMS	(N'000000')	Yes		N3DV2EIN02	Allow NULL?
33	N3DV2EIN03	Eingetroffen mit	char	1	CHAR	(N' ')	Yes		N3DV2EIN03	Allow NULL?
34	N3DV2ZUS01	Benommenheit	char	1	CHAR	(N' ')	Yes		N3DV2ZUS01	Allow NULL?
35	N3DV2ZUS02	Bewusstlosigkeit	char	1	CHAR	(N' ')	Yes		N3DV2ZUS02	Allow NULL?
36	N3DV2ZUS03	Atemstillstand	char	1	CHAR	(N' ')	Yes		N3DV2ZUS03	Allow NULL?
37	N3DV2ZUS04	Kreislaufstillstand	char	1	CHAR	(N' ')	Yes		N3DV2ZUS04	Allow NULL?
38	N3DV2ZUS05	Dauer des Zustandes	nvarchar	70	CHAR	(N' ')	Yes		N3DV2ZUS05	Allow NULL?
39	N3DV2ZUS06	Zustand wiederholt eingetreten	nvarchar	70	CHAR	(N' ')	Yes		N3DV2ZUS06	Allow NULL?
40	N3DV2ZUS07	Zustand festgestellt durch	nvarchar	70	CHAR	(N' ')	Yes		N3DV2ZUS07	Allow NULL?
41	N3DV2WBM01	Wurden Wiederbelebungsmaßnahmen durchgeführt	char	1	CHAR	(N' ')	Yes		N3DV2WBM01	Allow NULL?
42	N3DV2WBM02	mit Gerät	char	1	CHAR	(N' ')	Yes		N3DV2WBM02	Allow NULL?
43	N3DV2WBM05	welches Gerät	char	1	CHAR	(N' ')	Yes		N3DV2WBM05	Allow NULL?
44	N3DV2WBM03	Methoden	char	1	CHAR	(N' ')	Yes		N3DV2WBM03	Allow NULL?
45	N3DV2WBM04	Andere Methode	nvarchar	70	CHAR	(N' ')	Yes		N3DV2WBM04	Allow NULL?
46	N3DV2WBM06	Zeit zwischen Unfall und Wiederbelebungsmaßnahme	nvarchar	6	TIMS	(N'000000')	Yes		N3DV2WBM06	Allow NULL?
47	N3DV2WBM07	Dauer Wiederbelebungsmassnahme	nvarchar	6	TIMS	(N'000000')	Yes		N3DV2WBM07	Allow NULL?
48	N3DV2WBM08	WBM durchgeführt durch	nvarchar	70	CHAR	(N' ')	Yes		N3DV2WBM08	Allow NULL?
49	N3DV2MSM01	medikamentöser Eingriff	char	1	CHAR	(N' ')	Yes		N3DV2MSM01	Allow NULL?
50	N3DV2MSM02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
51	N3DV2MSM03	Weitere Behandlung	char	1	CHAR	(N' ')	Yes		N3DV2MSM03	Allow NULL?
52	N3DV2SOK01	bestand ein Schock	char	1	CHAR	(N' ')	Yes		N3DV2SOK01	Allow NULL?
53	N3DV2SOK02	Beginn des Schocks	nvarchar	6	TIMS	(N'000000')	Yes		N3DV2SOK02	Allow NULL?
54	N3DV2SOK03	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
55	N3DV2SOK05	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
56	N3DV2VAT01	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
57	N3DV2VAT02	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
58	N3DV2VAT03	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
59	N3DV2VAT04	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
60	N3DV2VAT05	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
61	N3DV2VKT01	Grund der Verbrennung	char	1	CHAR	(N' ')	Yes		N3DV2VKT01	Allow NULL?
62	N3DV2VKT02	Prozent	nvarchar	7	CHAR	(N' ')	Yes		N3DV2VKT02	Allow NULL?
63	N3DV2VKT03	Festgestellte Strommarken	char	1	CHAR	(N' ')	Yes		N3DV2VKT03	Allow NULL?
64	N3DV2VKT04	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
65	N3DV2VKT05	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
66	N3DV2SYM01	Erinnerungsvermögen	char	1	CHAR	(N' ')	Yes		N3DV2SYM01	Allow NULL?
67	N3DV2SYM02	Änderung der Beschwerden	char	1	CHAR	(N' ')	Yes		N3DV2SYM02	Allow NULL?
68	N3DV2SYM03	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
69	N3DV2SYM04	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
70	N3DV2SYM05	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
71	N3DV2SYM06	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
72	N3DV2SYM07	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
73	N3DV2SYM08	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
74	N3DV2SYM09	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
75	N3DV2SYM10	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
76	N3DV2SYM11	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
77	N3DV2SYM12	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
78	N3DV2SYM13	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
79	N3DV2SYM14	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
80	N3DV2USU01	Pulsfrequenz	nvarchar	4	CHAR	(N' ')	Yes		N3DV2USU01	Allow NULL?
81	N3DV2USU02	Blutdruck	nvarchar	7	CHAR	(N' ')	Yes		N3DV2USU02	Allow NULL?
82	N3DV2USU03	Atmung	char	1	CHAR	(N' ')	Yes		N3DV2USU03	Allow NULL?
83	N3DV2USU04	Atemzüge pro Minute	nvarchar	4	CHAR	(N' ')	Yes		N3DV2USU04	Allow NULL?
84	N3DV2USU05	Urinuntersuchung	char	1	CHAR	(N' ')	Yes		N3DV2USU05	Allow NULL?
85	N3DV2USU06	stationäre Behandlung	char	1	CHAR	(N' ')	Yes		N3DV2USU06	Allow NULL?
86	N3DV2USU07	Aufnehmendes Krankenhaus	nvarchar	100	CHAR	(N' ')	Yes		N3DV2USU07	Allow NULL?
87	N3DV2USU10	Voraussichtliches Ende der AU	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2USU10	Allow NULL?
88	N3DV2ZUU01	Zusatzuntersuchung veranlasst	char	1	CHAR	(N' ')	Yes		N3DV2ZUU01	Allow NULL?
89	N3DV2ZUU02	Fachrichtung	char	1	CHAR	(N' ')	Yes		N3DV2ZUU02	Allow NULL?
90	N3DV2ZUU03	Zusatzuntersuchung durch wenn	nvarchar	100	CHAR	(N' ')	Yes		N3DV2ZUU03	Allow NULL?
91	N3DV2TOS01	Todestag	nvarchar	8	DATS	(N'00000000')	Yes		N3DV2TOS01	Allow NULL?
92	N3DV2TOS02	Todeszeitpunkt	nvarchar	6	TIMS	(N'000000')	Yes		N3DV2TOS02	Allow NULL?
93	N3DV2TOS03	PMD: Referenz by GUUID	nvarchar	32	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
94	N3DV2TOS04	Tod nach	char	1	CHAR	(N' ')	Yes		N3DV2TOS04	Allow NULL?
95	N3DV3VIN12	Personalunfall Ja/Nein	char	1	CHAR	(N' ')	Yes		N3DV3VIN12	Allow NULL?
96	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

96 COLUMNS | 1 INDEXES | ERP 6.0 | N3DV2STE TABLE

TOP ERP 6.0 | N3DV2STE COLUMNS

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

96 COLUMNS | 1 INDEXES | ERP 6.0 | N3DV2STE TABLE

TOPERP 6.0 | N3DV2STE COLUMNS

TOPERP 6.0 | N3DV2STE INDEXES

TOP ERP 6.0 | N3DV2STE COLUMNS

TOP ERP 6.0 | N3DV2STE INDEXES