SAP ABAP Table H_AGENT_MED (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	H_AGENT_MED	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	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	AGTYPE	☐	N1ME_AGTYPE	N1ME_AGTYPE	CHAR	3	0	Agent Type
5	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
6	AGENT	☐	N1ME_AGENT		CHAR	80	0	Medication: Agent Name
7	DESCR	☐	N1ME_AGENTDESC	N1ME_TEXT_60	CHAR	60	0	Medication: Agent Description
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	NARCOTIC	☐	N1ME_NARCOTIC	XFELD	CHAR	1	0	Narcotic Indicator
10	PSYCHO	☐	N1ME_PSYCHO	XFELD	CHAR	1	0	Medication: Psychotropic Indicator
11	CONTR	☐	N1ME_CONTR	XFELD	CHAR	1	0	Medication: Controlled Drug Indicator
12	MONO	☐	N1ME_MONO	XFELD	CHAR	1	0	Medication: Single Ingredient Drug Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	H_AGENT_MED	AGENTID	NAGENT	AGENTID
2	H_AGENT_MED	DRUGID	N1FORMULARY	DRUGID
3	H_AGENT_MED	MANDT	T000	MANDT
4	H_AGENT_MED	MATNR	MARA	MATNR
5	H_AGENT_MED	SPRAS	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in