USE RS table !!

最新推荐文章于 2023-02-17 21:34:00 发布

Bruce_yin

最新推荐文章于 2023-02-17 21:34:00 发布

阅读量872

点赞数

分类专栏： BW

BW 专栏收录该内容

113 篇文章 5 订阅

订阅专栏

RSOSFIELDMAP：查找数据源与IO的对应关系

RSOLTPSOURCEFIE：查找R/3字段在BW哪些数据源使用了

DD02T 批量查找表的文本名

t-code RSRTQ ：query的各种信息 http://scn.sap.com/docs/DOC-26063

https://wiki.scn.sap.com/wiki/display/BI/Important+Tables+in+SAP+BW+7.x

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.

Table	Description
RSBKBP	Breakpoints
RSBKDATAINFO	Information on DTP Runtime Buffers
RSBKDATAPAKID	DTP: Status Table for Data Packages
RSBKDATAPAKSEL	DTP: Data Package Selections
RSBKDTP	BW: Data Transfer Process Header Data
RSBKDTPH	DTP: Historic Versions
RSBKDTPSTAT	Status Information on Data Transfer Process
RSBKDTPT	Texts on Data Transfer Processes
RSBKDTPTH	Texts on Data Transfer Processes
RSBKREQUEST	DTP Request
RSBKREQUEST_V	View of DTP Request
RSBKSELECT	Selections for DTP Request (Summary)
RSBKSUBSTEP	Properties of Substeps in a DTP
RSDDSTATDTP	Table for WHM Statistics. Details DTP
RSOACUBE_DTP	BW: OLTP Direct Access: Directory of Assigned Remote DTPs

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 ELTUID-长文本描述-选择元素的定义类型，可以查到QUERY，限制性关键值
RSZELTTXT	Texts of reporting component elements 报表中文名与报表ID
RSZELTXREF	Directory of query element references
RSRREPDIR	Directory of all reports (Query GENUNIID)
RSZCOMPDIR	Directory of reporting components
RSZRANGE	Selection specification for an element ELTUID -信息对象
RSZSELECT	Selection properties of an element ELTDID -信息对象
RSZELTDIR	Directory of the reporting component elements ELTUID - 文本
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) 立方体或者多重提供者有哪些IO
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: 多重提供者是由哪些CUBE的IO提供的
RSDICHAPRO	Characteristic Properties Specific to an InfoCube
RSDIKYFPRO	Flag Properties Specific to an InfoCube
RSDICVALIOBJ	InfoObjects of the Stock Validity Table for the InfoCube
MULTI
RSDCUBEMULTI	InfoCubes concerned with MultiCube （multi下面的cube)
RSDICMULTIIOBJ	MultiProvider: Selection/Identification of InfoObjects (multi的分配）

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 the Source & Target Structures
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 be added to using the ABAP Class/Method i_r_log->add_sy_message.
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