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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N1FORMULARY	113	8	Medication: Drug Formulary	Clinical System

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	DRUGID	Medication: Mnemonic	nvarchar	32	0	CHAR	(N' ')	No		N1ME_DRUGID	Allow NULL?
3	BEGDT	IS-H: Valid-From Date of Record	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_BEGDT	Allow NULL?
4	ENDDT	IS-H: Valid-To Date of Record	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_ENDDT	Allow NULL?
5	CATID	Medication: Internal Key of Drug Catalog	nvarchar	3	0	CHAR	(N' ')	Yes	N1DC	N1ME_CATID	Allow NULL?
6	RCDEACT	Medication: Reason Code - OBSOLETE	nvarchar	5	0	CHAR	(N' ')	Yes	TN1RCODE	N1ME_RCODEID_O	Allow NULL?
7	DEACT_RC	Medication: Deactivation Reason Code	nvarchar	5	0	CHAR	(N' ')	No	TN1RCIND	N1ME_RCDEACTV	Allow NULL?
8	MANUAL	Medication: Manually Added Data Record Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_MANUAL	Allow NULL?
9	NOTE1	Medication: Indicator Note for Pharmacist Exists - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_NOTE1_O	Allow NULL?
10	NOTE2	Medication: Indicator Note for Nurse Exists - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_NOTE2_O	Allow NULL?
11	NOTE3	Medication: Indicator Note for Physician Exists - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_NOTE3_O	Allow NULL?
12	PREP	Medication:Manufacture Directions Exist Indicator - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_PREP_O	Allow NULL?
13	AUTIDEM	Drug Substitution Allowed Indicator - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_AUTIDEM	Allow NULL?
14	BDCUPD	Medication: Indicator for Synchronize with External Catalog	char	1	0	CHAR	(N' ')	Yes		N1ME_BDCUPD	Allow NULL?
15	CATIDBDC	Medication: ID of External Drug Catalog - OBSOLETE	nvarchar	3	0	CHAR	(N' ')	Yes	N1DC	N1ME_CATIDBDC_O	Allow NULL?
16	DRUGIDBDC	Medication: Mnemonic in Basic Catalog - OBSOLETE	nvarchar	32	0	CHAR	(N' ')	Yes	N1BDCC	N1ME_DRUGIDBDC_O	Allow NULL?
17	TRMDAYS	Medication: Preset Treatment Period (Days) - OBSOLETE	tinyint	3	0	INT1	((0))	Yes		N1ME_TRMDAYS
18	TRMSTOP	Medication: Indicator Stop After Treatment Period - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_TRMSTOP	Allow NULL?
19	PREVENT	Medication: Predefined Events in Days	tinyint	3	0	INT1	((0))	Yes		N1ME_PREVENT
20	MEDCLID	Medication: Drug Category ID - OBSOLETE	nvarchar	3	0	CHAR	(N' ')	Yes		N1ME_MEDCLID	Allow NULL?
21	MEDGRPID	Medication: Drug Category Key	nvarchar	3	0	CHAR	(N' ')	Yes	TN1MEDGROUP	N1ME_MEDGRPID	Allow NULL?
22	ADRTIMU	Medication: Unit of Administration Duration	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_ADRTIMU	Allow NULL?
23	ADITIM	Medication: Administration Duration	decimal	12	3	QUAN	((0))	Yes		N1ME_ADITIM
24	RECQUAN	Medication: Recipe Quantity - OBSOLETE	decimal	12	3	QUAN	((0))	Yes		N1ME_RECQUAN_O
25	RECQUANU	Medication: Recipe Quantity Unit - OBSOLETE	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_RECQUANU_O	Allow NULL?
26	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
27	MMRESERV	Medication: Create MM Reservation for Drug	char	1	0	CHAR	(N' ')	Yes		N1ME_MMRESERV	Allow NULL?
28	INDISDOS	Medication: Indiscrete Dose Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_DISCDOS	Allow NULL?
29	DISPPKG	Medication: Deliver in Package Size Indicator (Pharmacy)	char	1	0	CHAR	(N' ')	Yes		N1ME_DISPPKG	Allow NULL?
30	ADMPKG	Medicat.: Post Package Unit at Administration Ind.(Patient)	char	1	0	CHAR	(N' ')	Yes		N1ME_ADMPKG	Allow NULL?
31	VERSDATE	Medication: Date and Time of Version	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		N1ME_VERSDATE	Allow NULL?
32	EXTDCODECAT	Medication: ID of Identification System - OBSOLETE	nvarchar	3	0	CHAR	(N' ')	Yes		N1ME_EXTDCODECAT	Allow NULL?
33	EXTDCODEID	Medication: External Drug ID	nvarchar	40	0	CHAR	(N' ')	Yes		N1ME_EXTDCODEID	Allow NULL?
34	BRANDNAME	Medication: Brand Name	nvarchar	120	0	CHAR	(N' ')	Yes		N1ME_BRANDNAME	Allow NULL?
35	GENNAME	Medication: Generic Name	nvarchar	200	0	CHAR	(N' ')	Yes		N1ME_GENNAME	Allow NULL?
36	NARCOTIC	Medication: Narcotic Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_NARCOTIC	Allow NULL?
37	PSYCHO	Medication: Psychotropic Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_PSYCHO	Allow NULL?
38	CONTR	Medication: Controlled Drug Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_CONTR	Allow NULL?
39	ADMIND	Medication: Administrable Independently	char	1	0	CHAR	(N' ')	Yes		N1ME_ADMIND	Allow NULL?
40	MONO	Medication: Single Agent Drug Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_MONO	Allow NULL?
41	MANUF	Medication: Manufacturer	nvarchar	120	0	CHAR	(N' ')	Yes		N1ME_MANUF	Allow NULL?
42	APDEVID	Medication: Administration Device ID	nvarchar	3	0	CHAR	(N' ')	Yes	TN1DEVICE	N1ME_APDEVID	Allow NULL?
43	APROUTEID	Medication: ID Administration Route	nvarchar	3	0	CHAR	(N' ')	Yes	TN1ROUTE	N1ME_ROUTEID	Allow NULL?
44	PHFORMID	Medication: ID Dosage Form	nvarchar	3	0	CHAR	(N' ')	Yes	TN1PHFORM	N1ME_PHFORMID	Allow NULL?
45	UNIT	Medication: Drug - Base Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_UNIT	Allow NULL?
46	QUAN	Medication: Drug - Base Quantity	decimal	12	3	QUAN	((0))	Yes		N1ME_QUAN
47	STRGTHU	Medication: Strength Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_STRGTHU	Allow NULL?
48	STRGTH	Medciation: Drug Strength	decimal	12	3	QUAN	((0))	Yes		N1ME_STRGTH
49	STRGTHPU	Medication: Reference Dose Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_STRGTHPU	Allow NULL?
50	STRGTHP	Medication: Reference Dose	decimal	12	3	QUAN	((0))	Yes		N1ME_STRGTHP
51	PSTRGTH	Medication: Percentage Strength Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_PSTRGTHP	Allow NULL?
52	PKGUNIT	Medication: Package Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_PKGUNIT	Allow NULL?
53	PKGSIZE	Medication: Package Size	decimal	12	3	QUAN	((0))	Yes		N1ME_PKGSIZE
54	DEFDOSM	Medication: Standard Individual Dose	decimal	12	3	QUAN	((0))	Yes		N1ME_DEFDOSM
55	DEFEXP	Medication: Shelf Life	decimal	12	3	QUAN	((0))	Yes		N1ME_DEFEXP
56	DEFEXPTU	Medication: Default Expiry Period Time Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_DEFEXPTU	Allow NULL?
57	MAXDOSM	Medication: Maximum Individual Dose	decimal	12	3	QUAN	((0))	Yes		N1ME_MAXDOSM
58	MAXDOSD	Medication: Maximum Daily Dose	decimal	12	3	QUAN	((0))	Yes		N1ME_MAXDOSD
59	MAXDOSL	Medication: Maximum Lifetime Dose	decimal	12	3	QUAN	((0))	Yes		N1ME_MAXDOSL
60	CUMDOS	Medication: Cumulative Dose Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_CUMDOS	Allow NULL?
61	FREEZE	Medication: Freezing Required Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_FREEZE	Allow NULL?
62	REFRIGERATE	Medication: Refrigeration Necessary Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_REFRIGERATE	Allow NULL?
63	MAXTEMP	Medication: Maximum Storage Temperature	decimal	3	0	QUAN	((0))	Yes		N1ME_MAXTEMP
64	MAXTEMP_VAL0	Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0)	char	1	0	CHAR	(N' ')	Yes		N1ME_VALUE_0	Allow NULL?
65	MINTEMP	Medication: Minimum Storage Temperature	decimal	3	0	QUAN	((0))	Yes		N1ME_MINTEMP
66	MINTEMP_VAL0	Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0)	char	1	0	CHAR	(N' ')	Yes		N1ME_VALUE_0	Allow NULL?
67	TEMPU	Medication: Temperature Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	N1ME_TEMPU	Allow NULL?
68	MAXDEN	Medciation: Maximum Denominator for Tablets	char	1	0	NUMC	(N'0')	Yes		N1ME_MAXDEN	Allow NULL?
69	TIMSEN	Medication: Time-Sensitive Drug	char	1	0	CHAR	(N' ')	Yes		N1ME_TIMSEN	Allow NULL?
70	ADOUTPAT	Medication: Administration in IP/OC - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_ADOUTPAT	Allow NULL?
71	SECWITNESS	Medication: Witness Required	char	1	0	CHAR	(N' ')	Yes		N1ME_SECWITNESS	Allow NULL?
72	VFCOIND	Medication: Check Condition to Be Checked	char	1	0	CHAR	(N' ')	Yes		N1ME_CHKCO	Allow NULL?
73	OUPREP	Medication: Preparation Fill Source Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_OUPREP	Allow NULL?
74	NOCRUSH	Medication: Drug Uncrushable Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_NOCRUSH	Allow NULL?
75	OWNMED	Medication: Indicator for Patient's Own Medicine	char	1	0	CHAR	(N' ')	Yes		N1ME_OWNMED	Allow NULL?
76	INPATIENT	Medication: Indicator, Administration - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_IP_USE	Allow NULL?
77	OUTPATIENT	Medication: Indicator, Dispensing/Prescription - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_OP_USE	Allow NULL?
78	PRICE	Medication: Price of the Medication - OBSOLETE	decimal	11	2	CURR	((0))	Yes		N2ME_DRUGPRICE_OBS
79	PRICEU	Medication: Price Unit	nvarchar	5	0	CUKY	(N' ')	Yes		N2ME_DRUGPRICEU	Allow NULL?
80	FORMLVL	Medication: Internal Key of Drug Level	char	1	0	NUMC	(N'0')	Yes	TN1FORMLEVEL	N1ME_MD_FORMLVL	Allow NULL?
81	IVTYPE	Medication: Order - Infusion Type	char	1	0	CHAR	(N' ')	Yes		N1ME_IVTYPE	Allow NULL?
82	CHIVTYPE	Medication: Changeable Infusion Type	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_CHIVTYPE	Allow NULL?
83	STRGTHDOS	Medication: Order - Dosage Type	char	1	0	CHAR	(N' ')	Yes		N1ME_STRGTHDOS	Allow NULL?
84	ALTQUAN	Medication: Alternative Reference Dose	decimal	12	3	QUAN	((0))	Yes		N1ME_MD_ALTQUAN
85	ALTQUANU	Medication: Alternative Reference Dose Unit	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_MD_ALTQUANU	Allow NULL?
86	EXTBEGDT	Medication: Start of Valid. Period in Ext. Catlog	nvarchar	8	0	DATS	(N'00000000')	Yes		N1ME_MD_EXTBEGDT	Allow NULL?
87	EXTENDDT	Medication: End of Validity Period in Ext. Catalog	nvarchar	8	0	DATS	(N'00000000')	Yes		N1ME_MD_EXTENDDT	Allow NULL?
88	PKGMULT	Medication: Number of Individual Packages	nvarchar	4	0	NUMC	(N'0000')	Yes		N1ME_MD_PKGMULT	Allow NULL?
89	INTERPOL	Medication: Manual Check Necessary	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_INTERPOL	Allow NULL?
90	UNDIVUNITIND	Medication: Indicator for Undivisible Dose Supply	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_UNDIVUNITIND	Allow NULL?
91	EMAR	Medication: "Administration" Purpose	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_EMAR	Allow NULL?
92	DISP	Medication: "Dispensing" Purpose	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_DISP	Allow NULL?
93	PPRINT	Medication: "Print Prescription" Purpose	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_PPRINT	Allow NULL?
94	DEFEMAR	Medication: Default for Administration	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_DEFEMAR	Allow NULL?
95	DEFDISP	Medication: Default Dispensing	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_DEFDISP	Allow NULL?
96	DEFPPRINT	Medication: Default Purpose Prescription Printout	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_DEFPPRINT	Allow NULL?
97	IMPORTER	Medication: Importer	nvarchar	120	0	CHAR	(N' ')	Yes		N1ME_MD_IMPORTER	Allow NULL?
98	LEVEL1	Medication: Mnemonic	nvarchar	32	0	CHAR	(N' ')	Yes		N1ME_DRUGID	Allow NULL?
99	LEVEL2	Medication: Mnemonic	nvarchar	32	0	CHAR	(N' ')	Yes		N1ME_DRUGID	Allow NULL?
100	ASSIGNIND	Medication: Indicator "Assigned"	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_ASSIGNIND	Allow NULL?
101	EXTKEY	Medication: Key in External Catalog	nvarchar	40	0	CHAR	(N' ')	Yes		N1ME_MD_EXTKEY	Allow NULL?
102	EXTCATID	Medication: ID of External Drug Catalog	nvarchar	3	0	CHAR	(N' ')	Yes	N1DC	N1ME_CATIDBDC	Allow NULL?
103	COUNTDAY	Medication, "Display Treatment Days" Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_COUNTDAY	Allow NULL?
104	COUNTMAX	Medication: Number of Days for Treatment Day Display	nvarchar	3	0	NUMC	(N'000')	Yes		N1ME_MD_COUNTMAX	Allow NULL?
105	MARKET	Medication: Marketability	char	1	0	CHAR	(N' ')	Yes		N1ME_MD_MARKET	Allow NULL?
106	ERDAT	IS-H: Date when Record Created	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_ERDAT	Allow NULL?
107	ERTIM	IS-H: Time Record Created	nvarchar	6	0	TIMS	(N'000000')	Yes		RI_ERTIM	Allow NULL?
108	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	0	CHAR	(N' ')	Yes		RI_ERNAM	Allow NULL?
109	UPDAT	IS-H: Date of Last Change	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_UPDAT	Allow NULL?
110	UPTIM	IS-H: Time of Last Change	nvarchar	6	0	TIMS	(N'000000')	Yes		RI_UPTIM	Allow NULL?
111	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	0	CHAR	(N' ')	Yes		RI_UPNAM	Allow NULL?
112	TIME_BEFORE	Medication: Time Difference Before	nvarchar	5	0	NUMC	(N'00000')	Yes		N1ME_TIME_BEFORE	Allow NULL?
113	TIME_AFTER	Medication: Time Difference After	nvarchar	5	0	NUMC	(N'00000')	Yes		N1ME_TIME_AFTER	Allow NULL?

Name	Primary	Unique	Type	Columns
N1FORMULARY~0	Yes	Yes	CLUSTERED	DRUGID, MANDT
N1FORMULARY~001	No	No	NONCLUSTERED	MEDGRPID, MANDT
N1FORMULARY~002	No	No	NONCLUSTERED	GENNAME, MANDT
N1FORMULARY~003	No	No	NONCLUSTERED	BRANDNAME, MANDT
N1FORMULARY~005	No	No	NONCLUSTERED	LEVEL1, MANDT
N1FORMULARY~006	No	No	NONCLUSTERED	LEVEL2, MANDT
N1FORMULARY~007	No	No	NONCLUSTERED	EXTKEY, EXTCATID, MANDT
N1FORMULARY~008	No	No	NONCLUSTERED	MATNR, MANDT

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

113 COLUMNS | 8 INDEXES | ERP 6.0 | N1FORMULARY TABLE

TOP ERP 6.0 | N1FORMULARY COLUMNS

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

113 COLUMNS | 8 INDEXES | ERP 6.0 | N1FORMULARY TABLE

TOPERP 6.0 | N1FORMULARY COLUMNS

TOPERP 6.0 | N1FORMULARY INDEXES

TOP ERP 6.0 | N1FORMULARY COLUMNS

TOP ERP 6.0 | N1FORMULARY INDEXES