SAP BW TABLES January 16, 2009
Posted by Ajay in BW TABLE, Uncategorized.Tags: SAP BW TABLES
trackback
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 |
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 |
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 |
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 |
|
RSSELDONE |
InfoPackage selection and job program |
| 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 |
Web Item |
|
| RSZWITEM |
Header Table for BW Web Items |
RSZWMDITEM |
BW Web Metadata: Template Item ( Dataprovider, Item, … ). |
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 |
| Table Name | Description |
| TOBJ | Authorization Objects |
| TACT | Activities which can be Protected (Standard activities authorization fields in the system) |
| TACTZ | Valid activities for each authorization object |
| TDDAT | Maintenance Areas for Tables |
| TSTC | SAP Transaction Codes |
| TPGP | ABAP/4 Authorization Groups |
| USOBT | Relation transaction > authorization object |
| USOBX | Check table for table USOBT |
| USOBT_C | Relation Transaction > Auth. Object (Customer) |
| USOBX_C | Check Table for Table USOBT_C |
User Tables
| Table | Description |
| USR01 | User master record (runtime data) |
| USR02 | Logon data |
| USR03 | User address data |
| USR04 | User master authorizations |
| USR05 | User Master Parameter ID |
| USR06 | Additional Data per User |
| USR07 | Object/values of last authorization check that failed |
| USR08 | Table for user menu entries |
| USR09 | Entries for user menus (work areas) |
| USR10 | User master authorization profiles |
| USR11 | User Master Texts for Profiles (USR10) |
| USR12 | User master authorization values |
| USR13 | Short Texts for Authorizations |
| USR14 | Surchargeable Language Versions per User |
| USR30 | Additional Information for User Menu |
| USH02 | Change history for logon data |
| USH04 | Change history for authorizations |
| USH10 | Change history for authorization profiles |
| USH12 | Change history for authorization values |
| UST04 | User masters |
| UST10C | User master: Composite profiles |
| UST10S | User master: Single profiles |
| UST12 | User master: Authorizations |
Good work buddy !!
very Good Job ! it was very helpful for me to resolve many issues
is there a transaction to list all those tables ?
You can use transaction code se11 / se12 /se16 , then filer by RS* and you’ll be able to view sap bw system tables.
I’ve been using this page a lot recently thx you very much it is very very VERY useful !!!
Very good job!!
good job done sir!!!!
Good website
`is there any table which gives the data flow from DS to Query?
Please do let me know.
Regards
Ram
Great Work!!…
Very good!
Reblogged this on My Sap Experience.
very handy
Wonderful collection of tables….Thanks a lot.
Good work
Good Job.