Listing of commonly used tables in SAP BI
Listed below are some of the tables commonly used in SAP BW 7.x - however the same has not been tested in NW2004s and please make corrections if required. Some of this material has gone through a lot of eyeballs before making it to the final list and could contain some older references / incorrect references , however most of them have been validated.
Transfer Structure |
|
---|---|
RSTS | Transfer Structure List |
RSTSFIELD | Transfer Structure fields |
RSTSRULES | Transfer Structure rules |
RSAROUTT | Text name of Transfer Routine |
DD03T | Text for R/3 Transfer structure Objects |
Update Rules |
|
RSUPDROUT | Update rules List |
RSUPDDAT | Update rules with routines |
RSUPDKEY | Update rule key fields |
RSUPDINFO | InfoProvider to Infosource correlation |
Embedded ABAP coding for Transfer / Update Rules |
|
RSAABAP | ABAP source code per object routine |
InfoPackage |
|
RSLDPIO | Links datasource to infopackages |
RSLDPIOT | InfoPackage Text Description |
RSLDPRULE | ABAP source code for InfoPackages |
RSLDPSEL | Hardcoded selections in InfoPackages |
RSMONICDP | Contains the request-id number by data target |
RSPAKPOS | List of InfoPackage Groups / InfoPackages |
ProcessChain |
|
---|---|
RSEVENTCHAIN | Event Chain Processing Event Table |
RSEVENTHEAD | Header for the event chain |
RSEVENTHEADT | Header for the event chain |
RSPCCHAIN | Process chain details |
RSPCCHAINATTR | Attributes for a Process Chain |
RSPCCHAINEVENTS | Multiple Events with Process Chains |
RSPCCHAINT | Texts for Chain |
RSPCCOMMANDLOG | System Command Execution Logs (Process Chains) |
RSPCLOGCHAIN | Cross-Table Log ID / Chain ID |
RSPCLOGS | Application Logs for the Process Chains |
RSPCPROCESSLOG | Logs for the Chain Runs |
RSPCRUNVARIABLES | Variables for Process Chains for Runtime |
RSPC_MONITOR | Monitor individual process chains |
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 |
RSZRANGE | Selection specification for an element |
RSZSELECT | Selection properties of an element |
RSZELTDIR | Directory of the reporting component elements |
RSZCOMPIC | Assignment reuseable component <-> InfoCube |
RSZELTPRIO | Priorities with element collisions |
RSZELTPROP | Element properties (settings) |
RSZELTATTR | Attribute selection per dimension element |
RSZCALC | Definition of a formula element |
RSZCEL | Query Designer: Directory of Cells |
RSZGLOBV | Global Variables in Reporting |
RSZCHANGES | Change history 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 |
InfoObject |
|
RSDIOBJ | Directory of all InfoObjects |
RSDIOBJT | Texts of InfoObjects |
RSDIOBJ | Directory of all InfoObjects |
RSDIOBJT | Texts of InfoObjects |
RSDATRNAV | Navigation Attributes |
RSDATRNAVT | Navigation Attributes |
RSDBCHATR | Master Data Attributes |
RSDCHABAS | Basic Characteristics (for Characteristics,Time Characteristics, and Units) |
RSDCHA | Characteristics Catalog |
RSDDPA | Data Package Characteristic |
RSDIOBJCMP | Dependencies of InfoObjects |
RSKYF | Key Figures |
RSDTIM | Time Characteristics |
RSDUNI | Units |
InfoCube |
|
---|---|
RSDCUBE | Directory of InfoCubes |
RSDCUBET | Texts on InfoCubes |
RSDCUBEIOBJ | Objects per InfoCube (where-used list) |
RSDDIME | Directory of Dimensions |
RSDDIMET | Texts on Dimensions |
RSDDIMEIOBJ | InfoObjects for each Dimension (Where-Used List) |
RSDCUBEMULTI | InfoCubes involved in a MultiCube |
RSDICMULTIIOBJ | MultiProvider: Selection/Identification of InfoObjects |
RSDICHAPRO | Characteristic Properties Specific to an InfoCube |
RSDIKYFPRO | Flag Properties Specific to an InfoCube |
RSDICVALIOBJ | InfoObjects of the Stock Validity Table for the InfoCube |
RSDCUBEMULTI | InfoCubes concerned with MultiCube |
RSDICMULTIIOBJ | MultiProvider: Selection/Identification of InfoObjects |
Aggregates |
|
---|---|
RSDDAGGRDIR | Directory of Aggregates |
RSDDAGGRCOMP | Description of Aggregates |
RSDDAGGRT | Text on Aggregates |
RSDDAGGLT | Directory of the aggregates, texts |
ODS Object |
|
RSDODSO | Directory of all ODS Objects |
RSDODSOT | Texts of all ODS Objects |
RSDODSOIOBJ | InfoObjects of ODS Objects |
RSDODSOATRNAV | Navigation Attributes for ODS Object |
RSDODSOTABL | Directory of all ODS Object Tables |
PSA |
|
RSTSODS | Directory of all PSA Tables |
DataSource (= OLTP Source) |
|
ROOSOURCE | Header Table for SAP BW DataSources (SAP Source System/BW System) |
RODELTAM | BW Delta Procedure (SAP Source System) |
RSOLTPSOURCE | Replication Table for DataSources in BW |
InfoSource |
|
RSIS | Directory of InfoSources with Flexible Update |
RSIST | Texts on InfoSources with Flexible Update |
RSISFIELD | InfoObjects of an InfoSource |
Communications Structure |
|
RSKS | Communications Structure for InfoSources with Flexible Update |
RSKS | Communications Structure (View) for Attributes for an InfoSource with Direct Update |
RSKSFIELD | Texts on InfoSources with Flexible Update |
RSISFIELD | InfoObjects of an InfoSource with Flexible Update |
Transfer Structure |
|
RSTS | Transfer Structure in SAP BW |
ROOSGEN | Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System) |
Mapping |
|
---|---|
RSISOSMAP | Mapping Between InfoSources and DataSources (=OLTP Sources) |
RSOSFIELDMAP | Mapping Between DataSource Fields and InfoObjects |
InfoSpoke |
|
RSBSPOKESELSET | InfoSpoke Directory and Selection Options |
RSBSPOKEVSELSET | InfoSpoke Directory with Selection Options and Versioning |
RSBSPOKE | List of all InfoSpokes with attributes maintained with transaction RSBO which include the name of |
RSBSPOKET | List of all InfoSpokes with the Short & Long Descriptions (only one of these can be maintained). |
RSBSTEPIDMESS | Contains all the messages that have been recorded during the execution of an InfoSpoke. This table can |
SAP BW Statistics |
|
RSDDSTAT | Basic Table for InfoCubes/Queries |
RSDDSTATAGGR | Detail Table for Aggregate Setup |
RSDDSTATAGGRDEF | Detail Table of Navigation for each InfoCube/Query |
RSDDSTATCOND | InfoCube Compression |
RSDDSTATDELE | InfoCube Deletions |
RSDDSTATWHM | Warehouse Management |
Misc |
|
RSFEC | BW Frontend Check. Useful for checking the installed SAP GUI versions on user machines. |
RSSELDONE | InfoPackage selection and job program, there in field UPDMODE the update status (INIT/DELTA/FULL) |
RSPSADEL | PSA Table deletion |
TBTCP | Job Schedule Definition |
TBTCO | Job Schedule Result |
RSMONMESS | Monitor Messages |
RSERRORLOG | Check loading errors in table |
V_RSZGLOBV | Report Variables view table |
DEVACCESS | Developer Keys table |
TSTC | All Transactions in the system |
RSDDAGGRDIR | Directory of the aggregates |
ROIDOCPRMS | Control parameters for data transfer from the source system |
SMEN_BUFFC | Objects in User's Favorites |
TSTCT | Transaction Codes with Text |
DD03L | field names and corresponding data element names |
DD03LT | Description of each data element |
DD02L | All SAP Defined Table Names |
DD02LT | Description of All SAP Defined Table Names |
Web Item |
|
---|---|
RSZWITEM | Header Table for BW Web Items |
RSZWMDITEM | BW Web Metadata: Template Item ( Dataprovider, Item, ... ). |
RSZWITEMXREF | Cross Reference of Web Items |
RSZWMIMEIOBUFFER | Buffer for Translation MIME Rep. to IO |
RSZWOBJ | Storage of the Web Objects |
RSZWOBJTXT | Texts of Templates/Items/Views |
RSZWOBJXREF | Structure of the BW Objects in a Template |
RSZWTEMPLATE | Header Table for BW HTML Templates |
Archiving |
|
RSARCHIPRO | BW Archiving: General Archiving Properties |
RSARCHIPROIOBJ | BW Archiving: General Archiving Properties |
RSARCHIPROLOC | BW ARchiving: General Local Properties |
RSARCHIPROLOCSEL | BW Archiving: Archived Data Area |
RSARCHIPROPID | BW Archiving: Program References of InfoProvider |
RSARCHREQ | BW Archiving: Archiving Request |
RSARCHREQFILES | BW Archiving: Verfified Archive Files |
RSARCHREQSEL | BW Archiving: Request-Selections |
Open Hub Destination |
|
RSBOHSERVICETP | Open Hub: Service Types |
RSBREQUESTDELTA | Open Hub: Cross Reference Outbound/Inbound |
RSBREQUESTMESS | Open Hub: Log for a Request |
RSBREQUID | Open Hub: Requests |
RSBREQUID3RD | Open Hub: Status of 3rd Party Requests |
RSBREQUIDRUN | Open Hub: Table with Status for a Request |
RSBSTRUCTURE | Open Hub: Generated Structures and Tables |
32 Comments
Unknown User (986duq9u)
Arun,
Useful one.Thanks!
Unknown User (jbpjh43)
This is one of the best collection of tables in BW. I appreciate the effort taken. Great job guys
Unknown User (wofvwz3)
This is a great job. Thank you.
Anonymous
Yes, I agree, this is very useful, thanks!
Davide
Former Member
Useful one.Thanks!..gud work
Gennaro Patalano
very good work. Tkanks so much!
Unknown User (b4v0tav)
Very useful Arun. Thank you very much.
Unknown User (t6g1ydf)
Nice work. This is definitely useful. Thanks!
Unknown User (bctgd9q)
I copied content to my ready recknover...........going to useful in most of the developing time.
Really appreciate your effort in right direction (real need)...everyone knows it partialy but you have colladed and helped us all..
Thank you...
Chandiraban singu...
Unknown User (105nmaez4)
Thanks a lot... its indeed very useful
Anonymous
Very HelpFull,
Also two more : E070 and E071.Tables for Transport Requests and Objects in Transport Requests
These can be helpfull.
Regards
Nitin Bhatia
Anonymous
very helpful.
Vinoth Vasudevan
Good Collection..Great Job...
Yogesh Patil
Please add below tables in Process Chain category i.e
rspcvariant.
RSPCVARIANTATTR
RSPCVARIANT
RSPCVARIANTT
RSPCVARIANTT
Regards, Yogesh
Unknown User (nt0a78d)
if you need the complete list (with search function) and additional information of all SAP tables, you can find the at http://Tables.ofSAP.com
Ashok Babu Kumili
Hi,
This Wiki has very good information. Thank you.
Unknown User (qvn4vf1)
Thanks. By the way, I suggest table RSTRANROUTMAP (Rule Type: Routine) is added to the "Embedded ABAP coding for Transfer / Update Rules" section. You can download the ABAP code from a conversion routine using RSAABAP, and find the technical name of the routine using RSTRANROUTMAP.
Martin
Unknown User (nkzsczv)
Roles
AGR_*
Roles tables
AGR_HIER
we can see workbook id´s on a role by on field REPORT, select RRMX
Alexander Kutz
please add also:
InfoSource 7.x
RSKSNEW
New InfoSource
RSKSFIELDNEW
Fields for New InfoSource
Former Member
Thankyou for this information. It has saved a day work while correcting transports.
Former Member
Every moment of the work iused these tables.thanks for ur good information>saving time every thing else.....
Former Member
Thanks a lot. ^^
Unknown User (104y006rj)
Useful overview. Thanks
Former Member
Excellent job, well done!
Anonymous
Tables of Composite and Transiente InfoProvider
RSLTIP - Directory Transient Providers
RSLTIPT - Texts for TransientProviders
RSLTIPXREF - TransientProvider: Cross References
Oliver LIEBE
Hi maintainers,
Great job, thank you.
Just one addition: Could you please correct the entry for key figures (within section info objects). It should be RSDKYF instead of RSKYF with the next update.
Many thanks and best regards.
Anonymous
very useful
venkat yerva
Please update this RSDICHAPRO in Info objects tables list.This is useful to find what property either text or key to display in report.
Former Member
Really Helpful, I have bookmarked this as it is needed for day to day activity.
Fernando Reyna
Very useful information, thank you
Former Member
thanks
Alexandre de Andrade