SAP User Administration Tables
Are you looking for the right table related to SAP User Administration Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in User Administration (BC-SEC-USR) module.
Top 10 tables in User Administration
| Table | Description |
|---|---|
| BFUSER_TYP | Obsolete: Valid Object Types for Internet Users |
| WP3ROLESRVLONG | Long Service IDs |
| WP3ROLESRV | Portal Roles: Services |
| SMUM_ACL | Valid sender information |
| BBPORGF4 | F4 for User Assignment - Organizational Units for BBP |
| BAPIUSW01 | User ID Table for Internet Appplication Components |
| SMUM_ERDEC | SMUM error description |
| USR30 | Additional Information for User Menu |
| SMUM_MAP | SAP-C1 mapping table |
| WP3ROLEUSRH | Portal Roles: User Assignments Header |
List of tables in User Administration
| Table | Description |
|---|---|
| BFUSER_TYP | Obsolete: Valid Object Types for Internet Users |
| WP3ROLESRVLONG | Long Service IDs |
| WP3ROLESRV | Portal Roles: Services |
| SMUM_ACL | Valid sender information |
| BBPORGF4 | F4 for User Assignment - Organizational Units for BBP |
| BAPIUSW01 | User ID Table for Internet Appplication Components |
| SMUM_ERDEC | SMUM error description |
| USR30 | Additional Information for User Menu |
| SMUM_MAP | SAP-C1 mapping table |
| WP3ROLEUSRH | Portal Roles: User Assignments Header |
| WP3ROLESYS | Portal Roles: Responsibilities |
| WP3ROLEDEFT | Portal Roles: Short and Long Texts |
| BUS_USER01 | Business User |
| BAPIUSW02 | Modification log for Internet UID table |
| USR08 | Table for user menu entries |
| WP3ROLEDEF | Portal Roles: Definition |
| BBPORGUSR | Assignment Users / Organizational Units for BBP |
| SMUM_TPADD | Address link TP - CAM |
| WP3ROLESRVT | Portal Roles: Services Short Texts |
| SMUM_BSAPP | Business Service ID mapping to BADi |
| BBPLANDF4 | F4 for Country Assignment |
| WP3ROLEUSR | Portal Roles: User Assignments |
| SMUM_ERNUM | Error code mapping |
| WP3ROLEDEFLONG | Long Portal Role Names |
| WP3ROLEAGR | Portal Roles: Assignment to Authorization Roles |
| USR09 | Entries for user menus (work areas) |
| WP3ROLEHIER | Role Data Read from Child Systems for User Assignment |
| SMUM_XMAP | Mapping table between XML and BAPI structures |
| WP3ROLEUSRHLONG | Long Portal Role Names for Role Assignment |