SAP ABAP Table USREXTID (Assignment of External ID to Users)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-SNC (Application Component) Secure Network Communications
     ⤷ SECN (Package) SNC Secure Network Communication

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	USREXTID	Table Relationship Diagram
Short Description	Assignment of External ID to Users

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	TYPE	☑	EXTID_TYPE	EXTID_TYPE	CHAR	2	0	External ID type	USREXTIDT
3	EXTID	☑	EXTID	EXTID	CHAR	112	0	External ID (plain text or hash value)
4	SEQNO	☑	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
5	BNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
6	DATEMIN	☐	DATEMIN	DATUM	DATS	8	0	Min. date permitted for the validity of certificate
7	STATUS	☐	EXTIDSTAT	CHAR1_X	CHAR	1	0	Status of entry for external ID
8	HASHEXTID	☐	HASHEXTID	CHAR1_X	CHAR	1	0	Switch: External ID exists as a hash value
9	EXTIDH	☐	EXTID_HASH	EXTID_HASH	CHAR	32	0	Hash value for external ID	USREXTIDH
10	.INCLUDE	☐				0	0	Modification fields
11	CNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
12	CDATE	☐	XUMODDATE	DATUM	DATS	8	0	Modification date
13	CTIME	☐	XUMODTIME	UZEIT	TIMS	6	0	Modification time
14	MNAME	☐	XUMODIFIER	BNAME	CHAR	12	0	Last Changed By
15	MDATE	☐	XUMODDATE	DATUM	DATS	8	0	Modification date
16	MTIME	☐	XUMODTIME	UZEIT	TIMS	6	0	Modification time
17	.INCLUDE	☐				0	0	Validity check
18	VALITYINFO	☐			RAW	16	0
19	VERSION	☐			INT1	3	0
20	ISSUERH	☐	EXTID_HASH	EXTID_HASH	CHAR	32	0	Hash value for external ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USREXTID	BNAME	USR02	BNAME	KEY	1	CN
2	USREXTID	EXTIDH	USREXTIDH	EXTIDH	KEY	1	CN
3	USREXTID	MANDT	T000	MANDT	KEY	1	CN
4	USREXTID	TYPE	USREXTIDT	EXTID_TYPE	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in