SAP ABAP Table USH02 (Change history for logon data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-LGN (Application Component) Authentication and SSO
     ⤷ SUSR_KRN (Package) User Administration Tables Used Kernel-Side

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	USH02	Table Relationship Diagram
Short Description	Change history for logon data

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	*
2	BNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
3	MODDA	☑	XUMODDATE	DATUM	DATS	8	0	Modification date
4	MODTI	☑	XUMODTIME	UZEIT	TIMS	6	0	Modification time
5	MODBE	☐	XUMODIFIER	BNAME	CHAR	12	0	Last Changed By
6	TCODE	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
7	REPID	☐	REPID	PROGNAME	CHAR	40	0	ABAP Program Name
8	BCODE	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
9	GLTGV	☐	XUGLTGV	DATUM	DATS	8	0	User valid from
10	GLTGB	☐	XUGLTGB	DATUM	DATS	8	0	User valid to
11	USTYP	☐	XUUSTYP	XUUSTYP	CHAR	1	0	User Type
12	CLASS	☐	XUCLASS	XUCLASS	CHAR	12	0	User group in user master maintenance	*
13	UFLAG	☐	XUUFLAG	XUUFLAG	INT1	3	0	User Lock Status
14	ACCNT	☐	XUACCNT	XUACCNT	CHAR	12	0	Account ID
15	PASSCODE	☐	PWD_SHA1	SHA1_HASH	RAW	20	0	Password Hash Value (SHA1, 160 Bit)
16	CODVN	☐	XUCODEVER2	XUCODEVER2	CHAR	1	0	Code Version of Password Hash Algorithm (New Systems)
17	PWDINITIAL	☐	XUPWDINIT	IBOOLEAN3	INT1	3	0	Indicator: Password Is Initial (= Set by Administrator)
18	PWDSALTEDHASH	☐	PWD_HASH_STRING	PWD_HASH_STRING	CHAR	255	0	Password Hash Value (Various Algorithms and Codings)
19	SECURITY_POLICY	☐	SECURITY_POLICY_NAME	SECURITY_POLICY_NAME	CHAR	40	0	Security Policy Name	SEC_POLICY_CUST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USH02	SECURITY_POLICY	SEC_POLICY_CUST	NAME

History

Last changed by/on	SAP	20110908
SAP Release Created in