SAP Table N1MEORDER

IS-H*MED: Medication, Medication Order

N1MEORDER (IS-H*MED: Medication, Medication Order) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link N1MEORDER to other SAP tables.

N1MEORDER table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MEORDID Medication: Order - Order Number N1ME_MEORDID NUMC 10 0
EINRI Institution EINRI TN01 CHAR 4 0
PATNR IS-H: Patient Number PATNR NPAT CHAR 10 0
FALNR IS-H: Case Number FALNR NFAL CHAR 10 0
MOTX Medication: Description of Order N1ME_MOTX CHAR 60 0
MOSTX Medication: Order - Comment N1ME_MOSTX CHAR 80 0
MOLTX Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
ORGFA Medication: Ordering Departmental Org. Unit N1ME_ORGFA NORG CHAR 8 0
ORGPF Medication: Order - Ordering Organizational Unit N1ME_ORGPF NORG CHAR 8 0
MOTYPID Medication: Type of Order N1ME_MOTYP TN1OTYPE NUMC 2 0
MOSID Medication: Status ID for Status of Medication Order N1ME_MOSID TN1OSTATUS NUMC 3 0
APDEV Medication: Administration Device ID N1ME_APDEVID TN1DEVICE CHAR 3 0
PHFORM Medication: ID Dosage Form N1ME_PHFORMID TN1PHFORM CHAR 3 0
APROU Medication: ID Administration Route N1ME_ROUTEID TN1ROUTE CHAR 3 0
MOVDF Medication: Order - Valid From Date N1ME_MOVDF DATS 8 0
MOVTF Medication: Valid From Time N1ME_MOVTF TIMS 6 0
MOVDT Medication: Order - Valid To Date N1ME_MOVDT DATS 8 0
MOVTT Medication: Order - Valid To Time N1ME_MOVTT TIMS 6 0
ORDUR Medication: Order - Order Duration N1ME_ORDUR QUAN 12 3
ORDURU Medication: Order Duration Unit N1ME_ORDURU UNIT 3 0
EXTD Medication: Change in MO Validity N1ME_EXTEND CHAR 1 0
X Yes
NULL No
MEDGRPID Medication: Drug Category Key N1ME_MEDGRPID CHAR 3 0
MOSUBTY Medication: Order - Subscreen Type N1ME_MOSUBTY NUMC 2 0
00 No Subscreen
01 Standard
02 IV
03 TPN
04 Compound
MORESP1 Medication: Order - Employee Responsible N1ME_MORESP1 NGPA CHAR 10 0
MORESP2 Medication: Order - Consulting EmR - OBSOLETE N1ME_MORESP2 CHAR 10 0
MOCONSOU Medication: Order - Consulting OU - OBSOLETE N1ME_MOCONSOU CHAR 8 0
INSTX Medication: Order - Preparation Directions N1ME_INSTX CHAR 80 0
INLTX Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
ABSG Termination Reason N1ABSG CHAR 10 0
MOPRINT Medication: Order - Internal Priority N1ME_MOPRINT N1MEOPRI NUMC 3 0
MEOEXT Medication: Order - External Medication N1ME_MEOEXT CHAR 1 0
NULL Medication Order
X Anamnesis
1 Hand Over
2 Self-Administered
MEOEXTCC Medication: Relevant for Clinical Checking N1ME_MEOEXTCC CHAR 1 0
EXT_DRUGID Medication: External Drug ID N1ME_EXT_DRUGID N1BDCC CHAR 32 0
MPRESNR Medication - Order Profile ID N1ME_MPRESNR NUMC 10 0
MEPSNR Medication: Sequence Number Order Profile N1ME_MEPSNR NUMC 3 0
MEPSSTX Medication: Sequence Text Order Profile N1ME_MEPSEQ CHAR 80 0
MEPSLTX Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
ORIGIN Medication: Order - Original Order ID - OBSOLETE N1ME_ORIGIN NUMC 10 0
MOPRN Medication: Order - PRN Indicator N1ME_PRN CHAR 1 0
NULL Indicator Not Set
X Indicator Set
PRNCSTX Medication: Order - Check Condition N1ME_PRNCOND CHAR 80 0
PRNCLTX Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
OLDIS Medication: Order - Take Home Medication - OBSOLETE N1ME_OLDIS CHAR 1 0
1 On Leave
2 Discharge
SLDOSE Medication: Orders - Sliding Dose N1ME_SLDOSE CHAR 1 0
IVTYPE Medication: Order - Infusion Type N1ME_IVTYPE CHAR 1 0
1 Intermittent
2 Single Administration
3 Continuously
RECUP Medication: Order - Flag: Recipe Updated - OBSOLETE N1ME_RECUP CHAR 1 0
X Yes
NULL No
STRGTHDOS Medication: Order - Dosage Type N1ME_STRGTHDOS CHAR 1 0
NULL Dose Unit
X Agent Strength
A Alternative Dose Unit
1 Always Agent Strength
2 Always Dose Unit
3 Always Alternative Dose Unit
SELTYP Medication: Order - Selection Type - OBSOLETE N1ME_SELTYP CHAR 1 0
1 Drug
2 Agent
PATWGT Medication: Order - Patient Weight N1ME_PATWGT QUAN 12 3
PATWGTU Medication: Order - Patient Weight Unit N1ME_PATWGTU UNIT 3 0
PATHGT Medication: Order - Patient Height N1ME_PATHGT QUAN 12 3
PATHGTU Medication: Order - Patient Height Unit N1ME_PATHGTU UNIT 3 0
CALCUD Medication: Order - Calculation Factor N1ME_CALCUD CHAR 1 0
1 Weight
2 BSA (m2)
NULL Not Applicable
PCALOCK Medication: PCA Lock Duration N1ME_PCALOCK QUAN 12 3
PCALOCKU Medication: Order - PCA Lock Duration Unit N1ME_PCALOCU UNIT 3 0
PCAMAX Medication: PCA Number of Boli N1ME_PCAMAX INT1 3 0
PCAPER Medication: Time Number of Boli N1ME_PCAPER QUAN 12 3
PCAPERU Medication: Time Unit Number of Boli N1ME_PCAPERU UNIT 3 0
COMPDOS Medication: Dose Type for Compound N1ME_COMPDOS CHAR 1 0
1 Dose
2 Total Order
AL Medication: Localization ID N1ME_LOCID NUMC 4 0
CHDVER Medication: Order - Change Attribute Check N1ME_CHDVER CHAR 1 0
X Yes
NULL No
RCUSE Medication: Order - Reason for Usage N1ME_RCUSE CHAR 5 0
DC_USED Medication: Order - Dose Calculator Used N1ME_DC_USED CHAR 1 0
NULL Dose Calculator Not Used
1 Dose Calculator Used
2 Dose Calculator Prefilled
VFCOIND Medication: Check Condition to Be Checked N1ME_CHKCO CHAR 1 0
X Yes
NULL No
ADOUTPAT Medication: Administration in IP/OC - OBSOLETE N1ME_ADOUTPAT CHAR 1 0
X Yes
NULL No
OUPREP Medication: Preparation Fill Source Indicator N1ME_OUPREP CHAR 1 0
1 Pre-Made
2 OU
3 Pharmacy
FIXQUAN Medication: Order Ind. for Fixed Recipe Qty for Compounds N1ME_FIXQUAN CHAR 1 0
MEFALAR IS-H: Case Type FALLART CHAR 1 0
1 Inpatient Case
2 Outpatient Case
3 Day Patient Case
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERTIM IS-H: Time Record Created RI_ERTIM TIMS 6 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPTIM IS-H: Time of Last Change RI_UPTIM TIMS 6 0
STORN IS-H: Cancellation Indicator RI_STORN CHAR 1 0
X Yes
NULL No
STUSR IS-H: Name of User who Canceled Data Record STORN_USER CHAR 12 0
STDAT Date of Cancellation STORN_DAT DATS 8 0
STOID Reason for Canceling Medical Object N1STOID CHAR 3 0
NMRF Medication: Number of Repeats N1ME_NMRF NUMC 4 0
INPAT_ALLOWED Medication: Inpatient Case Type Allowed - OBSOLETE N1ME_INPAT_ALLOWED CHAR 1 0
NULL Do Not Ccheck/All Possible
0 Cannot Be True
1 Must Be True
DAYPAT_ALLOWED Medication: Day Patient Case Type Allowed - OBSOLETE N1ME_DAYPAT_ALLOWED CHAR 1 0
NULL Do Not Ccheck/All Possible
0 Cannot Be True
1 Must Be True
OUTPAT_ALLOWED Medication: Outpatient Case Type Allowed - OBSOLETE N1ME_OUTPAT_ALLOWED CHAR 1 0
NULL Do Not Ccheck/All Possible
0 Cannot Be True
1 Must Be True
IMDOSE Medication: Order - Immediate Dose N1ME_IMDOSE CHAR 1 0
X Yes
NULL No
PURPOSE Medication: Purpose of Order N1ME_ORD_PURPOSE CHAR 1 0
1 Dispensing
2 Prescription Print
3 Administration Event
DISPQUAN Medication: Drug Dispensing Quantity N1ME_DISPQUAN QUAN 24 12
DISPQUANU Medication: Dispensing Quantity Unit N1ME_DISPQUANU UNIT 3 0
TPID Medication: ID Order Template N1ME_TPID CHAR 10 0
DURMETH Medication: Determination of Order Validity N1ME_DURMETH CHAR 1 0
NULL Duration
1 End Date and End Time
VALTIME Medication: Validation Time N1ME_VALTIME DEC 15 0
VALVMA Employee Responsible N1MITARB CHAR 10 0
ENDORIGIN Medication: Reason ID N1ME_RCODEID CHAR 5 0
ORMOVDT Medication: End Date Before Order Sequence N1ME_ORMOVDT DATS 8 0
ORMOVTT Medication: End Time Before Order Sequence N1ME_ORMOVTT TIMS 6 0
PDUR Medication: Planned Duration N1ME_PLDUR QUAN 12 3
PDURU Medication: Administration Duration Unit N1ME_DURU UNIT 3 0
DOSDEF Medication: Simplified Dose Definition N1ME_DOSDEF CHAR 400 0
DCM Medication: Dose Calculation Method N1ME_DCM CHAR 1 0
NULL Single Dose
1 Daily Dose
2 Total Dose
DELAY Medication: Delayed Order Start N1ME_DELAY NUMC 8 0
DELAYU Medication: Unit of Delayed Order Start N1ME_DELAYU UNIT 3 0
FIXEDDELAY Medication: Fix Delayed Order Start N1ME_FIXEDDELAY CHAR 1 0
SPECREQ Medication: Special Request Indicator N1ME_SPECREQ CHAR 1 0
X Yes
NULL No
AUTIDEM Indicator for Allowed Drug Substitution N1ME_ORD_AUTIDEM CHAR 1 0
NULL Permitted
X Not Permitted
EMORD Medication - Emergency Order N1ME_EMORD CHAR 1 0
X Yes
NULL No
COUNTDAY Medication - Treatment Start Day N1ME_COUNTDAY NUMC 3 0
PDUR_MODE Medication: Calculation Method Duration/Flow Rate N1ME_PDUR_MODE CHAR 1 0
1 Duration
2 Flow Rate

N1MEORDER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
N1MEORDER APDEV N1MEORDER APDEV TN1DEVICE Medication: Administration Devices APDEVID
N1MEORDER APDEV N1MEORDER MANDT TN1DEVICE Medication: Administration Devices MANDT
N1MEORDER APROU N1MEORDER APROU TN1ROUTE Medication: Administration Routes APROUID
N1MEORDER APROU N1MEORDER MANDT TN1ROUTE Medication: Administration Routes MANDT
N1MEORDER EINRI N1MEORDER MANDT TN01 IS-H: Institutions MANDT
N1MEORDER EINRI N1MEORDER EINRI TN01 IS-H: Institutions EINRI
N1MEORDER EXT_DRUGID N1MEORDER MANDT N1BDCC IS-H*MED: External Drug Basic Catalog Entries MANDT
N1MEORDER EXT_DRUGID N1MEORDER EXT_DRUGID N1BDCC IS-H*MED: External Drug Basic Catalog Entries DRUGIDBDC
N1MEORDER FALNR N1MEORDER MANDT NFAL IS-H: Cases MANDT
N1MEORDER FALNR N1MEORDER EINRI NFAL IS-H: Cases EINRI
N1MEORDER FALNR N1MEORDER FALNR NFAL IS-H: Cases FALNR
N1MEORDER MANDT N1MEORDER MANDT T000 Clients MANDT
N1MEORDER MOPRINT N1MEORDER MOPRINT N1MEOPRI IS-H*MED: Medication - Order Priority MOPRINT
N1MEORDER MOPRINT N1MEORDER MANDT N1MEOPRI IS-H*MED: Medication - Order Priority MANDT
N1MEORDER MOPRINT N1MEORDER EINRI N1MEOPRI IS-H*MED: Medication - Order Priority EINRI
N1MEORDER MORESP1 N1MEORDER MORESP1 NGPA IS-H: Business Partners GPART
N1MEORDER MORESP1 N1MEORDER MANDT NGPA IS-H: Business Partners MANDT
N1MEORDER MOSID N1MEORDER MANDT TN1OSTATUS IS-H*MED: Status for Drug Order MANDT
N1MEORDER MOSID N1MEORDER EINRI TN1OSTATUS IS-H*MED: Status for Drug Order EINRI
N1MEORDER MOSID N1MEORDER MOSID TN1OSTATUS IS-H*MED: Status for Drug Order MOSID
N1MEORDER MOTYPID N1MEORDER EINRI TN1OTYPE IS-H*MED: Medication, Type of Order EINRI
N1MEORDER MOTYPID N1MEORDER MOTYPID TN1OTYPE IS-H*MED: Medication, Type of Order MOTYPID
N1MEORDER MOTYPID N1MEORDER MANDT TN1OTYPE IS-H*MED: Medication, Type of Order MANDT
N1MEORDER ORGFA N1MEORDER MANDT NORG IS-H: Organizational Units MANDT
N1MEORDER ORGFA N1MEORDER ORGFA NORG IS-H: Organizational Units ORGID
N1MEORDER ORGPF N1MEORDER MANDT NORG IS-H: Organizational Units MANDT
N1MEORDER ORGPF N1MEORDER ORGPF NORG IS-H: Organizational Units ORGID
N1MEORDER PATNR N1MEORDER MANDT NPAT IS-H: Patient Master Data (General) MANDT
N1MEORDER PATNR N1MEORDER PATNR NPAT IS-H: Patient Master Data (General) PATNR
N1MEORDER PHFORM N1MEORDER MANDT TN1PHFORM Medication: Dosage Form MANDT
N1MEORDER PHFORM N1MEORDER PHFORM TN1PHFORM Medication: Dosage Form PHFORMID