SAP ABAP Table TN2USRMA (IS-H*MED: Assignment of SAP user ID to employee)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NMED (Package) R/3MED: Medical documentation GSD

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TN2USRMA	Table Relationship Diagram
Short Description	IS-H*MED: Assignment of SAP user ID to employee

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MAND	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	UNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
3	MITARB	☑	N1MITARB	RI_KUNNR	CHAR	10	0	Employee Responsible	NGPA
4	BEGDT	☑	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
5	ENDDT	☐	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
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	TN2USRMA	MAND	T000	MANDT	KEY	1	CN
2	TN2USRMA	MITARB	NGPA	GPART	KEY	1	CN
3	TN2USRMA	UNAME	USR02	BNAME	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in