SAP ABAP Table N1ME_FORMULARY_ITEM (IS-H*MED: Drug of Therapeutic Class)

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	N1ME_FORMULARY_ITEM	Table Relationship Diagram
Short Description	IS-H*MED: Drug of Therapeutic Class

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

History

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