1. Home
  2. Resources
  3. SAP Tables
  4. N1EDRUG - IS-H*MED: Drug Event - Drug Assignment

SAP Table N1EDRUG

IS-H*MED: Drug Event - Drug Assignment

N1EDRUG (IS-H*MED: Drug Event - Drug Assignment) 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 N1EDRUG to other SAP tables.

N1EDRUG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EDRUGID Medication: Drug ID for Event N1ME_EDRUGID NUMC 10 0
MEEVTID Medication: Event Number N1ME_MEEVTID NUMC 10 0
MEORDID Medication: Order - Order Number N1ME_MEORDID N1MEORDER NUMC 10 0
EINRI Institution EINRI TN01 CHAR 4 0
DRUGID Medication: Mnemonic N1ME_DRUGID N1FORMULARY CHAR 32 0
DRUGTYP Type of Ingredient N1ME_DRUGTYP CHAR 1 0
NULL Administrable Drug
1 Ingredient of Drug
2 Active Ingredient of Drug
3 Solution
4 Drug Supplement
5 Substitute Drug
PDRUGDQ Medication: Planned Quantity N1ME_PDRUGDQ QUAN 24 12
RDRUGDQ Medication: Actual Quantity N1ME_RDRUGDQ QUAN 24 12
SCRAP Medication: Scrap Quantity N1ME_SCRAP QUAN 24 12
DRUGU Medication: Unit N1ME_DRUGU UNIT 3 0
PDRUGASTR Medication: Plan Total Patient Dose - OBSOLETE N1ME_PDRUGASTR_O QUAN 12 3
RDRUGASTR Medication: Actual Patient Dose - OBSOLETE N1ME_RDRUGASTR_O QUAN 12 3
DRUGASTRU Medication: Dose Unit - OBSOLETE N1ME_DRUGASTRU_O UNIT 3 0
CALCREL Medication: Calculation Type of Dosage - OBSOLETE N1ME_CALCREL_O CHAR 1 0
FSOURCE Medication: Fill Source Key N1ME_FSOURCE N1FSOURCE CHAR 12 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MCHA CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
PICKLIST Medication: Date, Time Stamp Closure List N1ME_PICKLIST NUMC 14 0
MJAHR Year for which levy is to be carried out JAHR NUMC 4 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERTIM IS-H: Time Record Created RI_ERTIM TIMS 6 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM 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
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 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 N1STGR CHAR 3 0
STRGTH Medication: Drug Strength - OBSOLETE N1ME_STRGTH_O QUAN 12 3
STRGTHU Medication: Strength Unit - OBSOLETE N1ME_STRGTHU_O UNIT 3 0
STRGTHP Medication: Reference Dose - OBSOLETE N1ME_STRGTHP_O QUAN 12 3
STRGTHPU Medication: Reference Qty Unit - OBSOLETE N1ME_STRGTHPU_O UNIT 3 0
OPDRUGDQ Medication: Original Planned Quantity N1ME_OPDRUGDQ QUAN 24 12

N1EDRUG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
N1EDRUG CHARG N1EDRUG MANDT MCHA Batches MANDT
N1EDRUG CHARG N1EDRUG MATNR MCHA Batches MATNR
N1EDRUG CHARG N1EDRUG WERKS MCHA Batches WERKS
N1EDRUG CHARG N1EDRUG CHARG MCHA Batches CHARG
N1EDRUG DRUGID N1EDRUG DRUGID N1FORMULARY Medication: Drug Formulary DRUGID
N1EDRUG DRUGID N1EDRUG MANDT N1FORMULARY Medication: Drug Formulary MANDT
N1EDRUG EINRI N1EDRUG MANDT TN01 IS-H: Institutions MANDT
N1EDRUG EINRI N1EDRUG EINRI TN01 IS-H: Institutions EINRI
N1EDRUG FSOURCE N1EDRUG MANDT N1FSOURCE IS-H*MED: Fill Source MANDT
N1EDRUG FSOURCE N1EDRUG FSOURCE N1FSOURCE IS-H*MED: Fill Source FSOURCE
N1EDRUG MANDT N1EDRUG MANDT T000 Clients MANDT
N1EDRUG MATNR N1EDRUG MANDT MARA General Material Data MANDT
N1EDRUG MATNR N1EDRUG MATNR MARA General Material Data MATNR
N1EDRUG MEORDID N1EDRUG MANDT N1MEORDER IS-H*MED: Medication, Medication Order MANDT
N1EDRUG MEORDID N1EDRUG MEORDID N1MEORDER IS-H*MED: Medication, Medication Order MEORDID
N1EDRUG STOID N1EDRUG MANDT N1STGR IS-H: Cancellation Reasons MANDT
N1EDRUG STOID N1EDRUG EINRI N1STGR IS-H: Cancellation Reasons EINRI
N1EDRUG STOID N1EDRUG STOID N1STGR IS-H: Cancellation Reasons STOID
N1EDRUG WERKS N1EDRUG MANDT MCHA Batches MANDT
N1EDRUG WERKS N1EDRUG MATNR MCHA Batches MATNR
N1EDRUG WERKS N1EDRUG WERKS MCHA Batches WERKS
N1EDRUG WERKS N1EDRUG CHARG MCHA Batches CHARG