SAP Authentication and SSO Tables
Are you looking for the right table related to SAP Authentication and SSO 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 Authentication and SSO (BC-SEC-LGN) module.
Top 10 tables in Authentication and SSO
| Table | Description |
|---|---|
| USR_TOTP | TOTP user data |
| OA2C_CLIENT_EXT | OAuth 2.0 Clients - ROPC - Username |
| OA2C_SAML2_ENT | SAML2 Entity Table for OAuth 2.0 Client |
| OA2_SD_CLT | OAuth2 Client Texts |
| OA2_SR_CTX_SC | OAuth2 ServerContext-Scope-Assignm. (Server Impl., Runtime) |
| OA2_SD_CL_SC | OAuth2 Client-Scope-Assignment (Server Impl., Designtime) |
| OA2C_PARAM | OAuth 2.0 Client Parameters |
| OA2C_CLIENT_MULT | OAuth 2.0 Client Profile Assignment |
| OA2_SR_A_CTX_SC | OAuth 2.0 Authorization Code Context Scope Assignment |
| SEC_POLICY_CUSTT | Configuration of Security Policies (Texts) |
List of SAP tables for Authentication and SSO
| Table | Description |
|---|---|
| USR_TOTP | TOTP user data |
| OA2C_CLIENT_EXT | OAuth 2.0 Clients - ROPC - Username |
| OA2C_SAML2_ENT | SAML2 Entity Table for OAuth 2.0 Client |
| OA2_SD_CLT | OAuth2 Client Texts |
| OA2_SR_CTX_SC | OAuth2 ServerContext-Scope-Assignm. (Server Impl., Runtime) |
| OA2_SD_CL_SC | OAuth2 Client-Scope-Assignment (Server Impl., Designtime) |
| OA2C_PARAM | OAuth 2.0 Client Parameters |
| OA2C_CLIENT_MULT | OAuth 2.0 Client Profile Assignment |
| OA2_SR_A_CTX_SC | OAuth 2.0 Authorization Code Context Scope Assignment |
| SEC_POLICY_CUSTT | Configuration of Security Policies (Texts) |
| OA2_SR_RT_CTX_AT | OAuth2 Server Refresh Token Context Access Token Assignment |
| OA2_SD_SCSET | OAuth2 ScopeSet (Server Implementation, Designtime) |
| OA2_SR_CTX_SCSET | OAuth2 ServerContext-Scopeset-Scope-Assignment |
| OA2_SD_SC | OAuth2 Scope (Server Implementation, Designtime) |
| SEC_POLICY_RT | Security Policy (Runtime Details, Kernel Use) |
| OA2_C_SD_SC | OAuth2 Scope (For Gateway Service Groups in Hub) |
| OA2_SD_NSCSET | OAuth2 ScopeSet |
| USR01 | User master record (runtime data) |
| USRCERTRULEMIG | Migration table for rule based certificate mapping |
| OA2C_CLIENT_PROF | OAuth 2.0 Client Profile Assignment |
| SUAUTHVALTRC | Authorization Trace |
| USH02 | Change history for logon data |
| OA2_SD_CL_SCSET | OAuth2 Client-ScopeSet-Assignment (Server Impl., Designtime) |
| OA2_SD_NSCSET_SC | OAuth2 Scopeset-Scope-Assignment |
| SPN_REPLAY_CACHE | SPNego Cache stores Token Hashes for Replay Prevention |
| OA2_SD_SCT | OAuth2 Scope Description |
| SUAUTHVALFILTER | Authorization Trace Filter |
| SEC_POLICY_CUST | Configuration of Security Policies |
| SEC_POLICY_ATTR | List of Available Security Policy Attributes |
| USERINFO_STORAGE | Internal Use in Class CL_USERINFO_DATA_BINDING |
| USR02 | Logon Data (Kernel-Side Use) |
| OA2_SD_SCSET_SC | OAuth2 Client-ScopeSet-Assignment (Server Impl., Designtime) |
| OA2C_CLIENT_CONF | OAuth 2.0 Client Configuration |
| REENTRANCETICKET | Storage of reentrance tickets (short-lived, one-time usage) |
| OA2C_CLIENT | OAuth 2.0 Clients |
| USRPWDHISTORY | Password History |
| USRCERTMAP | Certificate Mapping |
| OA2_SD_NSCSETT | OAuth2 Scopeset Description |
| OA2C_TOK_EXT | OAuth 2.0 Token Admin table (Extension) |
| OA2C_HTTPC_CFG | OAuth 2.0 Clients - HTTPC - Settings |
| OA2_SR_RT_CTX_SC | OAuth2 Server Refresh Token Context Scope Assignment |
| OA2C_TOKEN_SCOPE | OAuth 2.0 Client Scopes |
| OA2C_PROFILES | OAuth 2.0 Client Profiles |
| OA2_SR_CTX | OAuth2 ServerContext (Server Implementation, Runtime) |
| OA2C_STATE_AC | OAuth 2.0 Client Authorization Code State |
| OA2_SR_RT_CTX | OAuth2 Server Refresh Token Context |
| OA2_SD_CL | OAuth2 Client (Server Implementation, Designtime) |
| OA2C_TOKEN_ADM | OAuth 2.0 Token Admin table |
| USR40 | Table for illegal passwords |
| OA2P_SCOPES | OAuth 2.0 Client Scopes |
| USRCERTRULE | Active Rules for Rule-Based Certificate Logon |
| OA2C_TOK_EXT_SC | OAuth 2.0 Client Scopes |
| OA2_SR_A_CTX | OAuth 2.0 Authorization Code Context |
| OA2C_TYPES | OAuth 2.0 Client Service Provider Types |
| OA2_C_SD_SCT | OAuth2 Scope Description (For Gateway Service Groups in Hub) |
| USR_TOTP_REPLAY | TOTP replay data |
| USR05 | User Master Parameter ID |
| USR41 | User master: Additional data |