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

Foreign Keys

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

History

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