SAP BW Service API Tables
Are you looking for the right table related to SAP BW Service API 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 BW Service API (BC-BW) module.
Top 10 tables in BW Service API
| Table | Description |
|---|---|
| RSFHGENTD | Generated Routines for Extraction of Transaction Data |
| RODSAPPLT | Texts for Application Components of a DataSource |
| ROOHIECOM | Compound Information for Hierarchy DS in Source System |
| ROOSGENQV | Extract Structure Versions |
| ROAPPLT | BW: Name of the Application Components |
| ROAUTH | Authorizations for DataSources |
| RODCHABAS | InfoObjects / basic characteristics in the source system |
| ROBWQTSTAT | Delta Update Status |
| ROOSPRMSC | Control Parameter Per DataSource Channel |
| ROPC_WFBOR | Workflow Processes Started |
List of tables in BW Service API
| Table | Description |
|---|---|
| RSFHGENTD | Generated Routines for Extraction of Transaction Data |
| RODSAPPLT | Texts for Application Components of a DataSource |
| ROOHIECOM | Compound Information for Hierarchy DS in Source System |
| ROOSGENQV | Extract Structure Versions |
| ROAPPLT | BW: Name of the Application Components |
| ROAUTH | Authorizations for DataSources |
| RODCHABAS | InfoObjects / basic characteristics in the source system |
| ROBWQTSTAT | Delta Update Status |
| ROOSPRMSC | Control Parameter Per DataSource Channel |
| ROPC_WFBOR | Workflow Processes Started |
| RODUNI | BW: Units |
| RODTIM | BW: Time Characteristics |
| ROISGEN | Generated objects for the InfoSource |
| ROPXCONF | DataSource Proxy Setting |
| RSMVTSTAT | Value table for statistics indicators per value type |
| RSSGTBID | Example of BW program generation:GUIDs for tables |
| RSTVTSTAT | Texts for statistics indicator per value type |
| RSSGTPCLAT | BW generation tool: Texts for program classes |
| ROHIEOBJ | Derivation of hierarchy class and node type -> InfoObject |
| ROVERTYPEA | Test Type in Verification Scenario |
| ROIS | InfoSources in the source systems |
| ROREQUESTPRMS | Request Attributes (Source System) |
| RSAPETDTL | Detail Records from Extraction Trace |
| RSSCM_BWAPO | System setting within SCM 4.0 system |
| ROOSGENDLM | Generic Delta Management for DataSources (Client-Dep.) |
| ROVERREGIT | Texts for Region in Verification Scenario |
| ROOSGENSEG | Generated Objects for OLTP Source |
| RSMMETYPE | Value table for key figure types |
| RSAPETSTI | Call Stack Items |
| ROOSGENDLT | Generic Delta Management for DataSources |
| AQBWCAT_SAP | InfoSource Catalog (SAP Query) Used by SAP |
| ROVERFIEA | Field Number in Verification Scenario |
| RODELTAM | BW Delta Process |
| ROVERCUBE3 | Transaction Data for Verification Scenarios (from 4.0B) |
| ROVERCUBE1 | Transaction Data for Verification Scenarios |
| ROEXSOURCE | ABAP Source Code for BW Extractors |
| ROISIOBJ | BW: Assignment of InfoSource Fields to InfoObjects |
| ROOSGEN | Generated Objects for OLTP Source |
| ROPC_BOR | Process Chains Started (Workflow) |
| ROOSPRMS | Control Parameters Per DataSource |
| RSSCM_BWCLNT | Client for BW extraction for SCM4.0 applications |
| RSIBUS | IBU (Industry Business Units) Support |
| RSMVTYPE | Value table for value types for reporting |
| ROOSOURCET | Texts for an OLTP Source |
| ROOSPRMSF | Control Parameters Per DataSource |
| RODIOBJ | InfoObjects of the source system |
| RODKYF | BW: Key Figures |
| ROVERFIELH | Hierarchy using Test Fields in Verification Scenario |
| ROMDDELTA | BIW: DataSource Assignment - Change Pointer |
| RODELTAMT | BW Delta Process (Text) |
| ROVERTABLE | Tables for Verification Scenarios |
| RSCONREL | Value table for content releases |
| ROOSGENQ | Generated Coding for DS (Only for Delta Queue at Present) |
| RSMVTDETL | Value table for detailling per value type |
| ROVERREGIA | Region in Verification Scenario |
| RODIOBJCMP | BW: InfoObjects / Compounding |
| RSBENFTABT | Benchmarking: Name of the callup points |
| RSHIEOBJ | Hierarchies: Directory of the contained InfoObjects |
| RODSAPPL | DataSource Application Components |
| ROOHIECAT | Additional Hierarchy Information for DS in Source System |
| AQBWFCAT | InfoSource Catalog (SAP Query) Customer |
| RSC2QOUT | Description of BW Outbound Queue |
| ROVERFIELT | Texts for Field Numbers |
| RSBENFTAB | Benchmarking: Directory of the callup points |
| ROOSGENRT | Generated Objects for OLTP Source |
| RSNDPS | NDP (New Dimension Products) Support |
| ROOSATTR | DataSource Attributes |
| RSMREPLED | Value table for reporting ledger |
| RSSGTPDIRSUB | BW Generation Tool: Time Stamp Management for Subtemplates |
| RODCHA | BW: InfoObjects / Characteristics |
| RSSAPIVERS | SAPI Version |
| ROHIEBAS | Assignment of hierarchy class / domain for basic character. |
| ROPROXCONF | Deprecated |
| RSMDDELTA | Assignment basic characteristic - change pointer |
| RORQSTATTR | Request Attributes |
| ROVERHIE | Hierarchies in Verification Scenario |
| ROVERCUSTT | Customer Texts for Verification Scenario FAB |
| ROOSGENTFSTR | Transfer Structure (Character) Segmented |
| ROOSSHORTN | DataSource Short Name |
| ROOSSEG | Segments of a DataSource |
| RODSEXIT | DataSource Events |
| ROVERHIET | Hierarchy Texts in Verification Scenario |
| RSBIWBENCH | Benchmarking Business Information Warehouse |
| RSTVTYPE | Texts for value types for reporting |
| ROOSESRMAP | Mapping DataSource ESR (Serialized Object) |
| ROVERTYPET | Texts for Test Type in Verification Scenario |
| RSFHSEL | Dummy Table for Selections |
| RSIOTAB01 | Table for Setting Up Master Data Delta |
| ROIST | Name of the InfoSources |
| RSTMETYPE | Texts for key figure types |
| RSTREPLED | Texts for reporting ledger |
| RSAOLTP_DSWRITE | Generated Reports for File Output |
| RSTVTDETL | Texts for detailing per value type |
| ROIDOCPRMS | Control parameters for data transfer from the source system |
| ROVERCUSTA | Attributes for Customers in Verification Scenario |
| RSSGTPDIR | BW generation tool: Directory of the generated programs |
| ROOSGENQVF | Field Descriptions for Extract Structure Versions |
| ROOSFIELD | DataSource Fields |
| ROAPPL | BW: Application Components |
| ROSTOP | Interruption of Current Load Process |
| RSSGTPCLA | BW Generation Tool: Program Class |
| ROMSDIOBJ | BIW: Assignment of master data attributes to InfoObjects |
| AQBWCAT | InfoSource Catalog (SAP Query) Customer |
| AQBWFCAT_SAP | Field catalog for InfoSources (SAP Query) used by SAP |
| RSADMIN | Data import administration settings |
| RORQSTPRMS | Protokolltable Request |
| RODCHABGEN | Generated objects for the basic characteristic |
| RSBASIDOC | Assignment of source systems to BIW systems incl. IDoc type |
| ROOSOURCE | Table Header for SAP BW OLTP Sources (Relevant From 2.0) |