Listed below are some of the tables commonly used in SAP BI ( NW 2004) - 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
|
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 |
原文出处:
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/BI/Important+Tables+in+SAP+BI+%28+NW2004%29
分享到:
相关推荐
标题"SAP BI 7.0 Important T-Codes List"指的是SAP Business Intelligence 7.0版本中的重要事务代码集合。SAP BI(Business Intelligence)是SAP公司提供的一套全面的数据分析和报告解决方案,用于帮助企业从海量...
saplogon.ini,sapmsg.ini,saproute.ini文件 Plays an important role in SAP Logon configuration. 基于ABAP的登录组 创建登录组需要登录SAP系统,输入事务码smlg、单击新建按钮,名字(PUBLIC_##),##为组号,并...
Choosing the right SAP module and how to develop skills in other modules • Important skills and concepts to focus on when starting your career This book is an extremely valuable resource for many ...
凯恩英语培训中心教你如何巧妙回答英语面试中的重要问题
SAP收款管理的重要商业议题(Important Business Issue)包括: - 增加应收账款的回收比例 - 减少平均收款周期(Days Sales Outstanding,DSO) - 避免坏账的产生 - 提高准时支付的比例 - 降低现金收集成本 - 提供...
Security is the most important aspect of an Oracle BI implementation project and this module covers everything that students need to learn about the security and implementation in the OBI solution.
【SAP Customizing Documentation】是SAP系统实施过程中的一个重要环节,主要涉及到对SAP系统的配置和定制,以适应企业的具体业务需求。SAP作为全球领先的企业资源规划(ERP)软件,提供了广泛的模块来覆盖不同行业...
For Beginners How to navigate around the Excel interface An in-depth look at ... Clear steps on how to write a program and the 5 important questions you must think about before you start to write.
important的样式 #### 背景介绍 在Web开发过程中,我们经常需要动态地改变页面元素的样式。有时候,这些样式是由外部CSS文件定义的,并且某些样式可能使用了`!important`来提高优先级。这在一定程度上限制了...
important`是一个特殊的规则,它用于强调一个样式声明应优先应用,即使有其他选择器试图覆盖它。在深入探讨`!important`的使用之前,我们先了解CSS的优先级规则。 在CSS中,样式的选择器有不同的权重,权重越高,其...
In this project we implement an ETL process (extract, transform and load) and dashboard design in PowerBI for Amazon Top 50 Bestselling Books dataset. Develop a Report by Extracting-Transforming-...
Power management is an important concern in sensor networks, because a tethered energy infrastructure is usually not available and an obvious concern is to use the available battery energy efficiently...
In conclusion, the W958D6NW 256Mb HyperRAM 3.0 x16 WLCSP30 datasheet is a comprehensive resource that provides engineers and developers with the necessary information to effectively utilize this high-...
regular English, and also to help you identify important concepts. l Actual Perl code is typeset in a special monospace font. You'll see this font used in listings and the Input-Output examples, as ...
Annual Reports in Medicinal Chemistry provides timely and critical reviews of important topics in medicinal chemistry together with an emphasis on emerging topics in the biological sciences, which are...
the striking success of deep learning in a wide variety of natural language processing (NLP) applications has served as a benchmark for the advances in one of the most important tasks in artificial ...
The volume offers new insights into a range of fundamentally important topics in network architectures, network security, and network applications. It serves as a reference for researchers and ...