Here is a list of important 749 SAP standard tables used with SAP Business Explorer in BW component (SAP BW-BEX) coming under SAP BW (Business Warehouse) Module. You will get more technical details of these SAP BW-BEX tables by clicking on the respective table name link.
Index Table for Log Archiving for BI Authorizations
BDS: File Name for Last Check-Out
BDS: Check-Out Data for a Physical Information Object
BDS: Table for Document Contents (Import/Export)
BDS: Instances of Logical Information Objects
BDS: Descriptions of Logical Information Objects
BDS: Attribute Values of Logical Information Objects
BDS: Outgoing Relationships of Logical Information Objects
BDS: Incoming Relationships of Logical Information Objects
BDS: Files of Physical Information Objects
BDS: Outgoing Hyperlinks from Physical Objects
BDS: Instances of Physical Information Objects
BDS: Use of Target Anchors in Physical Objects
BDS: Attributes of Physical Information Objects
BDS: Outgoing Relationships of Physical Information Objects
BDS: Incoming Relationships of Physical Information Objects
BDS: Relationship Instances
BDS: Relationship Attributes
BDS: Link Table Default for Undefined Classes
Header table for bookmarks created via ABAP BICS
Persistance for the Test Tool
Details on Attribute/Key Figure Blocks
Texts for Language-Dependent User Guide
Template for Query Processing
Analytical Model: Directory for InfoProvider and BIA Index
Analytical Model: Mapping of InfoObject to TREX Attributes
Directory of Generated Analytic Models
Shared Memory for Analytical Model
Control of MultiProvider Hint
Directory of MDX Commands
Fixed Schemata for XML for Analysis
User-defined menu entries
Texts for user-defined menu entries
Control Table That Customer Can Change (Tenant-Specific)
Customizing Table General BW
Analysis Office: Primary Object Table
Analysis Office: Object Description
Analysis Office: Dependent TLOGO Objects
Analysis Office: Properties
Requirements for APO interface
BW: Directory of the InfoCube Sender
Fixed Mapping for BW-R/RI
BW: Texts for InfoCube Receiver
BW: Cluster Table Info. System
Fixed Mapping for BW-R/RI
BW: Directory of the Query Sender
BW: Texts for Query Receiver
URL for Transaction RSRR in the Source System
BW: Web / Report Designer common Customer texts pool
CAF Entity service metadata
Lock Table for Summarization (DB with Dirty Read)
Control Table for Conversion of ICs with ncumtim = parttim
Administration of Requests to be Deleted When Compressing
Table for RSCDS SHM Cluster
Contains Test Scenarios for Program RSDR_ARCH_CHECK
Actions that were triggered for the summarization
Configuration of stored procedure
Query View: Links Old BDS Key with New View ID
Parameter for Publishing on Crystal Enterprise
CR: Table of Report Texts
CR: Table of URLs / Languages
Conversion Table for Euro Conversion
Trace: Currency Translation
Currency Translation Types
Texts for currency translation keys
Directory of Data Access Services
Local Properties: Data Access Services
Service Parameter of the Data Access Service
Descriptions for Service Parametesr of the DAS
Value of the Service Parameter of the Data Access Service
Descriptions for Data Access Services
Data Access Service Provider by Object Type (Tlogo)
Text Table for the DAS Provider
Variants for Data Access Service Provider
Texts for Variants of the Data Access Service Provider
Status of the active aggregates in the InfoCube
Management Table for the Aggregate Check
Selection Options for the Aggregate Check
Text Table for the Aggregate Check
Description of the aggregates
Directory of the aggregates
Directory of the aggregates
Table to define lock argument
Status of change run for aggregates
InfoObjects of BIA Index Type (Where-Used List)
Status Table of Index in BIA
BIA Master Data Indexing Job Log
Master Data Indexing Job – Status
Table to define lock argument
Properties of BWA InfoProviders
XSTRING in the most recent version of the BWA object
WRITEINDEX Class for a Table
BWA Index-Specific Indexing Options
Table with InfoObject whose master table has been changed
Composite Provider Directory
Composite Provider Directory
Texts for Composite Providers
Composite Provider: Cross References
Aggregates that should be refilled after correction
Parameter for a Repartitioning Request
Temporary table for the results of a hierarchy query
TREX Destinations for Analytical Indexes
Change Zeit of Master Data per Characteristic
Statistics data BW for aggregate selection and accounting
Statistics data OLAP: Navigation step / aggregate definition
Counter for BIA Usage per InfoProvider
BW Statistics: Data on Condensing Run InfoCube
Filter vals during query execution for selected InfoObjects
BW Statistics: Data on Deletion of Data in InfoCube
OLAP Statistics: Detail Level
OLAP Statistics: Detail Level, Texts
Data Manager Query Statistic Records
Datamanager Query Statistic Records for Clustered Access
Size of tables associated to a dta
Table for WHM Statistics. Details DTP
Query Filter Statistics: Monitored InfoObjects
InfoProvider for Query Filter Statistics
BW Statistics (OLAP), Key Figures for the Events
OLAP Statistics Events, Texts
Extractor BW statistics: Time of last delta load
OLAP Statistics:Handle Types (Runtime Objects)
OLAP Statistics: Handle Types (Runtime Objects), Texts
BW Statistics (OLAP), Information by Runtime Object
BW Statistics (OLAP), Information by Navigation Step
Logging Table for OLAP Statistics
User Names for which Logging in the OLAP Stats Is On
Objects for Query Runtime and Their Statistic Properties
Link from SAPPASSPORTGUID to Query Runtime Statistics
Custumizing of data slice statisitcs
OLAP Statistics: (Navigation) Step Types
OLAP Statistics: (Navigation) Step Types, Texts
Statistic Data for Process for TREX Aggregates
Detailed Statistics from TREX Server During Query Calls
Detailed Statistics for the TREX Server
TREX Statistics Table for DB Buffer (Detail)
TREX Statistic Table for DB Buffer
Statistics Data: BW for Warehouse Management
Statistics for InfoCube Write
Generated (Temporary) Programs from area RSDD
Date and Language for Polestar
Selected CKFs/RKFs for Providers
Authorized Users for Polestar
List of Implementations for Authorizations
User Groups for SBO Explorer
Conversion Indices in Polestar
MultiProvider for Polestar – Unused Objects
MultiProvider for Polestar – Filter
Hierarchies for Use in Polestar
Polestar Hierarchy Indexes
Assignment of Hiers to InfoProvider/InfoObject Combination
Dependency of InfoProvider to Chabasnm
InfoProvider in Polestar and Batch Job
Hidden Key Figures per Provider
MultiProvider Delta Criteria for Polestar
Additional Settings for Indexing an HPA Index
Virtual InfoProviders with BIA Cache and Class Name
Header for BIA Checks for Data Consistency
Settings for BIA Monitor Check Set
Settings for ‘K’ Check – Key Figure Selection
Settings for ‘Q’ Check – Key Figure Selection
InfoObjects for BIA Indexes Reindexed After Change Run
Administration of the TREX Aggregates
No longer used as of BI 7.10; now for lock object only
E-Mail-Addresses = Recipient for Canceled HPA Queries
Lock Table for HPA Aggregates
Error Recording for Queries on HPA
Lock Table for Indexes of HPA Aggregates
Load Jobs That Run During Activation of the HPA
DIMIDs Required for BIA Recovery
New DIMIDs for Dimensions in HPA Aggregates
MD Upload: SIDs for InfoObjects in TREX Aggregates
New SIDs for InfoObjects in TREX Aggregates
SID Queue for Backup and Recovery
CHAVLs of New Text for BIA Index
CHAVL of new Texts for BWA index (with long chavls)
RFC Destination for a User for Reading from TREX
List of BIA Data Snapshots
Text Table for BIA Data Snapshots
Status of Tables/Indexes in BIA
Actions Triggered from the HPA Monitor and Its Status
Get status (RNSID) of a BIA index during backup
R/3 System ID from Which BIA/TREX Statistics Are Read
Messages from the BIA Index Check
WRITEINDEX Class for a Table
HPA Adminstration Activities
Table for the Maintenance of Error Messages from HPA
BW Accelerator Monitor Actions
Logging of BWA Admin Actions
BWA Action Currently Executed from BWA Monitor
BW Accelerator Monitor Checks
BW Accelerator Monitor Detail Headings
Lock Table for BWA Actions
Administration table for persistent locks on temporary no.
Device Properties in BW Web Reporting
Matching of UserAgentString to Device in BW Web Reporting
Assignm. of Render (Device Class) to Device in BW Web Report
Cluster Table: Test Data and Resutls for Automatic Tests
RSDP: Administration of MD Objects
Index of Dummy Aggregate from InfoCubes with MOLAP
RSDP: Relationship MOLAP Cubes – MOLAP Dimensions
DM-API: Administration of Temporary Tables
RSDP: Handling of Overlong Names
RSDP: List for Processing MOLAP Objects
Persistent List of InfoCubes
Listcube: Transfer of Parameters in Batch Mode
Reports of Deletes Started in the Background
Test Parameter (CRM Segmentation)
Test Data for RSDRC DS Test
Table with the query-id of the calc-scenarios to be deleted
Test Data for RSDRC Partitioning
Test Data RSDRI (External Read Interface)
Test Data RSDRI (External Read Interface)
Log Delete Actions (Header Table)
Log Delete Actions (Positions)
Management of Requests to be Deleted with Request Deletion
Test Scenario for Archiving Check
LRU-Buffer for the Hierarchy Processing
Table for Lock Object E_RSDRHDELETE (1 Deletion Job Only)
Table for Calculating Unique Sequence Numbers
LRU-Buffer for the Hierarchy Processing
Data Federator: Configuration
Test Data RSDRI (External Read Interface)
Test Data RSDRI (External Read Interface)
Test Data RSDRI (External Read Interface)
Test Data RSDRM (Multiprovider Split)
Test Data RSDRP (Parallelizes Query)
Traces Generated with RSDRT_INFOPROV_RANDOM_QUERIES
DataStore Test Data Without BEXFL
Test Data RSDRV (Virtual Cubes)
Test Data RSDRV (Virtual Cubes)
Test Data RSDRP (Parallelizes Query)
BI AS Authorization Reporting: Generated Authorizations
Analysis Authorizations BI: Logging Active for User
Header Table for TLOGO BI Authorization BIAU
Table for assignment of authorizations to an environment
Status of Authorization Hierarchies
Authorization Hierarchies Changes Change Log
Status of Authorization Hierarchies
Storage for Authorizations Logs xml
Analysis Authorizations BI: Logging Active for User
LOPD: Maintenance of LOPD Groups
LOPD: InfoProviders with Personal Data
LOPD-Relevant Objects Within Queries
LOPD-Relevant Objects Within Queries
RSEC: Table contains the last archived date
Change Documents for Document Texts
BI AS Authorizations: Assignment of User Auth
BI AS Authorizations: Assignment of User Auth (Change Log)
Authorization Value Status
Authorization Value Change (Change Log)
Authorization Value Status
RSEC: Table with Archived Authorizations
Buffer for Migration Data: Authorization Objects
Intermediate Storage for Migration: User
Intermediate Storage for Migration: User
Query/Easy Query Assignment
Relation Name to external, beautified Name
Report Designer: Database Table
Language-Specific Texts for Enterprise Reports
Report Designer: Header Table BEx Report
Report Designer: Text Table
Report Designer: Reusable Elements (Template/Report Element)
Report Designer: Header Table BEx Report Elements
Report Designer: Text Table for Reusable Elements
Lookup Table for the Object ID of External Cubes
Data for the BW Front-End Initialization
“Temporal Hierarchy Join” – Types
Texts for the “Temporal Hierarhcy Join” Types
Data Entry Configuration Store
BW: Cluster table info. system
Reporting Agent: Cluster Table
Cluster Table for Storing Web Reporting Components
BW: Cluster table backup data
BW: Cluster table info. system
KPI Attribute: Header Data
KPI Attribute: Header Data Texts
Valid Attributes for Each Usage Type of KPI Infrastructure
KPI: Language-Dependent Attributes
KPI: Alias Call for Evaluation of Component
KPI: Data Access Services with Alias Names
KPI: Data Access Services Input Parameters
KPI: Texts for Input Parameters
KPI: Values for Input Parameters
KPI Variant: Header Data Texts
KPI Variant: Input Parameter Values
KPI Variant: Threshold Values
KPI Watchlist: Header Data
KPI Watchlist: Texts for Header Data
Workspaces: Folder (Tree Structure)
Local System Data for Workspace Folders
Workspaces: Folder, Descriptions
Workspace/Folder Assignment
Mapping from Original to Transient Query
StW / BW Workspace Assignment
Keyfigures copied to a CompositeProvider
Historical Link Proposal Results
Execution Instances for Import Processes
References (with Any Object Types)
Statistical Data for Processes for an Object
Conversion Table for the Alpha Conversion of ODS Objects
Fill level of a MultiProvider and its PartProviders
Mapping of logical systems after BDLS in InfoObject 0LOGSYS
Header Information for BEx Personalization Data
Data for BEx Open Dialog (Core)
Data for Variable Values (Core)
Data for Web Templates (Core)
Table for maintaining prec server workload
Table for maintaining prec server workload
Assignment of users to user groups
Log-Table for the Batch Runs of the ResultSet Precalculation
Parameter Table for Bucket Setting
Text Table for the BB Settings Parameters
Display Auth. for Precalculated Templates by Redirect URL
Log Table for the Batch Runs for Precalculating Template
Global Settings for Batch Printing
Parts of the Batch Printing Setting
Batch Printing Setting Column Headers
Report Agent BP Transport Copy/Versioning of rtxth
Report Agent BP Transport Copy/Versioning of rtxth
Report Agent BP Transport Copy/Versioning of rtxtl
Report Agent BP Transport Copy Versioning of rtxtt
Parameter Table for Template Setting
Text Table for Parameters of BT Settings
Parameter Container for Follow-Up Action SAP Alert Mgt.
Drill Characteristics for the Exception Reporting Setting
Follow-Up Actions for Reporting Agent Exception Reporting
Log Information for an RA Setting
Log Table for Batch Runs of Exception Reporting
Table of Logged Data Cells
Log Entries for every Exception
BW: Cluster Table for Report Agent Exception Log
Parameter Table for Exception Setting
Text Table for Parameters of ER SEttings
Details of Follow-up Actions
Cluster table for storing the key for the DataStore
Directory of the Report Agent Jobs
Data for the Message Object
Data Store for Result Sets for MDX Precalculation
Log Table for the Batch Run of MDX Precalculation
Parameter Table for MDX Setting
Text Table for Parameters of MDX Settings
Scheduling Packages for the Report Agent
Text Table for the Report Agent Packages
Parts of a Report Agent Job
Settings for the Report Agent
Text Table for the Report Agent Settings
RA Settings for Calculating Buckets
RA Settings for Precalculating Templates
Text Table for Template RA Settings
Attribute table for print settings
Attribute table for print settings
Dimension table including the print settings
Dimension table including the print settings
Attribute table for print settings
Attribute table for print settings
Global print settings for printing
Global print settings for printing (texts)
Alternative Currency Display in BEx
Table with deleted report programs
Documents for Broadcasting
Documents for Broadcasting: Attributes
Documents for Broadcasting: Content
Broadcasting Framework: Producer/Distributor Attributes
Broadcasting Framework: Texts for Attributes
Dependencies Between Attributes
Broadcasting Framework: Attribute Groups of Classes
Broadcasting Framework: Attribute Groups of Classes -Texts
Posible Values for Class Attributes in Broadcasting Framewk
Text Table for RSRD_ATTR_VALUE
Document Types in Broadcasting Framework
Text Table for Document Types
Possible Output Formats for This Distribution Type
Document Attributes Generated from a Class
Broadcasting Framework: Texts for Document Attributes
Exception Report: Definition of Layout (XML Conversion)
Texts for Layout in Exception Reporting
Exception Reporting Document Type
Text Table for RSRD_ER_DOCTYPE
Hash Strings of BI Data during Precalculations
Frequency of Use of Broadcast Targets
Object Types Supported in Broadcasting
Object Types, Texts Supported in Broadcasting
Output Formats in Broadcast Framework
Text Table for Output Formats
Personalization of Texts – Mapping Table for Hash Code
Registration of Settings to Events (Broadcasting)
Permitted User for Registering Settings for Events
Texts for Settings in Broadcasting Framework
Nodes from Broadcast Settings
Attributes for Nodes from Broadcast Settings
Language-Dependent Attributes for Nodes from Settings
Text table for executable nodes in the favorites
OLAP Relevant Information for the Hierarchies
Structure for Appropriate Lock Object for Hierarchies
Time Intervals with Time-Dependent Hierarchies
Hierarchy interval for the OLAP processor
SIDs, that are not in the inclusion tables (>= BW 7.40)
Parametrization for a query, workbook, webapplication, pla
Variant groups for batch printing
Text for the variant group (batch printing)
Assignment of variant group to variants for start in batch
Variants to variant groups (batch printing)
Position Table: Test Runs
Web Output Module Directory
Web Output Module Attributes
Dependency Among Attributes / Attribute Values
Web Output Modules Texts and their Attributes
Generation Status for Non Client-Specific Queries
Status of Query Generation
Nodes with URLs, links, etc.
Text table for links, URLs and other objects
SAP Portals Unification Server for BW Source System
TRACE table for editing the favorites
Contains the description of the individual trace steps
Directory of the implementations for transient meta data
InfoSource Catalog (SAP Query) Customer
Directory of Variants for Queries and Selection Objects
Directory of all Tables for Variable Type Table
Directory of all Tables for Variable Type Table
List of binary large objects (Excel workbooks)
Titles of binary objects (Excel workbooks) in InfoCatalog
Assignment of Excel Workbooks to Personalized Versions
Storage for binary large objects (Excel workbooks)
Assignment Excel workbooks as personal templates
‘Where-used list’ for reports in workbooks
OLAP: Table Lock Arguments
Administration Parameters for OLAP Cache
Cache Cluster Storage for Data
Cache, Cluster Table: Data Storage
Cache: Data Store, Pattern for Shared Memory and Buffer
Cache, BLOB Tables: Storage for Selections
OLAP Cache Table for Saving Log Entries
Table for Saving Messages
Cache: Storage for Query and Time of Creation
OLAP: Table Lock Arguments
Cache, BLOB Tables: Storage for Selections
Table for Lock Object E_RSRCACHESHRINK (1 Deletion Job Only)
Statistics for Cache Entries
Statistics for Cache Shrink Process
Statistics for Cache Entries for Shared Objects
Statistics for Cache Entries for Shared Objects
Cache Directory: Storage for Variables and Hierarchies
Cache, BLOB Tables: Storage for Variables and Hierarchies
MDX: Dialog: Store for Model
MDX: Dialog: Store for Statements
MDX: Dialog: Store for Statements (Text Table)
Management of Logical Systems for WB Precalculation
Text Table for Precalculation Servers
Persistant Precalculation Queue
Stored Precalculation Server Broadcasting Settings
Timeout For Workbook Precalculation
Transient Sources for BEx
Texts for Transient Source Engines
Definition of the Authorizations for Hierarchies
BW Reporting Authorizations: Hierarchy Nodes
BW Reporting Authorizations: Generating Authorizations
BW Reporting Authorizations: Generated Authorizations
Authorization Trace BW Reporting
Authorization Check BW: Trace Active for User
Authorization Check Reporting: Single Values in Authorizatn
Description of SDK Connections
Table Stores Generic UDConnect Mapping Info
Information on SDK Resource Adapters in BW
Parameter perisitence for dap generation
Communication interface between batch diag process
Management Table for Authorization Objects
Maintenance Areas for TREX Index
BW: Cluster table info. system
Transformations for Test Utilities
Trace Tool: Call Stack Table of Trace
Trace Tool: CATT Trace Specific Properties
Trace Tool: Check Select Table
Trace Tool: Table of Checkable Program Objects
Delta Entry of Released Report Data
Delta Entry of Released Report Data Elements
Attributes for Defects Found with BI ATR
Exception messages for tests
RSTT: Table for Indexes That Are Now Free
Functional Cover of Test Units
Trace Tool: Selection of Functionality to Be Tested
Store for Special Traceable Object Instances
Instance Parameter of the Recorded Calls
Table for Locking Trace Objects Using ID
Lock Table for Parallel Execution of BW_BEX – Traces
Lock Table: Active Trace incl. Your Test Objects
RSTT: Table for Locking Traces, Packages and Jobs
Attributes for Test Entries
Extraction Logs of Test Results
Archive for Results of Test Sequences
Temporary Store for Test Results
Archive for Results of Test Units
Trace Tool: History for Trace Objects
Responsibility for Test Objects
Trace Tool:General Text Table for Standard Object Attributes
Temporary Trace Object Storage
Header Information for OLAP Trace
Store for Global Parameters
Trace Tool: Table of Reference Data for CATT Trace
Trace Tool: Variant Table of Reference Data
Table of Existing BI Reports for RSTT Reporting
Table of Existing BI Reports for RSTT Reporting
Test Results from the CATT Trace Checks
Trace Tool: Description of Trace Sequence
Search Table for Attributes of RSTT Objects
Trace Tool:Mapping Table for Text-Relevant Object Attributes
Trace Tool: Trace Job/Test Job Table
Trace-Tool: Text for Trace Jobs
Trace Tool: Basis Info About Trace Packages
Trace Tool: Texts for Trace Packages
Store for Test Result Patterns
Versions of Test Result Patterns
Trace Tool: Table Trace Attribute
Trace Tool: Table Trace Descriptions
Header Data of Object Transformations
Texts for Test-Related Objects
Trace Tool: Table for User Activation Settings
Trace Tool: Test Area Assignment to User in Trace Tool
Trace Tool: Variants Table
Trace Tool: Variants Table
Trace Tool: Variants Text Table
Trace Tool: Variants Text Table
Logging for Execution As Other User
Quantity Conversion Types
Texts for Quantity Conversion Types
Value help services user setting A segment
Value help services user settings List of display Attributes
Value help services user List of Favourites and History
Value help services user setting A segment
Text table for Value help services personal value sets
Local Properties: Workspaces
Workspaces: Local Objects
Workspace: Authorization Profiles
Workspace being edited by the user
Workspaces: Cross References
Workspaces: Cross References of Excluded InfoObjects
Header Text table for Xcelsius object
Text elements of an Xcelsius object
Reference objects (Dependent) of Xcelsius
Definition of a formula element
Query Designer: Directory of Cells
Change history of reporting components
Directory of reporting components
Priorities with Element Collisions
Hierarchical Display of Reusable Query Components
Hierarchical Display of Reusable Query Components (texts)
Attribute selection per dimension element
Directory of the reporting component elements
Priorities with element collisions
Element properties (settings)
Texts of reporting component elements
Multiline Texts from Reporting Components and Elements
Query Designer – Text Verticalization: Element Texts
Directory of query element references
Global Variables in Reporting
Texts of the formula operators
Selection specification for an element
Selection properties of an element
Unique Technical Name for Query Component in SAP Content
Table with Example Description of a Tree Structure
Conversion of Chart Settings from BW 3.0 to BW 3.5
Conversion of Chart Settings from BW 3.0 to BW 3.5
Header Table for BW Web Items
Texts for BI Web Items (7.0+)
BW Web Templates: Language Texts
BI Template Cross references to TLOGO Objects
Header Table of the Bookmarks
Header Table for BW HTML Templates
Texts for Templates/Items/Views
BW Web Templates: Language Texts
BI Template Cross references to TLOGO Objects
Header Table for BW Web Items
Attribute Table of the Items (Contains Search Attributes)
Cross-Reference Table of the Items
BW Web Metadata: Template Item ( Dataprovider, Item, … ).
BW Web Metadata: Binary and Textual Data
BW Web Metadata: Binary and Textual Data
BW Web Metadata: Item Parameter association
BW Web Metadata: Template Item Runtime Mapping
Texts for Web-Items, Commands and Groups
Web Item, Dataprovider and command parameters
BW Web Metadata: Parameter constraints
BW Web Metadata: Parameter Containment
BW Web Metadata: Fixed Values and Value Ranges for Parameter
Map release/ehp/sps information to BI 7.x+ metadata version
Buffer for Translation from Mime Repository Path Accrd to IO
Storage of the Web Objects
Texts for Templates/Items/Views
Structure of the BW Objects in a Template
OBSOLETE ! Storagetable of Report Designer Reports
Header Table for BW HTML Templates
BW Web Templates: Language Texts
BI Template Cross references to TLOGO Objects
Header Table for BW Views
Conversion: URLs for Roles
Conversion: URLs for MiniApps
Conversion: URLs for Roles
Table of Deleted BDS Items and Views
Table of Deleted BDS Templates
Multi Client Publishing configuration Table
Enterprise RFC Destinations
Details on background publisher jobs
Active languages in target system
Content Administration Parameter definitions
Role to target system mappings
Content Administration target system aliases
Click here to know details about SAP transaction codes used with Business Explorer in BW.