SAP table USLA04 (CUA: Assignment of Users to Roles)

SAP table USLA04 has 6 primary key fields being MANDT,BNAME,SUBSYSTEM,AGR_NAME,FROM_DAT,TO_DAT.

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 USZBVSYS XUBNAME
SUBSYSTEM Receiving system for central user administration CHAR 10 0 USZBVLNDRC RFCRCVSYS
AGR_NAME Name of role in distribution model CHAR 30 0 USRSYSACT F_AGR_NAME
FROM_DAT Date of validity DATS 8 0 AGR_FDATE
TO_DAT Date of validity DATS 8 0 AGR_TDATE
ORG_FLAG Indicator: Indirect Assignment of the User to the Role CHAR 1 0 AGR_ORGCOL
Direct Assignment
C Assignment Comes From Composite Role
E Enterprise Portal Rolle
X Assignment Comes From HR Organization Managemnt

USLA04 foreign key relationships

Table Field Check Table Check Field
0 USLA04 AGR_NAME USRSYSACT CUA: Roles in Distributed Systems AGR_NAME
1 USLA04 BNAME USZBVSYS CUA: Assignment of Systems to Users BNAME
1 USLA04 BNAME USZBVSYS CUA: Assignment of Systems to Users USRSECTION