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

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

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	DRUGID	☐	N1ME_DRUGID	SYSUUID_C	CHAR	32	0	Medication: Drug ID
3	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
4	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
5	RCDEACT	☐	N1ME_RCODEID	N1ME_RCODEID	CHAR	5	0	Medication: Reason ID	TN1RCODE
6	CATID	☐	N1ME_CATID		CHAR	3	0	Identification of Internal Drug Catalog (Formulary)	N1DC
7	MANUAL	☐	N1ME_MANUAL	XFELD	CHAR	1	0	Manually Added Data Record Indicator
8	NOTES	☐	N1ME_NOTES	XFELD	CHAR	1	0	Notes Exist Indicator
9	DOCTY	☐	N2_DTID	N2_DTID	CHAR	10	0	Document Category ID	N2DT
10	AUTIDEM	☐	N1ME_AUTIDEM	XFELD	CHAR	1	0	Drug Substitution Allowed Indicator
11	ADMDRUG	☐	N1ME_ADMDRUG	XFELD	CHAR	1	0	Administered Drug Indicator
12	BDCUPD	☐	N1ME_BDCUPD	XFELD	CHAR	1	0	Medication: Indicator for Synchronize with Basic Catalog
13	DRUGIDBDC	☐	N1ME_DRUGIDBDC	SYSUUID_C	CHAR	32	0	Medication: Mnemonic in Basic Catalog	N1BDCC
14	TRMDAYS	☐	N1ME_TRMDAYS		INT1	3	0	Preset Treatment Period (Days)
15	TRMSTOP	☐	N1ME_TRMSTOP	XFELD	CHAR	1	0	Indicator Stop After Treatment Period
16	PREVENT	☐	N1ME_PREVENT		INT1	3	0	Event Generation Horizon in Days
17	MEDGROUP	☐	N1ME_MEDGROUP		CHAR	10	0	Drug Category
18	ADRTIMU	☐	N1ME_ADRTIMU	MEINS	UNIT	3	0	Medication: Unit of Administration Duration	T006
19	ADRTIM	☐	N1ME_ADRTIM		INT4	10	0	Medication: Administration Duration
20	IVOLIND	☐	N1ME_IVOLIDX		INT4	10	0	Medication: Volume Index
21	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
22	INDISDOS	☐	N1ME_DISCDOS	XFELD	CHAR	1	0	Medication: Indiscreet Dose Indicator
23	ZNR	☐	N1ZNR	N1C010	CHAR	10	0	Cycle Key	N1STZY
24	CATIDBDC	☐	N1ME_CATID		CHAR	3	0	Identification of Internal Drug Catalog (Formulary)	N1DC
25	VERSDATE	☐	N1ME_VERSDATE		NUMC	14	0	Medication: Date and Time of Version
26	EXTDCODECAT	☐	N1ME_EXTDCODECAT		CHAR	3	0	ID of Identification System
27	EXTDCODEID	☐	N1ME_EXTDCODEID		CHAR	40	0	Medication: External Drug ID
28	EXTDINGCODE	☐	N1ME_EXTDINGCODE		CHAR	40	0	Agent ID in Referenced External Drug Catalog
29	BRANDNAME	☐	N1ME_BRANDNAME		CHAR	60	0	Brand Name
30	GENNAME	☐	N1ME_GENNAME		CHAR	60	0	Generic Name
31	NARCOTIC	☐	N1ME_NARCOTIC	XFELD	CHAR	1	0	Narcotic Indicator
32	PSYCHO	☐	N1ME_PSYCHO	XFELD	CHAR	1	0	Medication: Psychotropic Indicator
33	CONTR	☐	N1ME_CONTR	XFELD	CHAR	1	0	Medication: Controlled Drug Indicator
34	MONO	☐	N1ME_MONO	XFELD	CHAR	1	0	Medication: Single Ingredient Drug Indicator
35	MANUF	☐	N1ME_MANUF		CHAR	60	0	Manufacturer
36	APDEVID	☐	N1ME_APDEVID		CHAR	3	0	Medication: Administration Device ID
37	APROUTEID	☐	N1ME_ROUTEID		CHAR	3	0	Medication: ID Administration Route	TN1ROUTE
38	PHFORMID	☐	N1ME_PHFORMID		CHAR	3	0	Medication: ID Dosage Form	TN1PHFORM
39	UNIT	☐	N1ME_UNIT	MEINS	UNIT	3	0	Drug Base Unit	T006
40	QUAN	☐	N1ME_QUAN	N1ME_QUAN123	QUAN	12	3	Drug Base Quantity
41	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
42	STRGTHU	☐	N1ME_STRGTHU	MEINS	UNIT	3	0	Strength Unit	T006
43	PKGUNIT	☐	N1ME_PKGUNIT	MEINS	UNIT	3	0	Medication: Package Unit	T006
44	PKGSIZE	☐	N1ME_PKGSIZE	N1ME_QUAN123	QUAN	12	3	Medication: Package Size
45	DEFQ	☐	N1ME_DEFQ		QUAN	8	3	Default Quantity
46	DEFDOSM	☐	N1ME_DEFDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Standard Individual Dose
47	DEFDOSD	☐	N1ME_DEFDOSD		QUAN	8	3	Medication: Standard Daily Dose
48	DEFDOSL	☐	N1ME_DEFDOSL		QUAN	8	3	Medication: Standard Lifetime Dose
49	DEFEXP	☐	N1ME_DEFEXP	N1ME_QUAN123	QUAN	12	3	Medication: Shelf Life
50	DEFEXPTU	☐	N1ME_DEFEXPTU	MEINS	UNIT	3	0	Default Expiry Period Time Unit	T006
51	DEFCYCQ	☐	N1ME_DEFCYCQ		QUAN	8	3	Default Cycle Quantity
52	DEFCYCTU	☐	N1ME_DEFCYCTU	MEINS	UNIT	3	0	Default Cycle Period Time Unit	T006
53	DEFCYCTUMX	☐	N1ME_DEFCYCTUMX		QUAN	3	0	Default Cycle - Maximum Period Time Unit
54	MAXQ	☐	N1ME_MAXQ		QUAN	8	3	Maximum Quantity
55	MAXDOSM	☐	N1ME_MAXDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Individual Dose
56	MAXDOSD	☐	N1ME_MAXDOSD	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Daily Dose
57	MAXDOSL	☐	N1ME_MAXDOSL	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Lifetime Dose
58	REFRIGERATE	☐	N1ME_REFRIGERATE	XFELD	CHAR	1	0	Refrigeration Necessary Indicator
59	MAXTEMP	☐	N1ME_MAXTEMP		QUAN	3	0	Medication: Maximum Storage Temperature
60	TEMPU	☐	N1ME_TEMPU	MEINS	UNIT	3	0	Medication: Temperature Unit	T006
61	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
62	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
63	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
64	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
65	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
66	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	RN1ME_FORMULARY	ADRTIMU	T006	MSEHI
2	RN1ME_FORMULARY	APROUTEID	TN1ROUTE	APROUID
3	RN1ME_FORMULARY	CATID	N1DC	CATID
4	RN1ME_FORMULARY	CATIDBDC	N1DC	CATID
5	RN1ME_FORMULARY	DEFCYCTU	T006	MSEHI
6	RN1ME_FORMULARY	DEFEXPTU	T006	MSEHI
7	RN1ME_FORMULARY	DOCTY	N2DT	DTID
8	RN1ME_FORMULARY	DRUGIDBDC	N1BDCC	DRUGIDBDC
9	RN1ME_FORMULARY	MANDT	T000	MANDT
10	RN1ME_FORMULARY	MATNR	MARA	MATNR
11	RN1ME_FORMULARY	PHFORMID	TN1PHFORM	PHFORMID
12	RN1ME_FORMULARY	PKGUNIT	T006	MSEHI
13	RN1ME_FORMULARY	RCDEACT	TN1RCODE	RCODEID	KEY	C	CN
14	RN1ME_FORMULARY	STRGTHU	T006	MSEHI
15	RN1ME_FORMULARY	TEMPU	T006	MSEHI
16	RN1ME_FORMULARY	UNIT	T006	MSEHI
17	RN1ME_FORMULARY	ZNR	N1STZY	N1ZNR

History

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