SAP Table USGRP_USER
Assignment of Users to User Groups
USGRP_USER (Assignment of Users to User Groups) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link USGRP_USER to other SAP tables.
USGRP_USER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
BNAME
User Name in User Master Record
|
XUBNAME | USR02 |
CHAR
|
12 | 0 | |
|
USERGROUP
User group in user master maintenance
|
XUCLASS | USGRP |
CHAR
|
12 | 0 | |
|
FROM_DAT
Date of validity
|
AGR_FDATE |
DATS
|
8 | 0 | ||
|
TO_DAT
Date of validity
|
AGR_TDATE |
DATS
|
8 | 0 | ||
|
ORGFLAG
Flag: Assignment Comes From HR Organization Management
|
AGR_ORG |
CHAR
|
1 | 0 |
USGRP_USER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| USGRP_USER | BNAME | USGRP_USER | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| USGRP_USER | BNAME | USGRP_USER | BNAME |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| USGRP_USER | MANDT | USGRP_USER | MANDT |
T000
Clients
|
MANDT |
| USGRP_USER | USERGROUP | USGRP_USER | MANDT |
USGRP
User Groups
|
MANDT |
| USGRP_USER | USERGROUP | USGRP_USER | USERGROUP |
USGRP
User Groups
|
USERGROUP |