SAP table USZBVSYS (CUA: Assignment of Systems to Users)

SAP table USZBVSYS has 4 primary key fields being MANDT,BNAME,USRSECTION,SUBSYSTEM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
BNAME User Name in User Master Record CHAR 12 0 USR02 XUBNAME
USRSECTION BAPI method for central user administration CHAR 10 0 USRSECTION
ACTGRP Assignment of roles
PROFILE Assignment of user profiles
USER Copy of user data
SUBSYSTEM Receiving system for central user administration CHAR 10 0 TBDLS RFCRCVSYS
STATUS User status in the system CHAR 1 0 USRSTATUS
A System call to delete launched (UNCONFIRMED)
D System assignment of user deleted (SUCCESS)
E Created/changed with errors (ERROR)
F Error when deleting (ERROR)
G Applied from child system (SUCCESS)
L Child system: Local user (usrsection 'USER')
N New system assignment (UNCONFIRMED)
O System call to create/change launched (UNCONFIRMED)
S Created/changed (SUCCESS)
W Created/changed with warnings (WARNING)
X Flagged for deletion (used only at runtime, not in DB)
MODDATE Date DATS 8 0 DATUM
MODTIME Time TIMS 6 0 UZEIT
MODIFIER User Name CHAR 12 0 UNAME
DOCNUM_OUT IDoc number NUMC 16 0 EDI_DOCNUM

USZBVSYS foreign key relationships

Table Field Check Table Check Field
0 USZBVSYS BNAME USR02 Logon Data (Kernel-Side Use) BNAME
1 USZBVSYS SUBSYSTEM TBDLS Logical system LOGSYS