BW Object별 관련 테이블 목록

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




[#M_더보기|접기|

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 : 인포영역텍스트

_M#]





출처 : http://wiki.sdn.sap.com/wiki/display/BI/Important+Tables+in+SAP+BI+(+NW2004)