jump to navigation

SAP BW TABLES January 16, 2009

Posted by Ajay in BW TABLE, Uncategorized.
Tags:
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
About these ads

Comments»

1. Raghavendra - April 6, 2010

Good work buddy !!

2. Samira DAHMANI - July 22, 2010

very Good Job ! it was very helpful for me to resolve many issues

3. Samira DAHMANI - July 22, 2010

is there a transaction to list all those tables ?

4. Ajay - September 16, 2010

You can use transaction code se11 / se12 /se16 , then filer by RS* and you’ll be able to view sap bw system tables.

5. leCLEMS - February 17, 2011

I’ve been using this page a lot recently thx you very much it is very very VERY useful !!!

6. JP - April 7, 2011

Very good job!!

7. Kumaran - July 20, 2011

good job done sir!!!!

8. Mallikarjun - October 23, 2011

Good website

9. ram - November 28, 2011

`is there any table which gives the data flow from DS to Query?
Please do let me know.

Regards
Ram

10. Jana - December 13, 2011

Great Work!!…

11. hs - December 19, 2011

Very good!

12. IamthatIam - May 24, 2012

Reblogged this on My Sap Experience.

13. Aravind Gunta - June 17, 2012

very handy

14. Rajani - July 19, 2012

Wonderful collection of tables….Thanks a lot.

15. naveen - August 9, 2012

Good work

16. Prasad B - September 13, 2013

Good Job.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 37 other followers

%d bloggers like this: