SAP ABAP Table VN1EDRUG (IS-H*MED: N1EDRUG (Verbucher))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	VN1EDRUG	Table Relationship Diagram
Short Description	IS-H*MED: N1EDRUG (Verbucher)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

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

History

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