SAP ABAP Table N1MEORDER (IS-H*MED: Medication, Drug Order)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ NMED_ME (Package) IS-H*MED: Medication

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N1MEORDER	Table Relationship Diagram
Short Description	IS-H*MED: Medication, Drug Order

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MEORDID	☑	N1ME_MEORDID	N1ME_MEORDID	NUMC	10	0	Medication: Order - Order Number
3	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
4	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
5	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
6	MOTX	☐	N1ME_MOTX	N1ME_MOTX	CHAR	60	0	Medication: Description of Order
7	MOSTX	☐	N1ME_MOSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Order - Comment
8	MOLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
9	ORGFA	☐	N1ME_ORGFA	ORGID	CHAR	8	0	Medication: Ordering Departmental Org. Unit	NORG
10	ORGPF	☐	N1ME_ORGPF	ORGID	CHAR	8	0	Medication: Order - Ordering Organizational Unit	NORG
11	MOTYPID	☐	N1ME_MOTYP	N1ME_MOTYP	NUMC	2	0	Medication: Type of Order	TN1OTYPE
12	MOSID	☐	N1ME_MOSID	N1ME_MOSID	NUMC	3	0	Status ID for Status of Drug Order	TN1OSTATUS
13	APDEV	☐	N1ME_APDEVID		CHAR	3	0	Medication: Administration Device ID	TN1DEVICE
14	PHFORM	☐	N1ME_PHFORMID		CHAR	3	0	Medication: ID Dosage Form	TN1PHFORM
15	APROU	☐	N1ME_ROUTEID		CHAR	3	0	Medication: ID Administration Route	TN1ROUTE
16	MOVDF	☐	N1ME_MOVDF	DATS	DATS	8	0	Medication: Order - Valid From Date
17	MOVTF	☐	N1ME_MOVTF	N1ME_MOVTF	TIMS	6	0	Medication: Validity Time From
18	MOVDT	☐	N1ME_MOVDT	DATS	DATS	8	0	Medication: Order - Valid To Date
19	MOVTT	☐	N1ME_MOVTT	N1ME_MOVTT	TIMS	6	0	Medication: Order - Validity Time To
20	ORDUR	☐	N1ME_ORDUR	N1ME_ORDUR	QUAN	12	3	Medication: Order - Order Duration
21	ORDURU	☐	N1ME_ORDURU	N1ME_ORDURU	UNIT	3	0	Medication: Order Duration Unit
22	EXTD	☐	N1ME_EXTEND	XFELD	CHAR	1	0	Medication: Change in MO Validity
23	MEDGRPID	☐	N1ME_MEDGRPID		CHAR	3	0	Medication: Drug Category Key
24	MOSUBTY	☐	N1ME_MOSUBTY	N1ME_MOSUBTY	NUMC	2	0	Medication: Order - Subscreen Type
25	MORESP1	☐	N1ME_MORESP1	RI_KUNNR	CHAR	10	0	Medication: Order - Employee Responsible	NGPA
26	MORESP2	☐	N1ME_MORESP2	RI_KUNNR	CHAR	10	0	Medication: Order - Consulting EmR	*
27	MOCONSOU	☐	N1ME_MOCONSOU	ORGID	CHAR	8	0	Medication: Order - Consulting OU	*
28	INSTX	☐	N1ME_INSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Order - Preparation Directions
29	INLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
30	ABSG	☐	N1ABSG	CHAR10	CHAR	10	0	Termination Reason
31	MOPRINT	☐	N1ME_MOPRINT	N1ME_MOPRINT	NUMC	3	0	Medication: Order - Internal Priority	N1MEOPRI
32	MEOEXT	☐	N1ME_MEOEXT	N1ME_MEOEXT	CHAR	1	0	Medication: Order - External Medication
33	MEOEXTCC	☐	N1ME_MEOEXTCC	N1ME_MEOEXTCC	CHAR	1	0	Medication: Relevant for Clinical Checking
34	EXT_DRUGID	☐	N1ME_EXT_DRUGID	SYSUUID_C	CHAR	32	0	Medication: External Drug ID	N1BDCC
35	MPRESNR	☐	N1ME_MPRESNR	N1ME_MPRESNR	NUMC	10	0	Medication - Order Profile ID
36	MEPSNR	☐	N1ME_MEPSNR	N1ME_MEPSNR	NUMC	3	0	Medication: Sequence Number Order Profile
37	MEPSSTX	☐	N1ME_MEPSEQ	N1ME_MEPSEQ	CHAR	80	0	Medication: Sequence Text Order Profile
38	MEPSLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
39	ORIGIN	☐	N1ME_ORIGIN	N1ME_MEORDID	NUMC	10	0	Medication: Order - Original Order ID
40	MOPRN	☐	N1ME_PRN	N1ME_PRN	CHAR	1	0	Medication: Order - PRN Indicator
41	PRNCSTX	☐	N1ME_PRNCOND	N1ME_PRNCOND	CHAR	80	0	Medication: Order - Check Condition
42	PRNCLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
43	OLDIS	☐	N1ME_OLDIS	N1ME_OLDIS	CHAR	1	0	Medication: Order - Take Home Medication
44	SLDOSE	☐	N1ME_SLDOSE	N1ME_SLDOSE	CHAR	1	0	Medication: Orders - Sliding Dose
45	IVTYPE	☐	N1ME_IVTYPE	N1ME_IVTYPE	CHAR	1	0	Medication: Order - Infusion Type
46	RECUP	☐	N1ME_RECUP	XFELD	CHAR	1	0	Medication: Order - Flag: Recipe Updated
47	STRGTHDOS	☐	N1ME_STRGTHDOS	N1ME_STRGTHDOS	CHAR	1	0	Medication: Order - Dose Type
48	SELTYP	☐	N1ME_SELTYP	N1ME_SELTYP	CHAR	1	0	Medication: Order - Selection Type
49	PATWGT	☐	N1ME_PATWGT	N1ME_PATWGT	QUAN	12	3	Medication: Order - Patient Weight
50	PATWGTU	☐	N1ME_PATWGTU	N1ME_UNIT	UNIT	3	0	Medication: Order - Patient Weight Unit
51	PATHGT	☐	N1ME_PATHGT	N1ME_PATHGT	QUAN	12	3	Medication: Order - Patient Height
52	PATHGTU	☐	N1ME_PATHGTU	N1ME_UNIT	UNIT	3	0	Medication: Order - Patient Height Unit
53	CALCUD	☐	N1ME_CALCUD	N1ME_CALCUD	CHAR	1	0	Medication: Order - Calculation Method
54	PCALOCK	☐	N1ME_PCALOCK	N1ME_QUAN123	QUAN	12	3	Medication: PCA Lock Duration
55	PCALOCKU	☐	N1ME_PCALOCU	N1ME_UNIT	UNIT	3	0	Medication: Order - PCA Lock Duration Unit
56	PCAMAX	☐	N1ME_PCAMAX		INT1	3	0	Medication: PCA Number of Boli
57	PCAPER	☐	N1ME_PCAPER	N1ME_QUAN123	QUAN	12	3	Medication: Time Number of Boli
58	PCAPERU	☐	N1ME_PCAPERU	N1ME_UNIT	UNIT	3	0	Medication: Time Unit Number of Boli
59	COMPDOS	☐	N1ME_COMPDOS	N1ME_COMPDOS	CHAR	1	0	Medication: Dose Type for Compound
60	AL	☐	N1ME_LOCID		NUMC	4	0	ID Localization for Medication
61	CHDVER	☐	N1ME_CHDVER	XFELD	CHAR	1	0	Medication: Order - Change Attribute Check
62	RCUSE	☐	N1ME_RCUSE		CHAR	5	0	Order: Medication - Reason for Usage
63	DC_USED	☐	N1ME_DC_USED	XFELD	CHAR	1	0	Medication: Order - Dose Calculator Used
64	VFCOIND	☐	N1ME_VFCOIND	XFELD	CHAR	1	0	Check Condition Indicator
65	ADOUTPAT	☐	N1ME_ADOUTPAT	XFELD	CHAR	1	0	Medication: Administration in IP/OC
66	OUPREP	☐	N1ME_OUPREP	N1ME_OUPREP	CHAR	1	0	Medication: Preparation Fill Source Indicator
67	FIXQUAN	☐	N1ME_FIXQUAN	N1ME_FIXQUAN	CHAR	1	0	Medication: Order Ind. for Fixed Recipe Qty for Compounds
68	MEFALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
69	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
70	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
71	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
72	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
73	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
74	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
75	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
76	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
77	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
78	STOID	☐	N1STOID	N1STOID	CHAR	3	0	Reason for Canceling Medical Object	*
79	NMRF	☐	N1ME_NMRF	N1ME_NMRF	NUMC	4	0	Medication: Number of Repeats
80	INPAT_ALLOWED	☐	N1ME_INPAT_ALLOWED	N1ME_ALLOWED_CASETYPE	CHAR	1	0	Medication: Inpatient Case Type Allowed
81	DAYPAT_ALLOWED	☐	N1ME_DAYPAT_ALLOWED	N1ME_ALLOWED_CASETYPE	CHAR	1	0	Medication: Day Patient Case Type Allowed
82	OUTPAT_ALLOWED	☐	N1ME_OUTPAT_ALLOWED	N1ME_ALLOWED_CASETYPE	CHAR	1	0	Medication: Outpatient Case Type Allowed
83	IMDOSE	☐	N1ME_IMDOSE	XFELD	CHAR	1	0	Medication: Order - Immediate Dose
84	PURPOSE	☐	N1ME_ORD_PURPOSE	N1ME_ORD_PURPOSE	CHAR	1	0	Medication: Purpose of Order
85	DISPQUAN	☐	N1ME_DISPQUAN	N1ME_QUAN123	QUAN	12	3	Medication: Drug Dispensing Quantity
86	DISPQUANU	☐	N1ME_DISPQUANU	N1ME_UNIT	UNIT	3	0	Medication: Dispensing Quantity Unit

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N1MEORDER	APDEV	TN1DEVICE	APDEVID
2	N1MEORDER	APROU	TN1ROUTE	APROUID
3	N1MEORDER	EINRI	TN01	EINRI	KEY	1	CN
4	N1MEORDER	EXT_DRUGID	N1BDCC	DRUGIDBDC
5	N1MEORDER	FALNR	NFAL	FALNR	REF	C	CN
6	N1MEORDER	MANDT	T000	MANDT	KEY	1	CN
7	N1MEORDER	MOPRINT	N1MEOPRI	MOPRINT	REF	C	CN
8	N1MEORDER	MORESP1	NGPA	GPART	REF	C	CN
9	N1MEORDER	MOSID	TN1OSTATUS	MOSID	REF	1	CN
10	N1MEORDER	MOTYPID	TN1OTYPE	MOTYPID	REF	C	CN
11	N1MEORDER	ORGFA	NORG	ORGID	REF	C	CN
12	N1MEORDER	ORGPF	NORG	ORGID	REF	C	CN
13	N1MEORDER	PATNR	NPAT	PATNR	REF	C	CN
14	N1MEORDER	PHFORM	TN1PHFORM	PHFORMID

History

Last changed by/on	SAP	20110901
SAP Release Created in	472