SAP Admin Tables

Are you looking for the right table related to SAP Admin 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 Admin (EPM-BPC-NW-ADM) module.

Top 10 tables in Admin

TableDescription
UJA3_SFT_VERSIONBPC: Software version
UJHANA_SYNC_PLNDBPC: HANA native model synchronization plan detail
UJA_USER_CVBPC: Current View
UJA_APPLBPC: Applications
UJA_VALID_VALBPC: Valid Value
UJA_APPL_COMPobserver list for application components
UJAM_ACT_CACHEBPC: Active cache version
UJAM_ACT_CACHECCBPC: Active cache
UJA_DIM_ATHIERBPC: Dimension Hierarchy Info
UJHANA_SYNC_LOGDBPC: HANA native model synchronization log detail

List of tables in Admin

TableDescription
UJA3_SFT_VERSIONBPC: Software version
UJHANA_SYNC_PLNDBPC: HANA native model synchronization plan detail
UJA_USER_CVBPC: Current View
UJA_APPLBPC: Applications
UJA_VALID_VALBPC: Valid Value
UJA_APPL_COMPobserver list for application components
UJAM_ACT_CACHEBPC: Active cache version
UJAM_ACT_CACHECCBPC: Active cache
UJA_DIM_ATHIERBPC: Dimension Hierarchy Info
UJHANA_SYNC_LOGDBPC: HANA native model synchronization log detail
UJA_HIER_CLASSBPC: Hierarchy class
UJA_DIMENSIONBPC: Dimensions
UJA_LOGGED_ON_ABPC: User Logon Activity History
UJA_REQ_FS_STRUCBPC: Required File Service Strcuture Defnition
UJAM_HIER_TRANSBPC: Hierarchy Transformers
UJA_SERVER_INFOBPC: Server Info
UJA_APP_RECATTRecommended attributes for dimension and application types
UJA_SVR_DEFAULTBPC: Server Defaults
UJA_USER_DEFBPC: User defaults
UJA3_LANGUBPC: Language
UJA_LOGGED_ONBPC: User Logon History
UJA_USAGE_LOGBPC: Usage Log
UJA_DIM_OPTBPC: Table of dimension option
UJHANA_SYNC_PLANBPC: HANA native model synchronization plan
UJA3_USER_LANGUBPC: User Language
UJA_DOMAINTBPC: Domain Text
UJHANA_NMF_DEPNested Member FOrmula Dependency table
UJA_APPSET_INFOBPC: Application Set Info
UJHANA_SYNC_STATBPC: synch status for WB
UJA_DMTYP_REQATTBPC: Dimension Type required Atttributes
UJA3_CLT_OPTBPC: Cilent option
UJAAR_JOB_INFOBPC: Basic information regarding the ongoing jobs
UJA_LAST_USERBPC: Last Application user has accessed
UJA_DIM_APPLBPC: Application Dimensions
UJA_LAST_APPSETContains the last used appset for users
UJA_DIM_OBSERVERBPC: Dimension observer
UJAM_TDH_VER_HISSave previously deleted TDH version's max version number.
UJA_FILTERBPC: Filter Table
UJA_APPSETTBPC: Application Set Text
UJAAR_JOB_INFOTMessage information for the jobs
UJHANA_DEP_TREEBPC: Dependent tree for Nested Member Formula
UJA_DIMENSIONTBPC: Dimension Text
UJA_APPLTBPC: Application Text
UJA_DMTYP_REFTYPBPC: Required Reference Dimension and Property for Dim Type
UJHANA_SYNC_LOGBPC: HANA native model synchronization log
UJA_FORMULABPC: Formula template
UJAM_TDH_KEYDATEBPC: TDH KEYDATE
UJA_DIM_ATTRBPC: Dimension attribute
UJA_DIM_HIER2BPC: Contains the hierarchies of the dimensions
UJA_APST_TYP_APPBPC: Application Set type required Application types
UJA_APTYP_DIMTYPBPC: Application type required dimension type
UJA_FORMULA_APPBPC: Formula per Application
UJA_APPL_DIM_JOBBPC: Application's dimension for job usage
UJA_DOMAINBPC: Domains
UJA_SHM_DEFBPC: Shared Memory Definition for Appset
UJA_DIM_HIE_MAP2BPC: Mapping for hierarchy and hierarchy cache table name
UJA_DIM_HIER_MAPBPC: Mapping for hierarchy and hierarchy cache table name
UJA_DIM_HIERContains the hierarchies of the dimensions