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 | |||
|---|---|---|---|---|---|---|---|---|
| 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 | BNAME | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| USGRP_USER | BNAME | USGRP_USER | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| 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 |
