SAP ABAP Table N1DRUGDOC (IS-H*MED: Drug Documentation)

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	N1DRUGDOC	Table Relationship Diagram
Short Description	IS-H*MED: Drug Documentation

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	PDRPID	☑	N1ME_PDRPID	N1ME_PDRPID	NUMC	10	0	Drug Documentation ID
3	EPREPID	☐	N1ME_EPREPID	N1ME_EPREPID	NUMC	10	0	Medication: ID of Preparation	N1EPREPDOC
4	EADDOCID	☐	N1ME_EADDOCID	N1ME_EADDOCID	NUMC	10	0	Medication, Event Administration Document Doc. ID	N1EADDOC
5	EDRUGID	☐	N1ME_EDRUGID	N1ME_EDRUGID	NUMC	10	0	Medication: ID	N1EDRUG
6	DRUGID	☐	N1ME_DRUGID	SYSUUID_C	CHAR	32	0	Medication: Drug ID	N1FORMULARY
7	QUANTA	☐	N1ME_QUANTA	N1ME_QUANTA	QUAN	12	3	Medication: Quantity for Administration
8	QUANTM	☐	N1ME_QUANTM	N1ME_QUANTM	QUAN	12	3	Medication: Creation Quantity
9	DOSE	☐	N1ME_DOSE	N1ME_DOSE	QUAN	12	3	Medication: Dose
10	DOSEU	☐	N1ME_MSEHI	MEINS	UNIT	3	0	Medication: Measurement Unit	TN1MEUNIT
11	QUANTU	☐	N1ME_MSEHI	MEINS	UNIT	3	0	Medication: Measurement Unit	TN1MEUNIT
12	FSOURCE	☐	N1ME_FSOURCE	N1ME_FSOURCE	CHAR	12	0	Medication: Fill Source Key	N1FSOURCE
13	RSNUM	☐	N1ME_RSNUMC	RSNUM	NUMC	10	0	Medication: Number of Reservation / Dependent Requirement	RESB
14	RSPOS	☐	N1ME_RSPOS	RSPOS	NUMC	4	0	Medication: Document Number of Reservation	RESB
15	MBLNR	☐	N1ME_MBLNR_C10	BELNR	CHAR	10	0	Medication: Number of Material Document	MKPF
16	MBLPO	☐	N1ME_MBLPO_NC4	MBLPO	NUMC	4	0	Medication: Item in Material Document	MSEG
17	BELNR	☐	N1ME_BELNR	N1ME_BELNR	CHAR	10	0	Document Number
18	BUZEI	☐	N1ME_BUZEI		CHAR	10	0	Order: Event - CO Posting Line
19	MJAHR	☐	N1ME_MJAHR	GJAHR	NUMC	4	0	Medication: Material Document Year
20	ENMNG	☐	N1ME_ENMNG	MENG13	QUAN	13	3	Medication: Quantity Removed
21	KZEAR	☐	N1ME_KZEAR	XFELD	CHAR	1	0	Medication: Final Issue of Reservation
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	STMBLNR	☐	N1ME_STMBLNR	BELNR	CHAR	10	0	Medication: Number of Material Doc. Cancellation
29	STMBLPO	☐	N1ME_STMBLPO	MBLPO	NUMC	4	0	Medication: Position in Cancellation Material Document
30	STMJAHR	☐	N1ME_STMJAHR	GJAHR	NUMC	4	0	Medication: Material Document Year (Canc. Doc.)
31	STBELNR	☐	N1ME_STBELNR	CO_BELNR	CHAR	10	0	Medication: Document Number Cancellation	*
32	STBUZEI	☐	N1ME_STBUZEI	BUZEI	NUMC	3	0	Medication: CO Posting Line (Cancellation)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N1DRUGDOC	DOSEU	TN1MEUNIT	UNIT
2	N1DRUGDOC	DRUGID	N1FORMULARY	DRUGID
3	N1DRUGDOC	EADDOCID	N1EADDOC	EADDOCID
4	N1DRUGDOC	EDRUGID	N1EDRUG	EDRUGID
5	N1DRUGDOC	EPREPID	N1EPREPDOC	EPREPID
6	N1DRUGDOC	FSOURCE	N1FSOURCE	FSOURCE
7	N1DRUGDOC	MANDT	T000	MANDT
8	N1DRUGDOC	MBLNR	MKPF	MBLNR
9	N1DRUGDOC	MBLPO	MSEG	ZEILE
10	N1DRUGDOC	QUANTU	TN1MEUNIT	UNIT
11	N1DRUGDOC	RSNUM	RESB	RSNUM
12	N1DRUGDOC	RSPOS	RESB	RSPOS

History

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