SAP ABAP Table N1FORMULARYT (Medication: Drug Formulary - Texts)

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	N1FORMULARYT	Table Relationship Diagram
Short Description	Medication: Drug Formulary - Texts

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	N1FORMULARY
3	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
4	DRUGNAME	☐	N1ME_DRUGNAME		CHAR	20	0	Mnemonic (Drug Name)
5	DESCRLT	☐	N1ME_DRUGIDDESC	N1ME_TEXT_60	CHAR	60	0	Medication: Drug Description
6	PHARMSTX	☐	N1ME_PHARMSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Notes for Pharmacist
7	PHARMLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
8	NURSESTX	☐	N1ME_NURSESTX	N1ME_TEXT_80	CHAR	80	0	Medication: Notes for Nursing Staff
9	NURSELTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
10	PHYSICSTX	☐	N1ME_PHYSICSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Notes for Physician
11	PHYSICLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
12	PREPSTX	☐	N1ME_PREPSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Preparation Directions
13	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	N1FORMULARYT	DRUGID	N1FORMULARY	DRUGID	TEXT	1	CN
2	N1FORMULARYT	MANDT	T000	MANDT	KEY
3	N1FORMULARYT	SPRAS	T002	SPRAS	KEY

History

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