SAP ABAP Table RN1FOTHCLA_ALV (IS-H*MED: Drug - Therapeutic Classes 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	RN1FOTHCLA_ALV	Table Relationship Diagram
Short Description	IS-H*MED: Drug - Therapeutic Classes 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	.INCLUDE	☐				0	0	Medication: Therapeutic Class Assignment - Drugs
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	CLASSSYS	☐	N1ME_CLASSSYS		CHAR	3	0	Classification System	TNTHSYS
4	THCLASSID	☐	N1ME_THCLID	N1ME_THCLID	CHAR	15	0	Medication: Internal Key of Therapeutic Class	TNTHCLASS
5	DRUGID	☐	N1ME_DRUGID	SYSUUID_C	CHAR	32	0	Medication: Drug ID	N1FORMULARY
6	SEQNO	☐	N1ME_SEQNO	N1ME_SEQNR	NUMC	3	0	Medication: Sequence Number
7	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
8	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
9	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
10	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
11	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
12	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
13	THCLASS	☐	N1ME_THCL		CHAR	15	0	Therapeutic Class
14	DESCR	☐	N1ME_THCLD	N1ME_THCLD	CHAR	60	0	Medication: Therapeutic Class Description
15	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN1FOTHCLA_ALV	CLASSSYS	TNTHSYS	CLASSSYS	KEY
2	RN1FOTHCLA_ALV	DRUGID	N1FORMULARY	DRUGID
3	RN1FOTHCLA_ALV	MANDT	T000	MANDT
4	RN1FOTHCLA_ALV	THCLASSID	TNTHCLASS	THCLASSID

History

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