SAP ABAP Table RN1FOFOA_ALV (IS-H*MED: Ingredient - Drug Group Assignment)

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	RN1FOFOA_ALV	Table Relationship Diagram
Short Description	IS-H*MED: Ingredient - Drug Group Assignment

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	DRUGNAME	☐	N1ME_DRUGNAME		CHAR	20	0	Mnemonic (Drug Name)
2	DESCR	☐	N1ME_DRUGIDDESC	N1ME_TEXT_60	CHAR	60	0	Medication: Drug Description
3	DRUGTYP_LIST	☐	N1ME_MDRUGTYP_LIST	N1ME_TEXT_60	CHAR	60	0	Medication: Type of Ingredient
4	.INCLUDE	☐				0	0	IS-H*MED: Ingredient - Composite Drug Assignment
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	GROUPDRUG	☐	N1ME_GROUPDRUG	SYSUUID_C	CHAR	32	0	Mnemonic of Composite Drug	N1FORMULARY
7	INGDRUG	☐	N1ME_INGDRUG	SYSUUID_C	CHAR	32	0	Medication: Ingredient	N1FORMULARY
8	DRUGTYP	☐	N1ME_MDRUGTYP	N1ME_MDRUGTYP	CHAR	1	0	Type of Ingredient in Medication Group
9	UNIT	☐	N1ME_UNIT	MEINS	UNIT	3	0	Drug Base Unit	T006
10	QUANT	☐	N1ME_QUANT	N1ME_QUAN123	QUAN	12	3	Quantity of Assigned Agent or Drug
11	STUNIT	☐	N1ME_STRGTHU	MEINS	UNIT	3	0	Strength Unit	T006
12	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
13	CALCUD	☐	N1ME_CALCUD	N1ME_CALCUD	CHAR	1	0	Medication: Order - Calculation Method
14	CALCUDU	☐	N1ME_CMU	MEINS	UNIT	3	0	Medication: Order - Calculation Method Unit	*
15	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
16	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
17	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
18	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
19	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
20	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
21	DRUGTYPE_HANDLE	☐			INT4	10	0
22	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
23	CELLTAB	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN1FOFOA_ALV	GROUPDRUG	N1FORMULARY	DRUGID
2	RN1FOFOA_ALV	INGDRUG	N1FORMULARY	DRUGID
3	RN1FOFOA_ALV	MANDT	T000	MANDT
4	RN1FOFOA_ALV	STUNIT	T006	MSEHI
5	RN1FOFOA_ALV	UNIT	T006	MSEHI

History

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