SAP Data Basis Tables
Are you looking for the right table related to SAP Data Basis 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 Data Basis (BW-WHM-DBA) module.
Top 10 tables in Data Basis
| Table | Description |
|---|---|
| RSMDUC_TEMPTABNM | Names of Temporary tables used in MD Where-Used Check |
| RSLPODBPART | Semantic Partitioning: Criteria for DB Partitioning |
| RSFBPT | Open ODS View: Texts |
| RSLPOCOMPTEXT | Logichal Partitioning: Texts for Components of LPO |
| RSMDUCMUKMETA | UT MetaData: identifying attributes for MUKs |
| RSDUPARTTC | Test Data for Automatic Tests |
| RSIWP_DIRTRANS | Infoobjects for direct transfer |
| RSLPOPART | Logical Partitioning: Partitions of a LPO |
| RSMDUCMUKATTR | UT Attributes: Identifying attributes for MUKs |
| RSFBPASCTYPEDEF | Definition of association types in the Open ODS View |
List of tables in Data Basis
| Table | Description |
|---|---|
| RSMDUC_TEMPTABNM | Names of Temporary tables used in MD Where-Used Check |
| RSLPODBPART | Semantic Partitioning: Criteria for DB Partitioning |
| RSFBPT | Open ODS View: Texts |
| RSLPOCOMPTEXT | Logichal Partitioning: Texts for Components of LPO |
| RSMDUCMUKMETA | UT MetaData: identifying attributes for MUKs |
| RSDUPARTTC | Test Data for Automatic Tests |
| RSIWP_DIRTRANS | Infoobjects for direct transfer |
| RSLPOPART | Logical Partitioning: Partitions of a LPO |
| RSMDUCMUKATTR | UT Attributes: Identifying attributes for MUKs |
| RSFBPASCTYPEDEF | Definition of association types in the Open ODS View |
| RSIWP_PARA | Application Parameters |
| RSLPOCOMPPROP | Semantic Partitioning: Properties of SPO Components |
| RSCNV_SID_BUFFER | SID buffer table for session-independent handling |
| RSB4H_ODSACTUPDT | Replication Table of RSODSACTUPDTYPE for B4H-Transfer |
| RSLPO_DFG_DTPFOL | Table for Managing Folders for DTP Templates |
| RSIWP_OBJECT | Objects for ArchivLink access |
| RSB4H_MANREQMDEL | Replication Table of RSSTATMANREQMDEL for B4H-Transfer |
| RSLPOPARTRANGE | Logical Partitioning: Partitioning Criteria |
| RSDRI_DS_TC | Test Data RSDRI (External Read Interface) |
| RSFBPNAVATRT | Open ODS View: Local field texts |
| RSFBPFIELDT | Open ODS View: Local field texts |
| RSCNVCNVHD | Runtime conversion header |
| RSHIELVT | Levels Table for Hierarchies in BW |
| MDM_CS_FIELD_TAB | MDM: Field Table of SAP System |
| RSCNVRRT | Remodeling rule texts |
| RSFBPSEMANTICS | Open ODS View: Semantics |
| RSCNVCG | Conversion Groups |
| RSCNVREQ | Conversion Requests |
| RSBGUI_R_TEST | ABAP Unit Test CL_RSB_GUI_MAINTAIN |
| RSDRV_CCDSC_CLUP | cleanup of cache for CalculationScenarios on CDS |
| RSFBPSOURCE | Open ODS View: Source Objects |
| RSIPRORANGE | Semantic Partitioning: Data Distribution |
| RSDODSOFIELDTEXT | DataStore Object: Field Texts |
| RSB4HBACKUP | Transfer history |
| RSB4HPTRACE | Collectiontrace |
| RSB4HTAU_RUNT | Authorization conversion run texts |
| RSCNVSTEPOPS | Operations relevant for each step |
| RSDD_DELTA_PKG | Delta Package Management for InfoCube Delta Write |
| RSDODSOLOC | Local Properties of DataStores |
| RSDODSOIOBJPRO | InfoObject Properties within the DataStore |
| RSMDUCMUKCUBE | UT InfoCube: identifying attributes for MUKs |
| RSDMDATSYS | artefact |
| RSAPOADM | Management Table for Transactional Requests |
| RSR_REL_TIME_FIS | Time Relations for Planning |
| RSMDUCMUKNLS | UT Nearline Infoproviders: identifying attributes for MUKs |
| RSB4HLPOPARTOBJ | Main Partition Criteria for Semantic Partitioned Object |
| RSCNVOPTYPES | Operation type to class name mapping |
| RSMDUCMUKCMP | UT Compound Cha: Identifying attributes for MUKs |
| RSDDIME | Dimensions directory |
| RSCNV_BUFFER_SID | Buffer table for filling methods using mapping and constant |
| RSODSACTSIDTYPE | SID Status of Fields at Time of Update |
| RSCNVCNVADMIN | Administration table for running conversions |
| RSICRESET | Reset Cube Administration |
| RSMDUC_DTEMPLATE | Template table for 'D' Temprary table (MD Where-Used Check) |
| RSDMDRSRV | Communication with RSRV Jobs |
| RSODSODELFS | Requests (in Faststores) that are regarded as deleted |
| RSB4_TRF_ODS | temporary table-names of datasources to be transferred |
| RSDMODSTAB | Model Table: ODS Table Active Records |
| RSODSMPPSQLLOG | Copy of INDX for ODS Activation |
| RSDMODSTAB_MPP | Model Table for DataStore Object: Table for MPP |
| RSB4HTAPD_APD | APD transformation information table |
| RSB4HTDSODP | Shadow Table for Target ODP Names for DataSource Transfer |
| RSMDUCMUKODSO | UT DataStore Objects: identifying attributes for MUKs |
| RSB4H_TS_REQINCL | Requests with records in the Change Log |
| RSB4HPSESSDESCR | Descriptions for Sessions |
| RSDRI_DS_TC_LOG | Test Data RSDRI |
| RSDODSOINDX | Indexes for DataStores |
| RSFBPSRCTYPEDEFT | Definition of source types in the Open ODS View |
| RSODSOSIDSTATETS | Status of SID Scan (Access Method: Full Table Scan) |
| RSDMDENQ | Locking of master data tables / text tables |
| RSLPO_PC_THREAD | Process Chain Generation - Threads |
| RSDCUBEIOBJ | Objects per InfoCube (where-used list) |
| RSLPOPARAM | LPO Parameter |
| RSDMDRSPMSTATUS | BW Master Data: RSPM Migration Status |
| RSODSO_IMOLOG | Monitor Information for IMO DataStore Activation |
| RSSEM_UCR0_IPD | SEM BCS Destination Registration For an InfoProvider |
| RSDDIMELOC | Dimensions system-local properties (not transport.) |
| RSR_TIME_REL | Time Relations for Planning |
| RSMDUCMUKAGGR | UT Aggregates: Identifying attributes for MUKs |
| RRBANRIV | Client-independent number range intervals |
| RSDMDDTSTMP | Master Data Deletion Timestamp |
| RSR_PE_LOOKUP | Test Table for TREX_EXT_PE_LOOKUP |
| RSB4HTAU_CONF | Authorization conversion run configuration |
| RSB4_TRF_OIP | temporary table-names of infoproviders to be transferred |
| RSFBPSRCTYPEDEF | Definition of source types in the Open ODS View |
| RSDICVALIOBJ | InfoObjects in NC-value validity table for the InfoCube |
| RSFBPFIELDGENPRO | Open ODS View: Fields |
| RSVHDBSIZING | HANA Sizing summary information |
| RSDMDACTDATA | INDX for Master Data Request Activation |
| RSB4HTRFN | Transformation source, target, DTP relation |
| RSODSO_ASQL_LOGS | ANYSQL log table |
| RSB4HTAU_A_STATS | Authorization conversion auth. obj stats |
| RSHIEDIRT | Hierarchy directory texts |
| RSB4H_REQDONE | Replication Table of RSREQDONE for B4H-Transfer |
| RSDD_MIGRAT_PART | Table with Partitioning Information for the BW Migration |
| RSMHIERNODE | Master data: Hierarchy nodes that cannot be posted to |
| RSB4H_ICCONT | Replication Table of RSICCONT for B4H-Transfer |
| RSDIPRONCUMVIOBJ | InfoProvider: InfoObjects for NCUM Validity Table |
| RSB4HSEARCHBL | Blacklist for Search |
| RSQWCOND | Standard WHERE Conditions in the InfoSet |
| RSDODSOIOBJIND | InfoObjects in DS Indexes |
| RSDODSOIOBJ | InfoObject in DataStore |
| RSMDUCMUKADSO | UT DSO (Advanced, "AT" storage): identifying attr. for MUKs |
| RSODSOIMOSETTING | Configuration of Runtime Behavior for SAP HANA-Optim. DSO |
| RSDDIMEIOBJ | InfoObjects per dimension (where-used list) |
| RSDD_PKG_ID | Unique Delta Package ID for Each InfoCube |
| RSDRI_DS_TC_BACK | Test Data RSDRI (External Read Interface) |
| RSCNV_BUFFER_MOV | SID buffer table for MOVE operation |
| RSDCHABASDELMSG | likely artefact |
| RSQIMPACT | Log for Impact-Analysis |
| RSB4_TRFST_S | Status table for B4H-transfer of datasources |
| RSDRI_HDB_SPO | Status Table for SAP HANA Conversion of SPOs |
| RSCNVSTEP | Steps for dimension conversion |
| RSR_PE_COPY | Test Table for TREX_EXT_PE_COPY |
| RSDRI_HDB_CNVDSO | Control Table for DataStore Conversion |
| RSLPO | Logical Partitioning: Directory of LPOs |
| RSODSO_BRKPNT | Breakpoint Maintenance for DataStore Objects |
| RSODSACTDATA | Copy of INDX for ODS Activation |
| RSDODSOATRNAV | Navigation Attributes in DataStore |
| RSHIEDIR | Hierarchy Catalog |
| RSDDIMET | Dimension Texts |
| RSNEWTTADMIN | New Admin table for new Request Transfer in TT |
| RSLPOCOMP | Logical Partitioning: Components of a LPO |
| RSSEM1000 | Generated Classes by InfoCube |
| RSDICMULTIIOBJ | MultiProvider: Selection/Identification of InfoObjects |
| RSB4H_MONFACT | Replication Table of RSMONFACT for B4H-Transfer |
| RSDODSOTABL | Directory of all DataStore Tables |
| RSDSO_MNG_DYNSET | ADSO manage: dynamic user settings |
| RSODSO_LOGGUID | Management of LOG-GUIDS that Belong to Request GUIDS |
| RSTHIERNODE | Texts of Non-Postable Hierarchy Nodes |
| RSDIPROIOBJT | Texts for InfoObjects in InfoProvider |
| RSAPOREQUEST | Table for Defining Lock Object |
| RSMDDELTAEX | Table of Active Master Data Extractors |
| RSIWP_KEY | Document Keys for ArchivLink access |
| RSEHIERNODE | Master Data: Hierarchy Nodes that Cannot Be Posted To |
| RSLPO_DFG_DTPGEN | Table of Generated DTPs |
| RSDCUBE | Directory of InfoCubes / InfoProvider |
| RSR_PE_TVOLATILE | BW-IP PAK: lookup hints |
| RSQDIMT | Texts for Dimensions in the InfoSet |
| RSB4H_MANREQMAP | Replication Table of RSSTATMANREQMAP for B4H-Transfer |
| RSSEM_CNV_PKG | Remote Conversion to BCS/4Hana: BCS Scope selections |
| RSODSOMPPSWTCH | Activation of DataStore Objects on MPP Platforms |
| RSLPOSCHED | Logical Partitioning: Scheduling Options for BTC Jobs |
| RSDIPROHNODEIOBJ | InfoProvider: InfoObjects in Hierarchy Nodes |
| RSFBP | Open ODS View |
| RSDODSOFIELD | DataStore Object: Fields |
| RSSZTDIR | Directory of the customer master data table |
| RSB4HTAU_RUN | Authorization conversion runs |
| RSLPO_DFG_GENTGT | Pseudo Table for Lock Requests at Target TLOGO |
| RSADSO_MSG | Monitor Information for Advanced DataStore Activation |
| RSQTOBJT | Texts for Table Objects in the InfoSet |
| RSLPO_DFG_DTPTPL | Table of DTP Templates |
| RSDCUBET | Texts for the InfoCubes |
| RSDSO_RT_SETTING | Runtime Settings |
| RSDRV_CCDS_CACHE | Cache table for CalculationScenarios on CDS |
| RSSEM_REQUESTCOP | InfoCube Assignment |
| RSODSOUSECASE | Specification of Application Type for DataStore Objects |
| RSDMFACTAB | Model table: Fact table |
| RSIWP_VPROV_ASS | Assignment of the Virtual Providers to database tables |
| RSODSO_GENPRG | Management of Generated Programs from DataStore Objects |
| RSB4_TRFST_T | Status table for B4H-transfer of single tables |
| RSODSO_ROLLBACK | Table for Temporary Storage of Data during Rollback |
| RSDODSODDICFIELD | DataStore Object: Predefined DDIC Type Fields |
| RSODSREQTSTMP | Sorting of ODS Requests |
| RSCNVMON | Table to store the general data for Monitor |
| RSFBPNAVATR | Open ODS View: Navigation Attributes |
| RSCNVMONSTEPS | Steps of any operation on a BW Object |
| RSDODSOT | Texts of DataStores |
| RSB4HTMPROIOBJ | InfoObject-Mapping for MultiProvider B4H Pre Check(Target) |
| RSB4_TRF_RCC | calculation scenarios for remotely transferred infocubes |
| RSQDIM | Dimensions in the InfoSet |
| RSMDUCMUKDOC | UT Documents: Identifying attributes for MUKs |
| RSMDUCMUT | Metadata of Master Data Usage Type (for Usage Check) |
| RSVHDBTABSIZES | Sizing estimation details for tables. Size is in KB not MB |
| RSDMDM_IOBJ_AGR | Customizing for Master Data Maintenance |
| RSODSO_SETTING | Configuration for Runtime Behavior of the DataStore Object |
| RSCNVCGHEADER | Remodeling Rule header |
| RSDMDM_IOBJ_DTLS | Customizing for Master Data Maintenance |
| RSB4_TRFST_I | Status table for B4H-transfer of infoproviders |
| RSDCHABASDELCV | artefact of the first concept of new MD del. no longer used |
| RSCNVSTEPOP | Operations assigned to each dimension conversion |
| RSDICHAPRO | InfoCube-specific characteristic properties |
| RSMASLE | Lock Table for Master Data Deletion |
| RSDMODSTAB_UPDOP | Model Table for DSO: Modification Rules for Fields |
| RSR_PE_LOG_CS | Log for Planning Engine (Extract of Call Stack) |
| RSODSO_IMOACT_T | DSO: In-Memory-Optimized Activation (Template Table) |
| RSDMDIMTAB | Model table: Dimensions table |
| RSB4HDTP | dtp source target relation |
| RSCNVACTDATA | Copy of the INDX for Converting ODS Objects |
| RSDRI_HDB_CNV | Status Table for InfoCube Conversion |
| RSDMODSTAB_UR | Model Table for ODS Update and Rollback |
| RSDIPROHIER | InfoProvider: Hierarchies (InfoObjects) |
| RSDMODSTAB_NCUMV | Model Table for DSO: Non-Cumulative (NCUM): Validity Table |
| RSIWP_VPROV_DEF | Definition ot the Virtual Providers |
| RSMDUCMUKADS3 | UT DSO (Advanced, "CL" storage): identifying attr. for MUKs |
| RSB4H_STATSYS | System Information belonging to Statistics Data |
| RSDMDATTRDATE | Relation: Char. and Key Dates of Time-Dependent Attribute |
| RSB4HTAU_A_MAP | Authorization conversion mapping table |
| RSDRI_HDB_ABORT | Storage for Aborts / Breakpoints |
| RSB4_ODSPART | translation of RSTSODSPART for temporary tables |
| RSDMODSTAB_IMACT | Model Table for DSO: In-Memory Activation |
| RSODSO_RUNTIME | Results of Runtime Measurement |
| RSDRV_ODP_SYN | HANA Synonyms for CL_RSDRV_ODP_QUERY |
| RSCNVSTEPS | Conversion Request Steps |
| RSDMVALTAB | Model table: Validity table |
| RSDODSO | Directory of all DataStores |
| RSDMDELPACKAGE | Master data deletion - Table to hold last executed SID value |
| RSSEM_RFCPACK | Temporary Storage of Selected InfoProvider Data |
| RSDCHABASDEL | artefact of the first concept of new MD del. no longer used |
| RSR_REL_TIME | Time Relations for Planning |
| RSMDUCMUKADS2 | UT DSO (Advanced, "AQ" storage): identifying attr. for MUKs |
| RSQRDB | SAP Query: Runtime Objects for Query Reports |
| RSLPOT | Logical Partitioning: Texts for LPOs |
| RSCNV_BUFFER_MAP | Buffer table for filling methods using mapping and constant |
| RSODSO_REQUCPY | Assigning Requests to Template Copies (DataStore Relevant) |
| RSB4HTAPD_SET | APD conversion settings |
| RSODSO_ACT_STAT | Status of the DB based DSO activation |
| RSSEM1001 | Generated Classes by Characteristic |
| RSCNV_BUFFER_CHA | Buffer table for filling methods using mapping and constant |
| RSIWP_IPROV | Directory of the infoprovides of a Work Package |
| RSQFOBJT | Texts for Field Objects in the InfoSet |
| RSDCUBELOC | Local Characteristics: InfoCubes (InfoProvider) |
| RSIWP_WP_ASS | assignment of a work package to a user |
| RSDIPROHNODET | InfoProvider: Hierarchy Nodes, Descriptions |
| RSB4H_SELDONE | Replication Table of RSSELDONE for B4H-Transfer |
| RSCNVTST | Remodeling Test |
| RSR_REL_STATUS | Status of Generation of Time Relations |
| RSQISETLOC | Local Properties InfoSets |
| RSDIKYFPRO | InfoCube-specific key figure properties |
| RSR_PE_LOG | Log for Planning Engine |
| RSDIPROIOBJRANGE | Partitioning Areas: InfoProvider |
| RSB4HPCARVEOUT | Manually skipped objects |
| RSB4HPCS | process chains to be adjusted during transfer |
| RSSEM_RFC_MDF | Callback Destination to Dependent MDF/SEM-BCS/BA Clients |
| RSQACCMODE | ACC Mode |
| RSDIPROHNODE | InfoProvider: Hierarchy Nodes |
| RSODSACTREQMPP | Activation table of M-requests to change-log requests |
| RSMDUC_TTEMPLATE | Template table for 'T' Temprary table (MD Where-Used Check) |
| RSIWP_CALLBACK | Callback destinations |
| RSMIGROBJ | Lock Entries for Object Migration |
| RSB4HTAU_R_MAP | Authorization conversion role mapping |
| RSB4HTDEFINITION | definition of objects to be transfered |
| RSBOH_MNG_DYNSET | Open Hub manage: dynamic user settings |
| RSFBPCMP | Open ODS View: Compounding |
| RSMDHIERATTR | Attribute Table Metadata Hierarchies |
| RSFBPASCTYPEDEFT | Definition of association types in the Open ODS View |
| RSR_TIME_REL_FIS | Time Relations for Planning |
| RSIWP_ASSIGN | Assignment of of infoojects per Work Package and Tablefield |
| RSODSO_CONTEXT | Control of Runtime Measurements |
| RSLPO_LOCKS | Persistent Locks |
| RSMDUCMUTT | Text for Metadata of Master Data Usage Type(for Usage Check) |
| RSB4H_DATAVERI | RSB4HANA-Transfer: Data Verification Tests |
| RSDCUBEMULTI | InfoCubes concerned with MultiCube |
| RSB4HMPROIOBJMAP | InfoObject-Mapping for MultiProvider B4H Pre Check |
| RSDSO_RUNTIME | Runtime Measurement |
| RSCNVTSTDATA | Remodeling test data |
| RSB4H_MONICDP | Replication Table of RSMONICDP for B4H-Transfer |
| RSODSACTSETTING | Settings for Activating Requests |
| RSDCHABASDELLOG | artefact of the first concept of new MD dele. nolonger used |
| RSDMDRSRVMSG | Messages Generated by RSRV Jobs |
| RSCNVRROPVAL | Remodeling rule operation values |
| RSCNVCGT | Remodeling Rule Texts |
| RSB4HTAPD_MAP | Analyzed APD object maps |
| RSB4_TRF_OOH | temporary table-names of destinations to be transferred |
| RSQONCOND | ON Condition in InfoSet |
| RSODSO_TMPLCPY | Management of Valid Template Copies for DataStore Objects |
| RSB4H_TS_SELECTS | Selections as determined while preparing a B4H transfer |
| RSR_TIME_STATUS | Status of Generation of Time Relations |
| RSB4HTMPROCMP | InfoObject-CMP for MultiProvider B4H Pre Check(Target) |
| RSMDUCMUKHIER | UT Hierarchy: Identifying attributes for MUKs |
| RSODSMPPVERIFY | Log for Data Verification |
| RSB4HPOBJECT | Objects of BW/4 Transfer |
| RSB4_TRF_PCKS | package definitions for data transfer of cubes to ADSOs |
| RSCNVRROP | Remodeling rule operations |
| RSB4HTOBJECT | Objects of BW/4 Transfer |
| RSB4H_MONMESS | Replication Table of RSONMESS for B4H-Transfer |
| RSB4HPREQUESTMAP | Mapping Request SID, GUID, TSN |
| RSB4H_STAT | Statistics for B4H Transfer |
| RSIWP_TABASS | Tables included in an extended virtual provider |
| RSQISETX | Directory of all InfoSets (Technical Enhancements) |
| RSB4HSYSMAP | System Mapping to 1 Byte Digit |
| RSEURO | Conversion Table for Euro Conversion |
| RSCNVRRHD | Remodeling rule header |
| RSB4H_ODSACTREQ | Replication Table of RSODSACTREQ for B4H-Transfer |
| RSFBPFIELD | Open ODS View: Fields |
| RSB4HTRANSFER | transfer objects |
| RSMAXHIETAB | Hierarchy Node Table with Maximum Possible Structure |
| RSFBPLOCAL | Generic time stamp of source type |
| RSODSO_ASQL_LOG | ANYSQL log table |
| RSODSO_IMOMSG | Monitor Information for IMO DataStore Activation |
| RSB4HTAU_INACT | Authorization conversion inactive authorization objects |
| RSB4H_STAT_AGGR | Statistics for B4H Transfer |