SAP ABAP Table N1FOAGENTA (IS-H*MED: Agents - Drugs 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	TRANSP	Transparent table
Transparent table	N1FOAGENTA	Table Relationship Diagram
Short Description	IS-H*MED: Agents - Drugs Assignment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DRUGID	☑	N1ME_DRUGID	SYSUUID_C	CHAR	32	0	Medication: Drug ID	N1FORMULARY
3	AGENTID	☑	N1ME_AGENTID	SYSUUID_C	CHAR	32	0	Medication: Agent ID	NAGENT
4	AGENTROLE	☐	N1ME_AGROLE	N1ME_AGROLE	CHAR	1	0	Medication: Agent Type
5	UNIT	☐	N1ME_UNIT	MEINS	UNIT	3	0	Drug Base Unit	T006
6	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
7	QUANT	☐	N1ME_QUANT	N1ME_QUAN123	QUAN	12	3	Quantity of Assigned Agent or Drug
8	QUANTU	☐	N1ME_QUANTU	MEINS	UNIT	3	0	Unit of Measure of Agent of Drug	T006
9	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
10	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
11	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
12	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
13	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
14	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	N1FOAGENTA	AGENTID	NAGENT	AGENTID
2	N1FOAGENTA	DRUGID	N1FORMULARY	DRUGID
3	N1FOAGENTA	MANDT	T000	MANDT
4	N1FOAGENTA	QUANTU	T006	MSEHI
5	N1FOAGENTA	UNIT	T006	MSEHI

History

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