SAP-tabelreferentie

USR02

Logon Data (Kernel-Side Use)

Bekijk een andere tabel

Vul een tabelcode of zoekwoord in om verder te zoeken.

SAP table USR02 is a critical system table used to store logon-related data for user accounts within the SAP system. It includes information such as user statuses, failed logon attempts, password hash data, password change timestamps, and lock statuses. This table is primarily utilized by the SAP kernel to manage and secure user authentication and access. Due to its sensitive nature, access to USR02 should be restricted to authorized administrators.

SAP-tabel USR02 heeft 2 primaire sleutelvelden: MANDT,BNAME.

Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.

/ Velden

USR02 velden.

44 velden
VeldOmschrijvingDatatypeLengteDecimalenChecktabelData-element
Sleutel MANDT ClientCLNT30 * MANDT
Sleutel BNAME User Name in User Master RecordCHAR120 XUBNAME
BCODE Password Hash KeyRAW80 XUCODE
GLTGV User valid fromDATS80 XUGLTGV
GLTGB User valid toDATS80 XUGLTGB
USTYP User TypeCHAR10 XUUSTYP
CLASS User group in user master maintenanceCHAR120 USGRP XUCLASS
LOCNT Number of failed logon attemptsINT130 XULOCNT
UFLAG User Lock StatusINT130 XUUFLAG
ACCNT Account IDCHAR120 XUACCNT
ANAME Creator of the User Master RecordCHAR120 XUANAME
ERDAT Creation Date of the User Master RecordDATS80 XUERDAT
TRDAT Last Logon DateDATS80 XULDATE
LTIME Last Logon TimeTIMS60 XULTIME
OCOD1 Password Hash KeyRAW80 XUCODE
BCDA1 Date of Last Password ChangeDATS80 XUBCDAT
CODV1 Code Version of Password Hash Algorithm (Old Systems)CHAR10 XUCODEVERS
OCOD2 Password Hash KeyRAW80 XUCODE
BCDA2 Date of Last Password ChangeDATS80 XUBCDAT
CODV2 Code Version of Password Hash Algorithm (Old Systems)CHAR10 XUCODEVERS
OCOD3 Password Hash KeyRAW80 XUCODE
BCDA3 Date of Last Password ChangeDATS80 XUBCDAT
CODV3 Code Version of Password Hash Algorithm (Old Systems)CHAR10 XUCODEVERS
OCOD4 Password Hash KeyRAW80 XUCODE
BCDA4 Date of Last Password ChangeDATS80 XUBCDAT
CODV4 Code Version of Password Hash Algorithm (Old Systems)CHAR10 XUCODEVERS
OCOD5 Password Hash KeyRAW80 XUCODE
BCDA5 Date of Last Password ChangeDATS80 XUBCDAT
CODV5 Code Version of Password Hash Algorithm (Old Systems)CHAR10 XUCODEVERS
VERSN User master record versionCHAR30 XUVERSION
CODVN Code Version of Password Hash Algorithm (New Systems)CHAR10 XUCODEVER2
TZONE Time ZoneCHAR60 TTZZ TZNZONE
ZBVMASTER CUA User Template: Logon Not Possible HereCHAR10 XUZBVFLAG
PASSCODE Password Hash Value (SHA1, 160 Bit)RAW200 PWD_SHA1
PWDCHGDATE Date of Last Password ChangeDATS80 XUBCDAT
PWDSTATE Password Change: Required / Allowed / Not PossibleINT130 PWDCHGSTATE
RESERVED CUA Control InformationINT130 XUCUACNTL
PWDHISTORY Indicator: Password History Stored in Table USRPWDHISTORYINT130 XUPWDHIST
PWDLGNDATE Date of Last Password LogonDATS80 XULPDAT
PWDSETDATE Date: Password Reset by AdministratorDATS80 XUSPDAT
PWDINITIAL Indicator: Password Is Initial (= Set by Administrator)INT130 XUPWDINIT
PWDLOCKDATE Date: Setting of Password LockDATS80 XUPLDAT
PWDSALTEDHASH Password Hash Value (Various Algorithms and Codings)CHAR2550 PWD_HASH_STRING
SECURITY_POLICY Security Policy NameCHAR400 SEC_POLICY_CUST SECURITY_POLICY_NAME
/ Relaties

USR02 relaties.

5 relaties
TabelVeldChecktabelOmschrijvingCheckveld
USR02CLASSUSGRPUser GroupsMANDT
USR02CLASSUSGRPUser GroupsUSERGROUP
USR02SECURITY_POLICYSEC_POLICY_CUSTConfiguration of Security PoliciesCLIENT
USR02SECURITY_POLICYSEC_POLICY_CUSTConfiguration of Security PoliciesNAME
USR02TZONETTZZTime zonesTZONE
Terug naar SAP-tabellen