SAP ABAP Table V_N1FORMULARY (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_N1FORMULARY	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components


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