SAP ABAP Table N1OSETDRUG (IS-H*MED: Order Template - 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	N1OSETDRUG	Table Relationship Diagram
Short Description	IS-H*MED: Order Template - Drug Assignment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	OSETID	☑	N1ME_OSETID		CHAR	20	0	Drug Order Templates ID	N1OSET
3	DRUGID	☑	N1ME_DRUGID	SYSUUID_C	CHAR	32	0	Medication: Drug ID	N1FORMULARY
4	SEQNO	☐	N1ME_SEQNO	N1ME_SEQNR	NUMC	3	0	Medication: Sequence Number
5	PDRUGAQ	☐	N1ME_PDRUGAQ	N1ME_PDRUGAQ	QUAN	12	3	Medication: Planned Drug Quantity
6	PDRUGMQ	☐	N1ME_PDRUGMQ	N1ME_PDRUGMQ	QUAN	12	3	Medication: Drug Quantity
7	DRUGU	☐	N1ME_DRUGU	N1ME_DRUGU	UNIT	3	0	Medication: Unit
8	PADDUR	☐	N1ME_APDUR		NUMC	4	0	Medication: Planned Administration Period
9	ADRATE	☐	N1ME_ADRATE	N1ME_ADRATE	NUMC	4	0	Medication, Ordered Drug - Flow Rate
10	ADRATEU	☐	N1ME_ADRATEU	N1ME_DRUGU	UNIT	3	0	Medication: Flow Rate Volume Unit
11	ADRATEQ	☐	N1ME_ADRATEQ		NUMC	4	0	Medication: Ordered Drug - Administration Quantity
12	ZNR	☐	N1ZNR	N1C010	CHAR	10	0	Cycle Key	N1STZY
13	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
14	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
15	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
16	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
17	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
18	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N1OSETDRUG	DRUGID	N1FORMULARY	DRUGID
2	N1OSETDRUG	MANDT	T000	MANDT
3	N1OSETDRUG	OSETID	N1OSET	OSETID
4	N1OSETDRUG	ZNR	N1STZY	N1ZNR

History

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