SAP USR02 table - Logon Data (Kernel-Side Use) details in SAP


SAP USR02 table summary

Object Name: USR02
Dictionary Type: Transparent table
Description: Logon Data (Kernel-Side Use)


Field list for USR02 table on an S/4 SAP system

Details
USR02-MANDT table field - Client

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

USR02-BNAME table field - User Name in User Master Record

Description: User Name in User Master Record
Field Name: BNAME
Data Element: XUBNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: XUBNAME
MemoryID: XUS
AppClass: SUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BNAME

USR02-BCODE table field - Password Hash Key

Description: Password Hash Key
Field Name: BCODE
Data Element: XUCODE
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: XUCODE
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BCODE

USR02-GLTGV table field - User valid from

Description: User valid from
Field Name: GLTGV
Data Element: XUGLTGV
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GLTGV

USR02-GLTGB table field - User valid to

Description: User valid to
Field Name: GLTGB
Data Element: XUGLTGB
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GLTGB

USR02-USTYP table field - User Type

Description: User Type
Field Name: USTYP
Data Element: XUUSTYP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine: USTYP
Domain Name: XUUSTYP
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit: USTYP

See all SAP tables containing field USTYP

USR02-CLASS table field - User group in user master maintenance

Description: User group in user master maintenance
Field Name: CLASS
Data Element: XUCLASS
Data Type: CHAR
length (Dec): 12(0)
Check table: USGRP
Conversion Routine:
Domain Name: XUCLASS
MemoryID: XUG
AppClass: SUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLASS

USR02-LOCNT table field - Number of failed logon attempts

Description: Number of failed logon attempts
Field Name: LOCNT
Data Element: XULOCNT
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: XULOCNT
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCNT

USR02-UFLAG table field - User Lock Status

Description: User Lock Status
Field Name: UFLAG
Data Element: XUUFLAG
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: XUUFLAG
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UFLAG

USR02-ACCNT table field - Account ID

Description: Account ID
Field Name: ACCNT
Data Element: XUACCNT
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: XUACCNT
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCNT

USR02-ANAME table field - Creator of the User Master Record

Description: Creator of the User Master Record
Field Name: ANAME
Data Element: XUANAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: BNAME
MemoryID:
AppClass: SUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANAME

USR02-ERDAT table field - Creation Date of the User Master Record

Description: Creation Date of the User Master Record
Field Name: ERDAT
Data Element: XUERDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERDAT

USR02-TRDAT table field - Last Logon Date

Description: Last Logon Date
Field Name: TRDAT
Data Element: XULDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRDAT

USR02-LTIME table field - Last Logon Time

Description: Last Logon Time
Field Name: LTIME
Data Element: XULTIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LTIME

USR02-OCOD1 table field - Password Hash Key

Description: Password Hash Key
Field Name: OCOD1
Data Element: XUCODE
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: XUCODE
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCOD1

USR02-BCDA1 table field - Date of Last Password Change

Description: Date of Last Password Change
Field Name: BCDA1
Data Element: XUBCDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BCDA1

USR02-CODV1 table field - Code Version of Password Hash Algorithm (Old Systems)

Description: Code Version of Password Hash Algorithm (Old Systems)
Field Name: CODV1
Data Element: XUCODEVERS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XUCODEVERS
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CODV1

USR02-OCOD2 table field - Password Hash Key

Description: Password Hash Key
Field Name: OCOD2
Data Element: XUCODE
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: XUCODE
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCOD2

USR02-BCDA2 table field - Date of Last Password Change

Description: Date of Last Password Change
Field Name: BCDA2
Data Element: XUBCDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BCDA2

USR02-CODV2 table field - Code Version of Password Hash Algorithm (Old Systems)

Description: Code Version of Password Hash Algorithm (Old Systems)
Field Name: CODV2
Data Element: XUCODEVERS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XUCODEVERS
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CODV2

USR02-OCOD3 table field - Password Hash Key

Description: Password Hash Key
Field Name: OCOD3
Data Element: XUCODE
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: XUCODE
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCOD3

USR02-BCDA3 table field - Date of Last Password Change

Description: Date of Last Password Change
Field Name: BCDA3
Data Element: XUBCDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BCDA3

USR02-CODV3 table field - Code Version of Password Hash Algorithm (Old Systems)

Description: Code Version of Password Hash Algorithm (Old Systems)
Field Name: CODV3
Data Element: XUCODEVERS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XUCODEVERS
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CODV3

USR02-OCOD4 table field - Password Hash Key

Description: Password Hash Key
Field Name: OCOD4
Data Element: XUCODE
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: XUCODE
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCOD4

USR02-BCDA4 table field - Date of Last Password Change

Description: Date of Last Password Change
Field Name: BCDA4
Data Element: XUBCDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BCDA4

USR02-CODV4 table field - Code Version of Password Hash Algorithm (Old Systems)

Description: Code Version of Password Hash Algorithm (Old Systems)
Field Name: CODV4
Data Element: XUCODEVERS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XUCODEVERS
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CODV4

USR02-OCOD5 table field - Password Hash Key

Description: Password Hash Key
Field Name: OCOD5
Data Element: XUCODE
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: XUCODE
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCOD5

USR02-BCDA5 table field - Date of Last Password Change

Description: Date of Last Password Change
Field Name: BCDA5
Data Element: XUBCDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BCDA5

USR02-CODV5 table field - Code Version of Password Hash Algorithm (Old Systems)

Description: Code Version of Password Hash Algorithm (Old Systems)
Field Name: CODV5
Data Element: XUCODEVERS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XUCODEVERS
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CODV5

USR02-VERSN table field - User master record version

Description: User master record version
Field Name: VERSN
Data Element: XUVERSION
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: XUVERSION
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VERSN

USR02-CODVN table field - Code Version of Password Hash Algorithm (New Systems)

Description: Code Version of Password Hash Algorithm (New Systems)
Field Name: CODVN
Data Element: XUCODEVER2
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XUCODEVER2
MemoryID:
AppClass: XUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CODVN

USR02-TZONE table field - Time Zone

Description: Time Zone
Field Name: TZONE
Data Element: TZNZONE
Data Type: CHAR
length (Dec): 6(0)
Check table: TTZZ
Conversion Routine:
Domain Name: TZNZONE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TZONE

USR02-ZBVMASTER table field - CUA User Template: Logon Not Possible Here

Description: CUA User Template: Logon Not Possible Here
Field Name: ZBVMASTER
Data Element: XUZBVFLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SAP_BOOL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZBVMASTER

USR02-PASSCODE table field - Password Hash Value (SHA1, 160 Bit)

Description: Password Hash Value (SHA1, 160 Bit)
Field Name: PASSCODE
Data Element: PWD_SHA1
Data Type: RAW
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: SHA1_HASH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PASSCODE

USR02-PWDCHGDATE table field - Date of Last Password Change

Description: Date of Last Password Change
Field Name: PWDCHGDATE
Data Element: XUBCDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDCHGDATE

USR02-PWDSTATE table field - Password Change: Required / Allowed / Not Possible

Description: Password Change: Required / Allowed / Not Possible
Field Name: PWDSTATE
Data Element: PWDCHGSTATE
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: PWDCHGSTATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDSTATE

USR02-RESERVED table field - CUA Control Information

Description: CUA Control Information
Field Name: RESERVED
Data Element: XUCUACNTL
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: XUCUACNTL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESERVED

USR02-PWDHISTORY table field - Indicator: Password History Stored in Table USRPWDHISTORY

Description: Indicator: Password History Stored in Table USRPWDHISTORY
Field Name: PWDHISTORY
Data Element: XUPWDHIST
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: IBOOLEAN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDHISTORY

USR02-PWDLGNDATE table field - Date of Last Password Logon

Description: Date of Last Password Logon
Field Name: PWDLGNDATE
Data Element: XULPDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDLGNDATE

USR02-PWDSETDATE table field - Date: Password Reset by Administrator

Description: Date: Password Reset by Administrator
Field Name: PWDSETDATE
Data Element: XUSPDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDSETDATE

USR02-PWDINITIAL table field - Indicator: Password Is Initial (= Set by Administrator)

Description: Indicator: Password Is Initial (= Set by Administrator)
Field Name: PWDINITIAL
Data Element: XUPWDINIT
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: IBOOLEAN3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDINITIAL

USR02-PWDLOCKDATE table field - Date: Setting of Password Lock

Description: Date: Setting of Password Lock
Field Name: PWDLOCKDATE
Data Element: XUPLDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDLOCKDATE

USR02-PWDSALTEDHASH table field - Password Hash Value (Various Algorithms and Codings)

Description: Password Hash Value (Various Algorithms and Codings)
Field Name: PWDSALTEDHASH
Data Element: PWD_HASH_STRING
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: PWD_HASH_STRING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWDSALTEDHASH

USR02-SECURITY_POLICY table field - Security Policy Name

Description: Security Policy Name
Field Name: SECURITY_POLICY
Data Element: SECURITY_POLICY_NAME
Data Type: CHAR
length (Dec): 40(0)
Check table: SEC_POLICY_CUST
Conversion Routine:
Domain Name: SECURITY_POLICY_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SECURITY_POLICY


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table