SAP SAP Business Warehouse Tables
Are you looking for the right table related to SAP SAP Business Warehouse 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 SAP Business Warehouse (BW) module.
Top 10 tables in SAP Business Warehouse
| Table | Description |
|---|---|
| RSTT_TDATAB | Block-by-Block Data Packages of the Test Data Archive |
| RSSOURSYSTEM | BW: Souce system IDs table |
| BWSD_LOGD | Status Information for Individual Transfer Locations |
| RSFOLDER | Hierarchies: Nodes which cannot be posted to |
| RSTT_ERROR_T | Text Table for Errors |
| RSSMAEXDSFD | Field info for random extraction |
| BWSD_LOCK | Lock table |
| BWSD_CONFH | Configuration Header |
| RSSTRUC | Enqueue for CL_RS_STRUC |
| RSSMSLEEPDEBUG | Control table for rssm_sleep_debug |
List of tables in SAP Business Warehouse
| Table | Description |
|---|---|
| RSTT_TDATAB | Block-by-Block Data Packages of the Test Data Archive |
| RSSOURSYSTEM | BW: Souce system IDs table |
| BWSD_LOGD | Status Information for Individual Transfer Locations |
| RSFOLDER | Hierarchies: Nodes which cannot be posted to |
| RSTT_ERROR_T | Text Table for Errors |
| RSSMAEXDSFD | Field info for random extraction |
| BWSD_LOCK | Lock table |
| BWSD_CONFH | Configuration Header |
| RSSTRUC | Enqueue for CL_RS_STRUC |
| RSSMSLEEPDEBUG | Control table for rssm_sleep_debug |
| BWSD_CONFP | Parameters of transfer configurations |
| RSTT_TREQ_T | Texts for Test Requests |
| RSTT_TDMAP | Name Transformations for Test Objects |
| BWSD_LOGS | Status for Elementary Transfer Processes |
| BWSD_TRANSH | Header Data for Object Transformation |
| RSALLOWEDCHAR | Additional characters in BW allowed by customers |
| BWSD_LOGO | Status of Scenario Objects from Transfer |
| RSTT_TEST | Store of Existing Test Sequences |
| BWSD_PARAM | Parameter Storage for SDATA |
| RSSMAEXDS | Parameters for example Data Sources |
| RSTT_TREQ | Archive for Test Requests |
| BWSD_LOGH | Header Data of Transfer Log |
| RSTT_LOGRUN | Archive for Test Runs |
| RSFOLDERT | Name for nodes which cannot be posted to |
| RSUSERANSWERS | Answers in RS_POPUP_TO_CONFIRM_ONLY_ONCE |
| BWSD_TEXT | Texts for objects of SDATA |
| RSNSPACETEMPL | Templates for BW Applications |
| BWSD_DATA | Data Store for Scenario Objects |
| RSAPPL | Application components directory |
| RSTT_LOCK_TD | Lock Table for Test Data Processing |
| RSTT_TDATAL | Data Transfer Logs |
| RSNODETYP | Node types |
| BWSD_LOGI | Status of Element Objects from Transfer |
| RSNSPACE | Namespace and Namespace Assignments for BW Objects |
| RSTT_TDATA | Test Data Archive |
| RSTT_ERROR | Error Archive |
| BWSD_LOGM | Messages of transfer executions |
| RSTMCNV | Data on Material Numbers Conversion |
| BWSD_LOGT | Protocol for manual tasks |
| RSADMIN_REF | reference table for rsadmin, contains all allowed parameters |
| RSAPPLT | Application components texts |
| RSCRMD_IMP_TRACE | Trace results table |
| RSHIENODES | Hierarchy Node(s) |
| BWSD_TRANS | Name Replacements of Object Transformation |
| RSTT_TREQSTA | Status Buffer for Test Requests |
| RSTT_LOGUNTS | BW ATR - Special Test Parameters |
| RODPS_HANA_ADMIN | SAP HANA ODP Administrative Data |
| RSSOURSYSIDT | Text of Source System ID |