SAP ABAP Table N1EDRUG (IS-H*MED: Drug Event - Drug Assignment)

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	N1EDRUG	Table Relationship Diagram
Short Description	IS-H*MED: Drug Event - Drug Assignment

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	EDRUGID	☑	N1ME_EDRUGID	N1ME_EDRUGID	NUMC	10	0	Medication: ID
3	MEEVTID	☐	N1ME_MEEVTID	N1ME_MEEVTID	NUMC	10	0	Medication: Event Number
4	MEORDID	☐	N1ME_MEORDID	N1ME_MEORDID	NUMC	10	0	Medication: Order - Order Number	N1MEORDER
5	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
6	DRUGID	☐	N1ME_DRUGID	SYSUUID_C	CHAR	32	0	Medication: Drug ID	N1FORMULARY
7	DRUGTYP	☐	N1ME_DRUGTYP	N1ME_DRUGTYP	CHAR	1	0	Type of Ingredient
8	PDRUGDQ	☐	N1ME_PDRUGDQ	N1ME_PDRUGDQ	QUAN	12	3	Medication: Planned Quantity
9	RDRUGDQ	☐	N1ME_RDRUGDQ	N1ME_RDRUGDQ	QUAN	12	3	Medication: Actual Quantity
10	SCRAP	☐	N1ME_SCRAP	N1ME_QUAN123	QUAN	12	3	Medication: Scrap Quantity
11	DRUGU	☐	N1ME_DRUGU	N1ME_DRUGU	UNIT	3	0	Medication: Unit
12	PDRUGASTR	☐	N1ME_PDRUGASTR	N1ME_PDRUGASTR	QUAN	12	3	Medication: Planned Total Dose
13	RDRUGASTR	☐	N1ME_RDRUGASTR	N1ME_RDRUGASTR	QUAN	12	3	Medication: Actual Patient Dose
14	DRUGASTRU	☐	N1ME_DRUGASTRU	N1ME_DRUGU	UNIT	3	0	Medication: Dose Unit
15	CALCREL	☐	N1ME_CALCREL	N1ME_CALCREL	CHAR	1	0	Medication: Calculation Type of Dosage
16	FSOURCE	☐	N1ME_FSOURCE	N1ME_FSOURCE	CHAR	12	0	Medication: Fill Source Key	N1FSOURCE
17	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
18	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	MCHA
19	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
20	PICKLIST	☐	N1ME_PICKLIST		NUMC	14	0	Medication: Date, Time Stamp
21	MJAHR	☐	JAHR	GJAHR	NUMC	4	0	Year for which levy is to be carried out
22	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
23	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
24	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
25	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
26	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
27	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
28	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
29	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
30	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
31	STOID	☐	N1STOID	N1STOID	CHAR	3	0	Reason for Canceling Medical Object	N1STGR
32	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
33	STRGTHU	☐	N1ME_STRGTHU	MEINS	UNIT	3	0	Strength Unit	*
34	STRGTHP	☐	N1ME_STRGTHP	N1ME_QUAN123	QUAN	12	3	Reference Quantity
35	STRGTHPU	☐	N1ME_STRGTHPU	MEINS	UNIT	3	0	Reference Quantity Unit	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N1EDRUG	CHARG	MCHA	CHARG	KEY	1	CN
2	N1EDRUG	DRUGID	N1FORMULARY	DRUGID
3	N1EDRUG	EINRI	TN01	EINRI	KEY	1	CN
4	N1EDRUG	FSOURCE	N1FSOURCE	FSOURCE
5	N1EDRUG	MANDT	T000	MANDT	KEY	1	CN
6	N1EDRUG	MATNR	MARA	MATNR	KEY	1	CN
7	N1EDRUG	MEORDID	N1MEORDER	MEORDID
8	N1EDRUG	STOID	N1STGR	STOID	KEY	1	CN
9	N1EDRUG	WERKS	MCHA	WERKS	KEY	1	CN

History

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