SAP ABAP Table RN1ME_STR_EXP_FORMULARY (IS-H*MED: Medication : Display Drug to Be Exported)

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_STR_EXP_FORMULARY	Table Relationship Diagram
Short Description	IS-H*MED: Medication : Display Drug to Be Exported

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

History

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