BW Object별 관련 테이블 목록

써먹을 테이블이 많아요..^^

 

쿼리 모든 리스트가 나오는 프로그램

RSRQ_QUERYDEFINITION

 

Function

RSZ_DB_ELT_GET -  Query UID로 Query Element (e_th_elttxt는 로그인 언어 Text만 조회)

RSSM_GET_TIME - 현재 날짜,시간,Timestamp

RSZ_X_COMPONENT_GET - Query ID로 변수 조회

 

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 

 

DTP

RSBKDTP - BW: 데이터 전송 프로세스 헤더 데이터

CL_RSBK_DTP(Class) : DTP 정보조회(Factory Method로 시작)

 

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(Select-Option 변수 Data Element)

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

 

Function : RSZ_0_DB_COMP_GET(쿼리에서 사용되는 변수 조회)

 

View : V_COMPDIR_COMPIC(레포트, 인포큐브 및 텍스트)

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 (Compound 확인가능)

RSKYF   Key Figures

RSDTIM Time Characteristics

RSDUNI Units

RSDIPROIOBJT : 정보 제공자의 인포오브젝트 텍스트

RSD_COB_PRO_GET_ALWAYS : 조회 특성의 참조특성에 대한 세부/찾아가기 속성

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

RSDST : 데이터소스 - 텍스트

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

 

InfoSet

rsqisett : 인포세트텍스트

 

Node

 RSDIPROHNODET : 정보 제공자: 계층구조 노드, 내역

 

InfoArea

RSDAREAT : 인포영역텍스트