SAP ABAP View V_N1FORMULARY (IS-H*MED: Medication; View of N1FORMULARY, N1FORMULARYT)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_N1FORMULARY
Short Description	IS-H*MED: Medication; View of N1FORMULARY, N1FORMULARYT
Root table	N1FORMULARY	Medication: Drug Formulary

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	N1FORMULARY	N1FORMULARY
2	N1FORMULARYT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	N1FORMULARY	MANDT	JL	EQ				0	0
2	N1FORMULARYT	MANDT	JR	EQ			AND	0	0
3	N1FORMULARY	DRUGID	JL	EQ				0	0
4	N1FORMULARYT	DRUGID	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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