Tuesday, August 12, 2014

USR02 SAP Table - Logon Data

FieldData ElementData TypelengthChecktableDescription
MANDTMANDTCLNT000003*Client
BNAMEXUBNAMECHAR000012User
BCODEXUCODERAW000008Initial password
GLTGVXUGLTGVDATS000008Valid from
GLTGBXUGLTGBDATS000008Valid through
USTYPXUUSTYPCHAR000001User Type
CLASSXUCLASSCHAR000012USGRPUser group
LOCNTXULOCNTINT1000003Number of failed logon attempts
UFLAGXUUFLAGINT1000003User Lock Status
ACCNTXUACCNTCHAR000012Account number
ANAMEXUANAMECHAR000012Creator of User Master Record
ERDATXUERDATDATS000008Creation Date of User Master
TRDATXULDATEDATS000008Last Logon Date
LTIMEXULTIMETIMS000006Last Logon Time
OCOD1XUCODERAW000008Initial password
BCDA1XUBCDATDATS000008Date of Last Password Change
CODV1XUCODEVERSCHAR000001Password Code Vers.
OCOD2XUCODERAW000008Initial password
BCDA2XUBCDATDATS000008Date of Last Password Change
CODV2XUCODEVERSCHAR000001Password Code Vers.
OCOD3XUCODERAW000008Initial password
BCDA3XUBCDATDATS000008Date of Last Password Change
CODV3XUCODEVERSCHAR000001Password Code Vers.
OCOD4XUCODERAW000008Initial password
BCDA4XUBCDATDATS000008Date of Last Password Change
CODV4XUCODEVERSCHAR000001Password Code Vers.
OCOD5XUCODERAW000008Initial password
BCDA5XUBCDATDATS000008Date of Last Password Change
CODV5XUCODEVERSCHAR000001Password Code Vers.
VERSNXUVERSIONCHAR000003
CODVNXUCODEVER2CHAR000001Password Code Vers.
TZONETZNZONECHAR000006TTZZTime Zone
PASSCODEPWD_SHA1RAW000020Password Hash Val.(SAH1, 160 Bit)
PWDCHGDATEXUBCDATDATS000008Date of Last Password Change
PWDHISTORYXUPWDHISTINT1000003External Password History(USRPWDHISTORY)
PWDLGNDATEXULPDATDATS000008Date of Last Password Logon
PWDSETDATEXUSPDATDATS000008Date: Password Reset by Administrator
PWDINITIALXUPWDINITINT1000003Indicator: Password Is Initial
PWDLOCKDATEXUPLDATDATS000008Date: Password Lock
PWDSALTEDHASHPWD_HASH_STRINGCHAR000255Password Hash Value