SAP ABAP Table N1TPUSERA (Medication: Order Template / Group Assignment to User)

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	N1TPUSERA	Table Relationship Diagram
Short Description	Medication: Order Template / Group Assignment to User

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	UNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
3	TPID	☑	N1ME_TPID	N1ME_TPID	CHAR	10	0	Template ID	N1TPMEORDER
4	TPGID	☑	N1ME_TPGID	N1ME_TPGID	CHAR	10	0	Template Group Identification	N1TPGROUP
5	SEQNO	☐	N1ME_SEQNO	N1ME_SEQNR	NUMC	3	0	Medication: Sequence Number
6	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
7	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
8	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
9	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
10	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
11	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	N1TPUSERA	MANDT	T000	MANDT
2	N1TPUSERA	TPGID	N1TPGROUP	TPGID
3	N1TPUSERA	TPID	N1TPMEORDER	TPID
4	N1TPUSERA	UNAME	USR02	BNAME

History

Last changed by/on	SAP	20110901
SAP Release Created in	473