SAP ABAP Table VN1ODRUG (IS-H*MED: N1ODRUG (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	VN1ODRUG	Table Relationship Diagram
Short Description	IS-H*MED: N1ODRUG (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: Medication, Drugs of Order
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ODRUGID	☐	N1ME_ODRUGID	N1ME_ODRUGID	NUMC	10	0	Medication: Ordered Drug, Internal ID
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	PDRUGAQ	☐	N1ME_PDRUGAQ	N1ME_PDRUGAQ	QUAN	12	3	Medication: Planned Drug Quantity
10	PDRUGMQ	☐	N1ME_PDRUGMQ	N1ME_PDRUGMQ	QUAN	12	3	Medication: Drug Quantity
11	DRUGU	☐	N1ME_DRUGU	N1ME_DRUGU	UNIT	3	0	Medication: Unit
12	DRUGASTR	☐	N1ME_DRUGASTR	N1ME_DRUGASTR	QUAN	12	3	Medication: Dose
13	DRUGASTRU	☐	N1ME_DRUGASTRU	N1ME_DRUGU	UNIT	3	0	Medication: Dose Unit
14	CALCUD	☐	N1ME_CALCUD	N1ME_CALCUD	CHAR	1	0	Medication: Order - Calculation Method
15	CMU	☐	N1ME_CMU	MEINS	UNIT	3	0	Medication: Order - Calculation Method Unit	*
16	DOSE	☐	N1ME_DOSE	N1ME_DOSE	QUAN	12	3	Medication: Dose
17	DOSEU	☐	N1ME_DOSEU	N1ME_DRUGU	UNIT	3	0	Medication: Dose Unit
18	RECAA	☐	N1ME_RECAA	N1ME_RECAA	QUAN	12	3	Medication: Quantity to Be Administered
19	RECU	☐	N1ME_RECU	N1ME_DRUGU	UNIT	3	0	Medication: Unit of Quantity to Be Administered
20	RECAM	☐	N1ME_RECAM	N1ME_RECAM	QUAN	12	3	Medication: Quantity to Be Prepared
21	CALCREL	☐	N1ME_CALCREL	N1ME_CALCREL	CHAR	1	0	Medication: Calculation Type of Dosage
22	DCONTS	☐	N1ME_DCONTS	N1ME_DCONTS	QUAN	12	3	Medication: Package Size
23	DCONTU	☐	N1ME_DCONTU	N1ME_DCONTU	UNIT	3	0	Medication: Package Size Unit
24	PIVDUR	☐	N1ME_PIVDUR	N1ME_PIVDUR	NUMC	4	0	Medication: Planned Duration
25	ADRATE	☐	N1ME_ADRATE	N1ME_ADRATE	NUMC	4	0	Medication, Ordered Drug - Flow Rate
26	ADRATETQ	☐	N1ME_ADRATETQ	N1ME_ADRATETQ	QUAN	12	3	Medication: Flow Rate Time
27	ADRATEU	☐	N1ME_ADRATEU	N1ME_DRUGU	UNIT	3	0	Medication: Flow Rate Volume Unit
28	AGENTID	☐	N1ME_AGENTID	SYSUUID_C	CHAR	32	0	Medication: Agent ID	NAGENT
29	FSOURCE	☐	N1ME_FSOURCE	N1ME_FSOURCE	CHAR	12	0	Medication: Fill Source Key	N1FSOURCE
30	PDUR	☐	N1ME_EPDUR	N1ME_QUAN123	QUAN	12	3	Medication: Administration Duration
31	PDURU	☐	N1ME_PDURU	N1ME_UNIT	UNIT	3	0	Medication: Order - Planned Admin. Duration, Unit
32	RECQUAN	☐	N1ME_RECQUAN	N1ME_RECQUAN	QUAN	12	3	Medication: Recipe Quantity
33	RECQUANU	☐	N1ME_RECQUANU	MEINS	UNIT	3	0	Recipe Quantity Unit	*
34	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
35	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
36	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
37	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
38	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
39	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
40	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
41	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
42	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
43	STOID	☐	N1STOID	N1STOID	CHAR	3	0	Reason for Canceling Medical Object	*
44	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
45	STRGTHU	☐	N1ME_STRGTHU	MEINS	UNIT	3	0	Strength Unit	*
46	STRGTHP	☐	N1ME_STRGTHP	N1ME_QUAN123	QUAN	12	3	Reference Quantity
47	STRGTHPU	☐	N1ME_STRGTHPU	MEINS	UNIT	3	0	Reference Quantity Unit	*
48	.INCLUDE	☐				0	0	Structures for generating change document update programs
49	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	VN1ODRUG	AGENTID	NAGENT	AGENTID
2	VN1ODRUG	DRUGID	N1FORMULARY	DRUGID
3	VN1ODRUG	EINRI	TN01	EINRI	KEY	1	CN
4	VN1ODRUG	FSOURCE	N1FSOURCE	FSOURCE
5	VN1ODRUG	MANDT	T000	MANDT	KEY	1	CN
6	VN1ODRUG	MEORDID	N1MEORDER	MEORDID	REF	1	CN

History

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