The complete list of SAP Tables in Basis Components -> BW Service API 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.

BC-BW General Tables

There are 601 Tables in BW Service API module. View the full list here: SAP BC-BW General Tables

Rank Table Description Table Type
1 ROOSOURCE Table Header for SAP BW OLTP Sources (Relevant From 2.0) Transparent Table
2 ROOSFIELD DataSource Fields Transparent Table
3 RSADMIN Data import administration settings Transparent Table
4 RSBASIDOC Assignment of source systems to BIW systems incl. IDoc type Transparent Table
5 ROOSPRMSC Control Parameter Per DataSource Channel Transparent Table
6 ROOSPRMSF Control Parameters Per DataSource Transparent Table
7 ROIDOCPRMS Control parameters for data transfer from the source system Transparent Table
8 ROOSGENDLM Generic Delta Management for DataSources (Client-Dep.) Transparent Table
9 RODELTAM BW Delta Process Transparent Table
10 ROOSGEN Generated Objects for OLTP Source Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP BC-BW General Tables
Go to top

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

There are 22 Tables in BW generation tool and quantity object module. View the full list here: SAP BC-BW BW generation tool and quantity object Tables (BC-BW-SRV)

Rank Table Description Table Type
1 ODQDATA Operational Delta Queue: Data Store for Delta Transparent Table
2 RSMDS_S_DIMMAPPING Set Object: Mapping of Dimension Names Structure
3 RSMDS_S_DICTITEM Set Object: Dictionary Element as Weak Reference Structure
4 ODQTSN Operational Delta Queue: Last Synchronized Replication - TSN Transparent Table
5 RSMDS_S_FIELDMAPPING Set Object: Mapping of Field Name to a Dimension Structure
6 RSMDS_S_FIELDOPTMAPPING Amount Object: Map Dimension with Sel. Option to Field Name Structure
7 RSMDS_S_MSG Message from SYST Structure
8 RSMDS_S_VERI Structure
9 ODP_S_HIERARCHY_ELEMENT Hierarchy Element Structure
10 ODP_S_HIERARCHY_ELEMENT_KEY Semantic Key of Hierarchy Element Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP BC-BW BW generation tool and quantity object Tables (BC-BW-SRV)
Go to top

Operational Data Provisioning (ODP) and Delta Queue (ODQ) Tables (BC-BW-ODP)

There are 128 Tables in Operational Data Provisioning (ODP) and Delta Queue (ODQ) module. View the full list here: SAP BC-BW Operational Data Provisioning (ODP) and Delta Queue (ODQ) Tables (BC-BW-ODP)

Rank Table Description Table Type
1 ODQSSN Operational Delta Queue: Subscription Transparent Table
2 ODQDATA_F Operational Delta Queue: Data Storage for One-Off Extraction Transparent Table
3 ODQSTATE_V Generierte Tabelle zu einem View General View Structure
4 ODQREQQUE_V Generierte Tabelle zu einem View General View Structure
5 ODQSSNREQQUE_V Generierte Tabelle zu einem View General View Structure
6 ODQREQSSN_V Generierte Tabelle zu einem View General View Structure
7 ODQSSNQUE_V Generierte Tabelle zu einem View General View Structure
8 ODQDATA_V Generierte Tabelle zu einem View General View Structure
9 ODQREQ Operational DeltaQueue: General Request Transparent Table
10 ODQDATA_C Operational Delta Queue: Data Storage for Delta Init. Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP BC-BW Operational Data Provisioning (ODP) and Delta Queue (ODQ) Tables (BC-BW-ODP)
Go to top