SAP Security Tables
Are you looking for the right table related to SAP Security 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 Security (EPM-BPC-NW-ADM-SEC) module.
Top 10 tables in Security
| Table | Description |
|---|---|
| UJE_CMS_USERINFO | BPC: user inforamtion for CMS migration use |
| UJE_ROLE_TSKASGN | BPC: Security roles task assignment |
| UJE_TASKT | BPC: Task Text |
| UJE_TASKGROUP | BPC: Task security group table |
| UJE_FLDR_TEAM | BPC10: BUI Folder UUID and Team mapping table |
| UJE_TASKGROUPT | BPC: Task Group Text |
| UJE_MEMACC_CACHE | BPC10:imension member access table |
| UJE_MEMACCESS | BPC10:imension member access table |
| UJE_ROLET | BPC: Role Text |
| UJE_TEAM_AGR | BPC10: Appset team active group |
List of tables in Security
| Table | Description |
|---|---|
| UJE_CMS_USERINFO | BPC: user inforamtion for CMS migration use |
| UJE_ROLE_TSKASGN | BPC: Security roles task assignment |
| UJE_TASKT | BPC: Task Text |
| UJE_TASKGROUP | BPC: Task security group table |
| UJE_FLDR_TEAM | BPC10: BUI Folder UUID and Team mapping table |
| UJE_TASKGROUPT | BPC: Task Group Text |
| UJE_MEMACC_CACHE | BPC10:imension member access table |
| UJE_MEMACCESS | BPC10:imension member access table |
| UJE_ROLET | BPC: Role Text |
| UJE_TEAM_AGR | BPC10: Appset team active group |
| UJE_TEAM_MULTAGR | BPC10: Team's single active groups. BPC impl. of TEAM. |
| UJE_USER | BPC: Application users |
| UJE_USER_AGR | BPC10: Appset user active group |
| UJE_MBRACS_TEMPL | BPC: Template Table used by Member Access Cache |
| UJE_USER_SETTING | BPC: The perferences for Users |
| UJE_TEAMT | BPC: Team Text |
| UJE_TASK_SECT | BPC: Task security Text |
| UJE_TASK_SEC | BPC: Task security |
| UJE_ROLE | BPC: Security roles |
| UJE_PROFILET | BPC: Profile Text |
| UJE_PROFILE | BPC: Security profile table |
| UJE_TASK | BPC: Task security task table |
| UJE_USER_SPECAGR | BPC10: Directly assigned team agrs not inherited |
| UJE_PARAMETER | BPC10: Parameter table |
| UJE_USER_TEAM | BPC: User team |
| UJE_PROFILE_AGR | BPC10: Appset profile active group |
| UJE_TASKACCESS | BPC: Task access table for combining task profiles and tasks |
| UJE_CMS_ATTR | BPC: attributes for CMS migration use |
| UJE_DAP_ATTR | BPC10:Attribute based DAP definition table |
| UJE_MEM_BWAU_MAP | BPC10: Map table |
| UJE_PROFILE_ASIN | BPC: Profile assignment |
| UJE_TEAM | BPC: Team |