Useful Tables for BW Reporting

Tables for BW Reporting:

SAP... its all just tables and programs right? Sounds pretty easy, a couple of 1s here and few 0s over there and then you have a high powered analytical datewarehouse. Works for me.

I have this pessimistic theory that as technology grows we will be so focused on growing new technologies that we will forget the basic principles that lead to these nascent developments. For instance, you dont think about how or why the database software works, it just does. But if something at that fundamental level became corrupt everything above that layer would cease to work.

Much like the engine in your car. Drivers probably give about 5 seconds thought about their car engine in a given year. But features like satellite radio, heated seats, and sun roofs seem to garner all the attention. Most drivers can tell you every detailed function about each of the buttons on the radio, but probably couldnt point out a spark plug if asked.

Long tangent, sorry.

Anyway, we use abstraction layers to simplify some complex technologies. Query designer, Visual Composer etc etc. However, when things don't work it really helps to know 'whats under the hood'. Below is a list of some helpful frontend tables to grab technical IDs (useful when troubleshooting transports) and text descriptions in bulk, amongst other things.

For homework, try using SE54 to create some nice views, then send me the view definitions!

Queries
RSZELTDIR Directory of the reporting component elements
RSZELTTXT Texts of reporting component elements
RSZELTXREF Directory of query element references
RSRREPDIR Directory of all reports (Query GENUNIID)
RSZCOMPDIR Directory of reporting components

Workbooks
RSRWBINDEX List of binary large objects (Excel workbooks)
RSRWBINDEXT Titles of binary objects (Excel workbooks)
RSRWBSTORE Storage for binary large objects (Excel workbooks)
RSRWBTEMPLATE Assignment of Excel workbooks as personal templates
RSRWORKBOOK 'Where-used list' for reports in workbooks

Web templates
RSZWOBJ Storage of the Web Objects
RSZWOBJTXT Texts for Templates/Items/Views
RSZWOBJXREF Structure of the BW Objects in a Template
RSZWTEMPLATE Header Table for BW HTML Templates