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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N1MEORDER	106	8	IS-H*MED: Medication, Medication Order	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	MEORDID	Medication: Order - Order Number	nvarchar	10	0	NUMC	(N'0000000000')	No		N1ME_MEORDID	Allow NULL?
3	EINRI	Institution	nvarchar	4	0	CHAR	(N' ')	Yes	TN01	EINRI	Allow NULL?
4	PATNR	IS-H: Patient Number	nvarchar	10	0	CHAR	(N' ')	Yes	NPAT	PATNR	Allow NULL?
5	FALNR	IS-H: Case Number	nvarchar	10	0	CHAR	(N' ')	Yes	NFAL	FALNR	Allow NULL?
6	MOTX	Medication: Description of Order	nvarchar	60	0	CHAR	(N' ')	Yes		N1ME_MOTX	Allow NULL?
7	MOSTX	Medication: Order - Comment	nvarchar	80	0	CHAR	(N' ')	Yes		N1ME_MOSTX	Allow NULL?
8	MOLTX	Indicator that Long Text Exists	char	1	0	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
9	ORGFA	Medication: Ordering Departmental Org. Unit	nvarchar	8	0	CHAR	(N' ')	Yes	NORG	N1ME_ORGFA	Allow NULL?
10	ORGPF	Medication: Order - Ordering Organizational Unit	nvarchar	8	0	CHAR	(N' ')	Yes	NORG	N1ME_ORGPF	Allow NULL?
11	MOTYPID	Medication: Type of Order	nvarchar	2	0	NUMC	(N'00')	Yes	TN1OTYPE	N1ME_MOTYP	Allow NULL?
12	MOSID	Medication: Status ID for Status of Medication Order	nvarchar	3	0	NUMC	(N'000')	Yes	TN1OSTATUS	N1ME_MOSID	Allow NULL?
13	APDEV	Medication: Administration Device ID	nvarchar	3	0	CHAR	(N' ')	Yes	TN1DEVICE	N1ME_APDEVID	Allow NULL?
14	PHFORM	Medication: ID Dosage Form	nvarchar	3	0	CHAR	(N' ')	Yes	TN1PHFORM	N1ME_PHFORMID	Allow NULL?
15	APROU	Medication: ID Administration Route	nvarchar	3	0	CHAR	(N' ')	Yes	TN1ROUTE	N1ME_ROUTEID	Allow NULL?
16	MOVDF	Medication: Order - Valid From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		N1ME_MOVDF	Allow NULL?
17	MOVTF	Medication: Valid From Time	nvarchar	6	0	TIMS	(N'000000')	Yes		N1ME_MOVTF	Allow NULL?
18	MOVDT	Medication: Order - Valid To Date	nvarchar	8	0	DATS	(N'00000000')	Yes		N1ME_MOVDT	Allow NULL?
19	MOVTT	Medication: Order - Valid To Time	nvarchar	6	0	TIMS	(N'000000')	Yes		N1ME_MOVTT	Allow NULL?
20	ORDUR	Medication: Order - Order Duration	decimal	12	3	QUAN	((0))	Yes		N1ME_ORDUR
21	ORDURU	Medication: Order Duration Unit	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_ORDURU	Allow NULL?
22	EXTD	Medication: Change in MO Validity	char	1	0	CHAR	(N' ')	Yes		N1ME_EXTEND	Allow NULL?
23	MEDGRPID	Medication: Drug Category Key	nvarchar	3	0	CHAR	(N' ')	Yes		N1ME_MEDGRPID	Allow NULL?
24	MOSUBTY	Medication: Order - Subscreen Type	nvarchar	2	0	NUMC	(N'00')	Yes		N1ME_MOSUBTY	Allow NULL?
25	MORESP1	Medication: Order - Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	NGPA	N1ME_MORESP1	Allow NULL?
26	MORESP2	Medication: Order - Consulting EmR - OBSOLETE	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1ME_MORESP2	Allow NULL?
27	MOCONSOU	Medication: Order - Consulting OU - OBSOLETE	nvarchar	8	0	CHAR	(N' ')	Yes	*	N1ME_MOCONSOU	Allow NULL?
28	INSTX	Medication: Order - Preparation Directions	nvarchar	80	0	CHAR	(N' ')	Yes		N1ME_INSTX	Allow NULL?
29	INLTX	Indicator that Long Text Exists	char	1	0	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
30	ABSG	Termination Reason	nvarchar	10	0	CHAR	(N' ')	Yes		N1ABSG	Allow NULL?
31	MOPRINT	Medication: Order - Internal Priority	nvarchar	3	0	NUMC	(N'000')	Yes	N1MEOPRI	N1ME_MOPRINT	Allow NULL?
32	MEOEXT	Medication: Order - External Medication	char	1	0	CHAR	(N' ')	Yes		N1ME_MEOEXT	Allow NULL?
33	MEOEXTCC	Medication: Relevant for Clinical Checking	char	1	0	CHAR	(N' ')	Yes		N1ME_MEOEXTCC	Allow NULL?
34	EXT_DRUGID	Medication: External Drug ID	nvarchar	32	0	CHAR	(N' ')	Yes	N1BDCC	N1ME_EXT_DRUGID	Allow NULL?
35	MPRESNR	Medication - Order Profile ID	nvarchar	10	0	NUMC	(N'0000000000')	Yes		N1ME_MPRESNR	Allow NULL?
36	MEPSNR	Medication: Sequence Number Order Profile	nvarchar	3	0	NUMC	(N'000')	Yes		N1ME_MEPSNR	Allow NULL?
37	MEPSSTX	Medication: Sequence Text Order Profile	nvarchar	80	0	CHAR	(N' ')	Yes		N1ME_MEPSEQ	Allow NULL?
38	MEPSLTX	Indicator that Long Text Exists	char	1	0	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
39	ORIGIN	Medication: Order - Original Order ID - OBSOLETE	nvarchar	10	0	NUMC	(N'0000000000')	Yes		N1ME_ORIGIN	Allow NULL?
40	MOPRN	Medication: Order - PRN Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_PRN	Allow NULL?
41	PRNCSTX	Medication: Order - Check Condition	nvarchar	80	0	CHAR	(N' ')	Yes		N1ME_PRNCOND	Allow NULL?
42	PRNCLTX	Indicator that Long Text Exists	char	1	0	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
43	OLDIS	Medication: Order - Take Home Medication - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_OLDIS	Allow NULL?
44	SLDOSE	Medication: Orders - Sliding Dose	char	1	0	CHAR	(N' ')	Yes		N1ME_SLDOSE	Allow NULL?
45	IVTYPE	Medication: Order - Infusion Type	char	1	0	CHAR	(N' ')	Yes		N1ME_IVTYPE	Allow NULL?
46	RECUP	Medication: Order - Flag: Recipe Updated - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_RECUP	Allow NULL?
47	STRGTHDOS	Medication: Order - Dosage Type	char	1	0	CHAR	(N' ')	Yes		N1ME_STRGTHDOS	Allow NULL?
48	SELTYP	Medication: Order - Selection Type - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_SELTYP	Allow NULL?
49	PATWGT	Medication: Order - Patient Weight	decimal	12	3	QUAN	((0))	Yes		N1ME_PATWGT
50	PATWGTU	Medication: Order - Patient Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_PATWGTU	Allow NULL?
51	PATHGT	Medication: Order - Patient Height	decimal	12	3	QUAN	((0))	Yes		N1ME_PATHGT
52	PATHGTU	Medication: Order - Patient Height Unit	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_PATHGTU	Allow NULL?
53	CALCUD	Medication: Order - Calculation Factor	char	1	0	CHAR	(N' ')	Yes		N1ME_CALCUD	Allow NULL?
54	PCALOCK	Medication: PCA Lock Duration	decimal	12	3	QUAN	((0))	Yes		N1ME_PCALOCK
55	PCALOCKU	Medication: Order - PCA Lock Duration Unit	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_PCALOCU	Allow NULL?
56	PCAMAX	Medication: PCA Number of Boli	tinyint	3	0	INT1	((0))	Yes		N1ME_PCAMAX
57	PCAPER	Medication: Time Number of Boli	decimal	12	3	QUAN	((0))	Yes		N1ME_PCAPER
58	PCAPERU	Medication: Time Unit Number of Boli	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_PCAPERU	Allow NULL?
59	COMPDOS	Medication: Dose Type for Compound	char	1	0	CHAR	(N' ')	Yes		N1ME_COMPDOS	Allow NULL?
60	AL	Medication: Localization ID	nvarchar	4	0	NUMC	(N'0000')	Yes		N1ME_LOCID	Allow NULL?
61	CHDVER	Medication: Order - Change Attribute Check	char	1	0	CHAR	(N' ')	Yes		N1ME_CHDVER	Allow NULL?
62	RCUSE	Medication: Order - Reason for Usage	nvarchar	5	0	CHAR	(N' ')	Yes		N1ME_RCUSE	Allow NULL?
63	DC_USED	Medication: Order - Dose Calculator Used	char	1	0	CHAR	(N' ')	Yes		N1ME_DC_USED	Allow NULL?
64	VFCOIND	Medication: Check Condition to Be Checked	char	1	0	CHAR	(N' ')	Yes		N1ME_CHKCO	Allow NULL?
65	ADOUTPAT	Medication: Administration in IP/OC - OBSOLETE	char	1	0	CHAR	(N' ')	Yes		N1ME_ADOUTPAT	Allow NULL?
66	OUPREP	Medication: Preparation Fill Source Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_OUPREP	Allow NULL?
67	FIXQUAN	Medication: Order Ind. for Fixed Recipe Qty for Compounds	char	1	0	CHAR	(N' ')	Yes		N1ME_FIXQUAN	Allow NULL?
68	MEFALAR	IS-H: Case Type	char	1	0	CHAR	(N' ')	No		FALLART	Allow NULL?
69	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	0	CHAR	(N' ')	Yes		RI_ERNAM	Allow NULL?
70	ERDAT	IS-H: Date when Record Created	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_ERDAT	Allow NULL?
71	ERTIM	IS-H: Time Record Created	nvarchar	6	0	TIMS	(N'000000')	Yes		RI_ERTIM	Allow NULL?
72	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	0	CHAR	(N' ')	Yes		RI_UPNAM	Allow NULL?
73	UPDAT	IS-H: Date of Last Change	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_UPDAT	Allow NULL?
74	UPTIM	IS-H: Time of Last Change	nvarchar	6	0	TIMS	(N'000000')	Yes		RI_UPTIM	Allow NULL?
75	STORN	IS-H: Cancellation Indicator	char	1	0	CHAR	(N' ')	Yes		RI_STORN	Allow NULL?
76	STUSR	IS-H: Name of User who Canceled Data Record	nvarchar	12	0	CHAR	(N' ')	Yes		STORN_USER	Allow NULL?
77	STDAT	Date of Cancellation	nvarchar	8	0	DATS	(N'00000000')	Yes		STORN_DAT	Allow NULL?
78	STOID	Reason for Canceling Medical Object	nvarchar	3	0	CHAR	(N' ')	Yes	*	N1STOID	Allow NULL?
79	NMRF	Medication: Number of Repeats	nvarchar	4	0	NUMC	(N'0000')	No		N1ME_NMRF	Allow NULL?
80	INPAT_ALLOWED	Medication: Inpatient Case Type Allowed - OBSOLETE	char	1	0	CHAR	(N' ')	No		N1ME_INPAT_ALLOWED	Allow NULL?
81	DAYPAT_ALLOWED	Medication: Day Patient Case Type Allowed - OBSOLETE	char	1	0	CHAR	(N' ')	No		N1ME_DAYPAT_ALLOWED	Allow NULL?
82	OUTPAT_ALLOWED	Medication: Outpatient Case Type Allowed - OBSOLETE	char	1	0	CHAR	(N' ')	No		N1ME_OUTPAT_ALLOWED	Allow NULL?
83	IMDOSE	Medication: Order - Immediate Dose	char	1	0	CHAR	(N' ')	No		N1ME_IMDOSE	Allow NULL?
84	PURPOSE	Medication: Purpose of Order	char	1	0	CHAR	(N' ')	No		N1ME_ORD_PURPOSE	Allow NULL?
85	DISPQUAN	Medication: Drug Dispensing Quantity	decimal	24	12	QUAN	((0))	No		N1ME_DISPQUAN
86	DISPQUANU	Medication: Dispensing Quantity Unit	nvarchar	3	0	UNIT	(N' ')	No		N1ME_DISPQUANU	Allow NULL?
87	TPID	Medication: ID Order Template	nvarchar	10	0	CHAR	(N' ')	Yes		N1ME_TPID	Allow NULL?
88	DURMETH	Medication: Determination Type of Order Validity	char	1	0	CHAR	(N' ')	Yes		N1ME_DURMETH	Allow NULL?
89	VALTIME	Medication: Validation Time	decimal	15	0	DEC	((0))	Yes		N1ME_VALTIME
90	VALVMA	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
91	ENDORIGIN	Medication: Reason ID	nvarchar	5	0	CHAR	(N' ')	Yes		N1ME_RCODEID	Allow NULL?
92	ORMOVDT	Medication: End Date Before Order Sequence	nvarchar	8	0	DATS	(N'00000000')	Yes		N1ME_ORMOVDT	Allow NULL?
93	ORMOVTT	Medication: End Time Before Order Sequence	nvarchar	6	0	TIMS	(N'000000')	Yes		N1ME_ORMOVTT	Allow NULL?
94	PDUR	Medication: Planned Duration	decimal	12	3	QUAN	((0))	Yes		N1ME_PLDUR
95	PDURU	Medication: Administration Duration Unit	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_DURU	Allow NULL?
96	DOSDEF	Medication: Simplified Dose Definition	nvarchar	400	0	CHAR	(N' ')	Yes		N1ME_DOSDEF	Allow NULL?
97	DCM	Medication: Dose Calculation Method	char	1	0	CHAR	(N' ')	Yes		N1ME_DCM	Allow NULL?
98	DELAY	Medication: Delayed Order Start	nvarchar	8	0	NUMC	(N'00000000')	Yes		N1ME_DELAY	Allow NULL?
99	DELAYU	Medication: Unit of Delayed Order Start	nvarchar	3	0	UNIT	(N' ')	Yes		N1ME_DELAYU	Allow NULL?
100	FIXEDDELAY	Medication: Fix Delayed Order Start	char	1	0	CHAR	(N' ')	Yes		N1ME_FIXEDDELAY	Allow NULL?
101	SPECREQ	Medication: Special Request Indicator	char	1	0	CHAR	(N' ')	Yes		N1ME_SPECREQ	Allow NULL?
102	AUTIDEM	Indicator for Allowed Drug Substitution	char	1	0	CHAR	(N' ')	Yes		N1ME_ORD_AUTIDEM	Allow NULL?
103	EMORD	Medication - Emergency Order	char	1	0	CHAR	(N' ')	Yes		N1ME_EMORD	Allow NULL?
104	COUNTDAY	Medication - Treatment Start Day	nvarchar	3	0	NUMC	(N'000')	Yes		N1ME_COUNTDAY	Allow NULL?
105	PDUR_MODE	Medication: Calculation Method Duration/Flow Rate	char	1	0	CHAR	(N' ')	Yes		N1ME_PDUR_MODE	Allow NULL?
106	THERAPY_REC	Medication: Indicator for Therapy Recommendations	char	1	0	CHAR	(N' ')	Yes		N1ME_THERAPY_RECOMMENDATION	Allow NULL?

Name	Primary	Unique	Type	Columns
N1MEORDER~0	Yes	Yes	CLUSTERED	MEORDID, MANDT
N1MEORDER~001	No	No	NONCLUSTERED	FALNR, EINRI, MANDT
N1MEORDER~002	No	No	NONCLUSTERED	PATNR, MANDT
N1MEORDER~003	No	No	NONCLUSTERED	MOVDF, EINRI, MANDT
N1MEORDER~004	No	No	NONCLUSTERED	MOVDT, EINRI, MANDT
N1MEORDER~005	No	No	NONCLUSTERED	MPRESNR, EINRI, MANDT
N1MEORDER~008	No	No	NONCLUSTERED	ERUSR, EINRI, MANDT
N1MEORDER~009	No	No	NONCLUSTERED	ERDAT, EINRI, 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

106 COLUMNS | 8 INDEXES | ERP 6.0 | N1MEORDER TABLE

TOP ERP 6.0 | N1MEORDER COLUMNS

TOP ERP 6.0 | N1MEORDER 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 | 8 INDEXES | ERP 6.0 | N1MEORDER TABLE

TOPERP 6.0 | N1MEORDER COLUMNS

TOPERP 6.0 | N1MEORDER INDEXES

TOP ERP 6.0 | N1MEORDER COLUMNS

TOP ERP 6.0 | N1MEORDER INDEXES