SAP ABAP Table RN1FORMMAIN (IS-H*MED: Drug Data for List Display)

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	RN1FORMMAIN	Table Relationship Diagram
Short Description	IS-H*MED: Drug Data for List Display

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	AKTSTAT	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
2	DRUGNAME	☐	N1ME_DRUGNAME		CHAR	20	0	Mnemonic (Drug Name)
3	.INCLUDE	☐				0	0	Medication: Drug Formulary
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	DRUGID	☐	N1ME_DRUGID	SYSUUID_C	CHAR	32	0	Medication: Drug ID
6	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
7	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
8	CATID	☐	N1ME_CATID		CHAR	3	0	Identification of Internal Drug Catalog (Formulary)	N1DC
9	RCDEACT	☐	N1ME_RCODEID	N1ME_RCODEID	CHAR	5	0	Medication: Reason ID	TN1RCODE
10	DEACT_RC	☐	N1ME_RCDEACTV	N1ME_RCODEID	CHAR	5	0	Medication: Deactivation Reason Code	TN1RCIND
11	MANUAL	☐	N1ME_MANUAL	XFELD	CHAR	1	0	Manually Added Data Record Indicator
12	NOTE1	☐	N1ME_NOTE1	XFELD	CHAR	1	0	Note for Pharmacist Exists Indicator
13	NOTE2	☐	N1ME_NOTE2	XFELD	CHAR	1	0	Note for Nurse Exists Indicator
14	NOTE3	☐	N1ME_NOTE3	XFELD	CHAR	1	0	Note for Physician Exists Indicator
15	PREP	☐	N1ME_PREP	XFELD	CHAR	1	0	Preparation Directions Exist Indicator
16	AUTIDEM	☐	N1ME_AUTIDEM	XFELD	CHAR	1	0	Drug Substitution Allowed Indicator
17	BDCUPD	☐	N1ME_BDCUPD	XFELD	CHAR	1	0	Medication: Indicator for Synchronize with Basic Catalog
18	CATIDBDC	☐	N1ME_CATIDBDC		CHAR	3	0	Identification of External Drug Catalog	N1DC
19	DRUGIDBDC	☐	N1ME_DRUGIDBDC	SYSUUID_C	CHAR	32	0	Medication: Mnemonic in Basic Catalog	N1BDCC
20	TRMDAYS	☐	N1ME_TRMDAYS		INT1	3	0	Preset Treatment Period (Days)
21	TRMSTOP	☐	N1ME_TRMSTOP	XFELD	CHAR	1	0	Indicator Stop After Treatment Period
22	PREVENT	☐	N1ME_PREVENT		INT1	3	0	Event Generation Horizon in Days
23	MEDCLID	☐	N1ME_MEDCLID		CHAR	3	0	ID of Medication Class	TN1MEDCLASS
24	MEDGRPID	☐	N1ME_MEDGRPID		CHAR	3	0	Medication: Drug Category Key	TN1MEDGROUP
25	ADRTIMU	☐	N1ME_ADRTIMU	MEINS	UNIT	3	0	Medication: Unit of Administration Duration	T006
26	ADITIM	☐	N1ME_ADITIM	N1ME_QUAN123	QUAN	12	3	Medication: Administration Duration
27	RECQUAN	☐	N1ME_RECQUAN	N1ME_RECQUAN	QUAN	12	3	Medication: Recipe Quantity
28	RECQUANU	☐	N1ME_RECQUANU	MEINS	UNIT	3	0	Recipe Quantity Unit	T006
29	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
30	MMRESERV	☐	N1ME_MMRESERV	N1ME_MMRESERV	CHAR	1	0	Create MM Reservation for Drug
31	INDISDOS	☐	N1ME_DISCDOS	XFELD	CHAR	1	0	Medication: Indiscreet Dose Indicator
32	DISPPKG	☐	N1ME_DISPPKG	XFELD	CHAR	1	0	Dispense in Package Size Indicator (Pharmacy)
33	ADMPKG	☐	N1ME_ADMPKG	XFELD	CHAR	1	0	Administer in Package Size Indicator (Patient)
34	.INCLUDE	☐				0	0	IS-H*MED: Structure of Table N1BDCC
35	VERSDATE	☐	N1ME_VERSDATE		NUMC	14	0	Medication: Date and Time of Version
36	EXTDCODECAT	☐	N1ME_EXTDCODECAT		CHAR	3	0	ID of Identification System
37	EXTDCODEID	☐	N1ME_EXTDCODEID		CHAR	40	0	Medication: External Drug ID
38	BRANDNAME	☐	N1ME_BRANDNAME		CHAR	60	0	Brand Name
39	GENNAME	☐	N1ME_GENNAME		CHAR	60	0	Generic Name
40	NARCOTIC	☐	N1ME_NARCOTIC	XFELD	CHAR	1	0	Narcotic Indicator
41	PSYCHO	☐	N1ME_PSYCHO	XFELD	CHAR	1	0	Medication: Psychotropic Indicator
42	CONTR	☐	N1ME_CONTR	XFELD	CHAR	1	0	Medication: Controlled Drug Indicator
43	ADMIND	☐	N1ME_ADMIND	XFELD	CHAR	1	0	Medication: Administrable Indicator
44	MONO	☐	N1ME_MONO	XFELD	CHAR	1	0	Medication: Single Ingredient Drug Indicator
45	MANUF	☐	N1ME_MANUF		CHAR	60	0	Manufacturer
46	APDEVID	☐	N1ME_APDEVID		CHAR	3	0	Medication: Administration Device ID	TN1DEVICE
47	APROUTEID	☐	N1ME_ROUTEID		CHAR	3	0	Medication: ID Administration Route	TN1ROUTE
48	PHFORMID	☐	N1ME_PHFORMID		CHAR	3	0	Medication: ID Dosage Form	TN1PHFORM
49	UNIT	☐	N1ME_UNIT	MEINS	UNIT	3	0	Drug Base Unit	T006
50	QUAN	☐	N1ME_QUAN	N1ME_QUAN123	QUAN	12	3	Drug Base Quantity
51	STRGTHU	☐	N1ME_STRGTHU	MEINS	UNIT	3	0	Strength Unit	T006
52	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
53	STRGTHPU	☐	N1ME_STRGTHPU	MEINS	UNIT	3	0	Reference Quantity Unit	T006
54	STRGTHP	☐	N1ME_STRGTHP	N1ME_QUAN123	QUAN	12	3	Reference Quantity
55	PSTRGTH	☐	N1ME_PSTRGTHP	XFELD	CHAR	1	0	Percentage Strength Indicator
56	PKGUNIT	☐	N1ME_PKGUNIT	MEINS	UNIT	3	0	Medication: Package Unit	T006
57	PKGSIZE	☐	N1ME_PKGSIZE	N1ME_QUAN123	QUAN	12	3	Medication: Package Size
58	DEFDOSM	☐	N1ME_DEFDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Standard Individual Dose
59	DEFEXP	☐	N1ME_DEFEXP	N1ME_QUAN123	QUAN	12	3	Medication: Shelf Life
60	DEFEXPTU	☐	N1ME_DEFEXPTU	MEINS	UNIT	3	0	Default Expiry Period Time Unit	T006
61	MAXDOSM	☐	N1ME_MAXDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Individual Dose
62	MAXDOSD	☐	N1ME_MAXDOSD	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Daily Dose
63	MAXDOSL	☐	N1ME_MAXDOSL	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Lifetime Dose
64	CUMDOS	☐	N1ME_CUMDOS	XFELD	CHAR	1	0	Cumulative Dose Indicator
65	FREEZE	☐	N1ME_FREEZE	XFELD	CHAR	1	0	Medication: Freezing Required Indicator
66	REFRIGERATE	☐	N1ME_REFRIGERATE	XFELD	CHAR	1	0	Refrigeration Necessary Indicator
67	MAXTEMP	☐	N1ME_MAXTEMP		QUAN	3	0	Medication: Maximum Storage Temperature
68	MAXTEMP_VAL0	☐	N1ME_VALUE_0	XFELD	CHAR	1	0	Indicator Value 0 (SPACE = No Value/ X = Value 0)
69	MINTEMP	☐	N1ME_MINTEMP		QUAN	3	0	Medication: Minimum Storage Temperature
70	MINTEMP_VAL0	☐	N1ME_VALUE_0	XFELD	CHAR	1	0	Indicator Value 0 (SPACE = No Value/ X = Value 0)
71	TEMPU	☐	N1ME_TEMPU	MEINS	UNIT	3	0	Medication: Temperature Unit	T006
72	MAXDEN	☐	N1ME_MAXDEN		NUMC	1	0	Maximum Denominator for Tablets
73	TIMSEN	☐	N1ME_TIMSEN	N1ME_TIMSEN	CHAR	1	0	Time-Sensitive Drug
74	ADOUTPAT	☐	N1ME_ADOUTPAT	XFELD	CHAR	1	0	Medication: Administration in IP/OC
75	SECWITNESS	☐	N1ME_SECWITNESS	N1ME_SECWITNESS	CHAR	1	0	Medication: Witness Required
76	VFCOIND	☐	N1ME_VFCOIND	XFELD	CHAR	1	0	Check Condition Indicator
77	OUPREP	☐	N1ME_OUPREP	N1ME_OUPREP	CHAR	1	0	Medication: Preparation Fill Source Indicator
78	NOCRUSH	☐	N1ME_NOCRUSH	N1ME_NOCRUSH	CHAR	1	0	Medication: Drug Cannot Be Crushed Indicator
79	OWNMED	☐	N1ME_OWNMED	XFELD	CHAR	1	0	Indicator for Patient's Own Medicine
80	INPATIENT	☐	N1ME_IP_USE	ISH_ON_OFF	CHAR	1	0	Medication: Indicator, Inpatient Use
81	OUTPATIENT	☐	N1ME_OP_USE	ISH_ON_OFF	CHAR	1	0	Medication: Indicator, Outpatient Use
82	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
83	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
84	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
85	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
86	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
87	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
88	DESCRLT	☐	N1ME_DRUGIDDESC	N1ME_TEXT_60	CHAR	60	0	Medication: Drug Description
89	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
90	PHARMSTX	☐	N1ME_PHARMSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Notes for Pharmacist
91	PHARMLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
92	NURSESTX	☐	N1ME_NURSESTX	N1ME_TEXT_80	CHAR	80	0	Medication: Notes for Nursing Staff
93	NURSELTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
94	PHYSICSTX	☐	N1ME_PHYSICSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Notes for Physician
95	PHYSICLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
96	PREPSTX	☐	N1ME_PREPSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Preparation Directions
97	PREPLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
98	HEAD_UPD_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
99	DISPLAY_MODE	☐	ISH_ON_OFF	ISH_ON_OFF	CHAR	1	0	IS-H: Boolscher Datentyp für ON (= 'X') und OFF (=' ')
100	ERROR_KNZ	☐	FLAG	FLAG	CHAR	1	0	General Flag
101	OBJREF	☐	IF_ISHMED_COLLECTION_OBJECT		REF	0	0
102	CELLTAB	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN1FORMMAIN	ADRTIMU	T006	MSEHI
2	RN1FORMMAIN	APDEVID	TN1DEVICE	APDEVID
3	RN1FORMMAIN	APROUTEID	TN1ROUTE	APROUID
4	RN1FORMMAIN	CATID	N1DC	CATID
5	RN1FORMMAIN	CATIDBDC	N1DC	CATID
6	RN1FORMMAIN	DEACT_RC	TN1RCIND	RCODEID	REF
7	RN1FORMMAIN	DEFEXPTU	T006	MSEHI
8	RN1FORMMAIN	DRUGIDBDC	N1BDCC	DRUGIDBDC
9	RN1FORMMAIN	MANDT	T000	MANDT
10	RN1FORMMAIN	MATNR	MARA	MATNR
11	RN1FORMMAIN	MEDCLID	TN1MEDCLASS	MEDCLID	KEY	C	CN
12	RN1FORMMAIN	MEDGRPID	TN1MEDGROUP	MEDGRPID	KEY	C	CN
13	RN1FORMMAIN	PHFORMID	TN1PHFORM	PHFORMID
14	RN1FORMMAIN	PKGUNIT	T006	MSEHI
15	RN1FORMMAIN	RCDEACT	TN1RCODE	RCODEID
16	RN1FORMMAIN	RECQUANU	T006	MSEHI
17	RN1FORMMAIN	STRGTHPU	T006	MSEHI
18	RN1FORMMAIN	STRGTHU	T006	MSEHI
19	RN1FORMMAIN	TEMPU	T006	MSEHI
20	RN1FORMMAIN	UNIT	T006	MSEHI

History

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