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	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	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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Healthcare - Industry-Specific Components for Hospitals :: Patient Management
1	ERP EHP7	6.0	N2DT	117	1	IS-H*MED: Table of Documentation Categories	Patient Management

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	EINRI	Institution	nvarchar	4	Allow NULL?
3	DTID	Document Category ID	nvarchar	10	Allow NULL?
4	DTVERS	Version Number	nvarchar	3	Allow NULL?
5	DTUUID	PMD: UUID	nvarchar	32	Allow NULL?
6	DTART	Document Category Type	char	1	Allow NULL?
7	STATUS	Status for Document Categories	char	1	Allow NULL?
8	DOKART	Document Type	nvarchar	3	Allow NULL?
9	DAPPL	Work Station Application	nvarchar	3	Allow NULL?
10	APPLPAR	Application Parameters	nvarchar	30	Allow NULL?
11	ETLFDNR	Sequential Assignment Number	nvarchar	4	Allow NULL?
12	DEID	Ident. of Documentation Element	nvarchar	10	Allow NULL?
13	DTUMS	Type of Document Conversion	nvarchar	2	Allow NULL?
14	NOABSENTW	Document Category Without Abstract Design	char	1	Allow NULL?
15	STABLNR	Number of Secondary Tables Created for Doc. Categ.	nvarchar	2	Allow NULL?
16	TMPDLG	Name of Template of Dialog Program	nvarchar	40	Allow NULL?
17	TMPREP	Name of Template of Print Program	nvarchar	40	Allow NULL?
18	PRGDLG	PMD: Name of Generated Function Group	nvarchar	40	Allow NULL?
19	ANWDIA	PMD: Name of Generated Function Group	nvarchar	40	Allow NULL?
20	PRGREP	Name of Print Program	nvarchar	40	Allow NULL?
21	PRGEOP	Form Routine 'Print Output'	nvarchar	30	Allow NULL?
22	MODEOP	Include 'Print Output'	nvarchar	40	Allow NULL?
23	FKTEOS	'Print End' Form Routine	nvarchar	30	Allow NULL?
24	MODEOS	Include 'Print End'	nvarchar	40	Allow NULL?
25	FKTPBO	'PBO' Form Routine	nvarchar	30	Allow NULL?
26	MODPBO	Include 'PBO'	nvarchar	40	Allow NULL?
27	FKTPAI	'PAI' Form Routine	nvarchar	30	Allow NULL?
28	MODPAI	Include 'PAI'	nvarchar	40	Allow NULL?
29	FKTTOR	'Print Start' Form Routine	nvarchar	30	Allow NULL?
30	MODTOR	Include 'Print Start'	nvarchar	40	Allow NULL?
31	MODTOP	Include Modules -Page Start-	nvarchar	40	Allow NULL?
32	PRGTOP	Name of Module for -Top of Page-	nvarchar	30	Allow NULL?
33	FKTDA	'Create Document' Form Routine	nvarchar	30	Allow NULL?
34	MODDA	Include 'Create Document'	nvarchar	40	Allow NULL?
35	FKTDE	'Document Start' Form Routine	nvarchar	30	Allow NULL?
36	MODDE	Include 'Document Start'	nvarchar	40	Allow NULL?
37	FKTDP	'Check Document' Form Routine	nvarchar	30	Allow NULL?
38	MODDP	Include 'Check Document'	nvarchar	40	Allow NULL?
39	FKTSAV	'Save Document' Form Routine	nvarchar	30	Allow NULL?
40	MODSAV	Include 'Save Document'	nvarchar	40	Allow NULL?
41	FKTDENDE	'Document End' FORM Routine	nvarchar	30	Allow NULL?
42	MODDENDE	Include 'End of Document'	nvarchar	40	Allow NULL?
43	MODTOPI	Top Include for User Exits	nvarchar	40	Allow NULL?
44	DDTAB	Table Name	nvarchar	30	Allow NULL?
45	GSAPDIA	SAP Dialog Integration	char	1	Allow NULL?
46	GSAPDRU	SAP Print Connection	char	1	Allow NULL?
47	GAPP01	PMD: Instantiate Own Global Data	char	1	Allow NULL?
48	GAPP02	EXCEL Link	char	1	Allow NULL?
49	GAPP03	External Application 3 (Control Field for Link)	char	1	Allow NULL?
50	GAPP04	External Applicatn 4 (Control Field for Link)	char	1	Allow NULL?
51	GAPP05	External Application 5 (Control Field for Link)	char	1	Allow NULL?
52	GAPP06	External Application 6 (Control Field for Link)	char	1	Allow NULL?
53	GAPP07	Print PMD: Use Work Organizer Option?	char	1	Allow NULL?
54	REBER	Authorization Object for Reading	nvarchar	10	Allow NULL?
55	UPBER	Authorization Object - Modify Document -	nvarchar	10	Allow NULL?
56	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	Allow NULL?
57	ERDAT	IS-H: Date when Record Created	nvarchar	8	Allow NULL?
58	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	Allow NULL?
59	UPDAT	IS-H: Date of Last Change	nvarchar	8	Allow NULL?
60	UPDTIME	PMD: Time	nvarchar	6	Allow NULL?
61	LOEKZ	Deletion Flag/Indicator	char	1	Allow NULL?
62	LOUSR	User Who Deleted Record	nvarchar	12	Allow NULL?
63	LODAT	Date of Deletion	nvarchar	8	Allow NULL?
64	TMPSCIPROG	Template for SAPscript control program	nvarchar	40	Allow NULL?
65	PRGSCIPROG	SAPscript control program	nvarchar	40	Allow NULL?
66	TMPSCIFORM	Template for SAPscript form	nvarchar	16	Allow NULL?
67	FORSCIFORM	SAPscript form	nvarchar	16	Allow NULL?
68	USRSCIFORM	User-defined SAPscript form	nvarchar	16	Allow NULL?
69	FORTITEL	Name of the title page template for SAPscript representation	nvarchar	8	Allow NULL?
70	FORODDEVEN	Indicator: Document Dispatch Allowed	char	1	Allow NULL?
71	FORPAGNUM	PMD: Display HTML Patient Header	char	1	Allow NULL?
72	BEZEB	Reference Level of a Document	char	1	Allow NULL?
73	BEZEBKZ	Unique Document per Reference Level	char	1	Allow NULL?
74	SCRLINES	Screen Rows	decimal	3
75	SCRCOLUMNS	Screen Columns	decimal	3
76	GDIAUSR	User Name	nvarchar	12	Allow NULL?
77	GDIADAT	Generation Date of the Dialog Application	nvarchar	8	Allow NULL?
78	GDIATIME	PMD: Time	nvarchar	6	Allow NULL?
79	GDRUDAT	Generation Date of Print Application	nvarchar	8	Allow NULL?
80	GDIAREL	IS-H Release Time Generation Dialog Application	nvarchar	30	Allow NULL?
81	GDRUREL	IS-H Release Generation Time of Print Application	nvarchar	30	Allow NULL?
82	TRART	PMD: Type of User Exit Implementation	char	1	Allow NULL?
83	GNRTREL	Generator Release Number of Parameterized Doc.	nvarchar	4	Allow NULL?
84	APPINS	Application ID for Document Categories	nvarchar	15	Allow NULL?
85	APPUPD	Application ID for Document Categories	nvarchar	15	Allow NULL?
86	APPDIS	Application ID for Document Categories	nvarchar	15	Allow NULL?
87	APPQVW	Application ID for Document Categories	nvarchar	15	Allow NULL?
88	APPDRU	Application ID for Document Categories	nvarchar	15	Allow NULL?
89	APPDRA	Application ID for Document Categories	nvarchar	15	Allow NULL?
90	GUI_STATUS	GUI status	nvarchar	20	Allow NULL?
91	GUI_MOD	Program for the GUI status	nvarchar	40	Allow NULL?
92	ENTW_KL	Package	nvarchar	30	Allow NULL?
93	GEN_KZ	Generation Indicator	char	1	Allow NULL?
94	GFORDAT	Generation Date of Print Application	nvarchar	8	Allow NULL?
95	GFORREL	IS-H Release Generation Time of Print Application	nvarchar	30	Allow NULL?
96	DYNCOMP	Screen compression yes/no	char	1	Allow NULL?
97	ARCHMODE	Case Archiving Mode for Medical Documents	char	1	Allow NULL?
98	TRANSUSR	User of the Last DocCat-Transport	nvarchar	12	Allow NULL?
99	TRANSDAT	Date of the Last DocCat-Transport	nvarchar	8	Allow NULL?
100	TRANSMANDT	Client ID	nvarchar	3	Allow NULL?
101	TRANSSYST	Name of SAP System	nvarchar	8	Allow NULL?
102	TRANSISHREL	ISH-Release of the Transport	nvarchar	30	Allow NULL?
103	CALC_VERS	PMD: Version of Calculation Routine for Items	nvarchar	3	Allow NULL?
104	BEZEBLIM	Limit the Assignments of a Document	char	1	Allow NULL?
105	MODGSD_DIA	(Gen-1) Include for Standard Dialog User Exits	nvarchar	40	Allow NULL?
106	FKTPBO_PRE	PBO: Customer User Exit before GSD	nvarchar	30	Allow NULL?
107	FKTPBO_GSD	(GSD) User Exit PBO	nvarchar	30	Allow NULL?
108	PBO_DEAKT	Deactivate User Exit	char	1	Allow NULL?
109	PBO_PRE_DEAKT	Deactivate User Exit	char	1	Allow NULL?
110	PBO_GSD_DEAKT	Deactivate User Exit	char	1	Allow NULL?
111	FKTPAI_GSD	(GSD) User Exit PAI	nvarchar	30	Allow NULL?
112	PRINT_NEW	PMD: Generator Version 2	char	1	Allow NULL?
113	FALLREVISION	Case Revision for Medical Documents	char	1	Allow NULL?
114	AUSLIEFERUNG	Delivery Type of Parameterized Documents	char	1	Allow NULL?
115	P1RELEASE	SAP Release	nvarchar	10	Allow NULL?
116	P1PATCHLV	Support Package Level of a Software Component	nvarchar	10	Allow NULL?
117	P1DOCUKEY	i.s.h.med UUID	nvarchar	32	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

117 COLUMNS | 1 INDEXES | ERP 6.0 | N2DT TABLE

TOP ERP 6.0 | N2DT COLUMNS

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

117 COLUMNS | 1 INDEXES | ERP 6.0 | N2DT TABLE

TOPERP 6.0 | N2DT COLUMNS

TOPERP 6.0 | N2DT INDEXES

TOP ERP 6.0 | N2DT COLUMNS

TOP ERP 6.0 | N2DT INDEXES