SAP ABAP Table N1FORMULARY (Medication: Drug Formulary)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ NMED_ME (Package) IS-H*MED: Medication

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N1FORMULARY	Table Relationship Diagram
Short Description	Medication: Drug Formulary

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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

History

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