Here is the complete list of SAP Tables in SAP Business Information Warehouse module. The most commonly used Tables are at the top of the list. Click on a sub-module to see the Tables specific to that module.

Warehouse Management Tables (BW-WHM)

Table Description
RSDS DataSource in BW
RSPCPROCESSLOG Logs for the Chain Runs
RSDDSTAT Obsolete as of Release BI 7.0 -> RSDDSTAT_OLAP/DM
RSICCONT Monitor: Saving of the updated IC and ODS per request
RSSELDONE Monitor: Selections for executed request
RSREQDONE Monitor: Saving of the QM entries
RSMONICDP Monitor Request Data Packet Table
RSTSODS Operational Data Store for the transfer structure
RSDCUBE Directory of InfoCubes / InfoProvider
RSODSACTREQ Activation table of M-requests to change-log requests
RSSDLINIT Last Valid Initializations to an OLTP Source
RSTRAN Transformation
RSOSFIELDMAP Mapping Between OLTP Source Fields and InfoObjects
RSDODSO Directory of all DataStores
RSDIOBJ Directory of all InfoObjects
..... ..................................

BW General Tables

Table Description
RSDS DataSource in BW
RSPCPROCESSLOG Logs for the Chain Runs
RSDDSTAT Obsolete as of Release BI 7.0 -> RSDDSTAT_OLAP/DM
RSRREPDIR Directory of all reports
RSICCONT Monitor: Saving of the updated IC and ODS per request
RSZCOMPDIR Directory of reporting components
RSZELTDIR Directory of the reporting component elements
RSSELDONE Monitor: Selections for executed request
RSZGLOBV Global Variables in Reporting
RSZELTTXT Texts of reporting component elements
RSREQDONE Monitor: Saving of the QM entries
RSMONICDP Monitor Request Data Packet Table
RSTSODS Operational Data Store for the transfer structure
RSZELTXREF Directory of query element references
RSDCUBE Directory of InfoCubes / InfoProvider
..... ..................................

See the complete list of SAP BW General Tables

Planning Tables (BW-PLA)

Table Description
UPC_VAR Variables
UPC_VAR_CHA_ACT Variables - Restricted Values
UPC_DATASLICE Data Slices
RSPLS_DS Data Slices
UPC_DATASLICET Data Slices
UPC_DARK2 Control for Hidden Functions
UPF_PARGD Parameterization - GUIDs
UPC_OPTIOS Planning: Conditions for Fields
RSPLS_DS_FIELD Data Slices: InfoObejcts with Restrictions
UPC_AREA Planning Areas
UPC_VAR_CHA_SEL Variables - Selections
RSPLF_FDIR Function Modules in Formulas
UPB_PM_SETTINGS Planning Folders: Technical Settings of All Folders
UPC_AREAT Planning Areas - Text Table
UPC_VAR_CHA Variables - Characteristics
..... ..................................

See the complete list of SAP BW Planning Tables (BW-PLA)

Business Explorer Tables (BW-BEX)

Table Description
RSRREPDIR Directory of all reports
RSZCOMPDIR Directory of reporting components
RSZELTDIR Directory of the reporting component elements
RSZGLOBV Global Variables in Reporting
RSZELTTXT Texts of reporting component elements
RSZELTXREF Directory of query element references
RSDDSTAT_OLAP Generierte Tabelle zu einem View
RSPRECADMIN Table for maintaining prec server workload
RSADMINA Control Table that Customer can Change
RSRVARIANT Variant Values
RSZRANGE Selection specification for an element
RSPOR_T_PORTAL Connected Portals
RSRTRACE TRACE table for editing the favorites
RSDDSTAT_DM Generierte Tabelle zu einem View
RSZSELECT Selection properties of an element
..... ..................................

See the complete list of SAP BW Business Explorer Tables (BW-BEX)

Business Content and Extractors Tables (BW-BCT)

Table Description
RSBCTCB_QUERY Generated Table for View
RSROLEHIERARCHY
RSTCCADMIN
RSBCTCB_QRY_T_V Generated Table for View
RSDMTU_AWB_MON Monitoring AWB
RSDMTU_CUSMON User-Specific Tree Display Monitor
RSDMA_DBT_MODELT DB: Model Texts
RSDMESC_AGGR_IND Aggregated Data: Indexes
RSDMESC_AGGR_VAL Aggregated Data: Values for Indexes
RSCONTENTPACKAGE Packages used for BI Content Checks
CCMSBI_CPH_GUIDS GUIDs for Long MTE Name
RSCONTACT_CUBE Status Overview for All Objects That Belong to a Cube
RSDMESC_NET_SCOR Score Grid: Scores for Node Indexes
RSDMTA_ASSRULES Association discovery rules table
RSPL_IOSAMEFAC Same Factors for All Key Figures
..... ..................................

BW generation tool and quantity object Tables (BC-BW-SRV)

Table Description
ODQDATA Operational Delta Queue: Data Store for Delta
ODQTSN Operational Delta Queue: Last Synchronized Replication - TSN