Friday, May 20, 2011

Process Chains

Hi all,

Are you getting lost in RSPC when searching between 100+ process chains for the one you need? Try transaction RSPC1, it will directly bring you there!


Another issue in a system with many process chains is how to find out in which meta chain a local chain is used. Therefore use table RSPCCHAIN and fill the name of the local chain in field VARIANTE. All meta chains will show in the result!


Good luck!

Thursday, May 19, 2011

Important Tables SAP BW / BI


Below is a list of useful tables in SAP BW / BI feel free to add more!
Transformations

RSTRAN
Transformati e information (routine ID start/end/expert)
RSTRANFIELD
Mapping rules Transformation
RSTRANROUTMAP
Mapping of routines in Transformation (RSAABAP)
RSBKDTP
DTP information table
RSBKREQUEST
DTP request information
RSREQICODS
Request information in DSO’s or Infocubes
RSREQDONE
Table with load request information


Transfer Structure
RSTS Transfer Structure List
RSTSFIELD Transfer Structure fields
RSTSRULES Transfer Structure rules
RSAROUTTText name of Transfer Routine
DD03TText for R/3 Transfer structure Objects
Update Rules
RSUPDROUTUpdate rules List
RSUPDDAT Update rules with routines
RSUPDKEY Update rule key fields
RSUPDINFOInfoProvider 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
RSMONICDPContains 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
RSPCLOGSApplication Logs for the Process Chains
RSPCPROCESSLOGLogs 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
RSZELTTXTTexts of reporting component elements
RSZELTXREFDirectory of query element references
RSRREPDIR Directory of all reports (Query GENUNIID)
RSZCOMPDIRDirectory of reporting components
RSZRANGESelection specification for an element
RSZSELECT Selection properties of an element
RSZELTDIR Directory of the reporting component elements
RSZCOMPIC Assignment reuseable component <-> InfoCube
RSZELTPRIOPriorities with element collisions
RSZELTPROPElement properties (settings)
RSZELTATTR Attribute selection per dimension element
RSZCALCDefinition of a formula element
RSZCEL Query Designer: Directory of Cells
RSZGLOBV Global Variables in Reporting
RSZCHANGESChange history of reporting components
Workbooks
RSRWBINDEXList 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
RSRWORKBOOKWhere-used list for reports in workbooks
Web templates
RSZWOBJ Storage of the Web Objects
RSZWOBJTXT Texts for Templates/Items/Views
RSZWOBJXREFStructure 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
RSDATRNAVNavigation Attributes
RSDATRNAVT Navigation Attributes
RSDBCHATRMaster Data Attributes
RSDCHABASBasic 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
RSDCUBETTexts on InfoCubes
RSDCUBEIOBJ Objects per InfoCube (where-used list)
RSDDIME Directory of Dimensions
RSDDIMETTexts on Dimensions
RSDDIMEIOBJ InfoObjects for each Dimension (Where-Used List)
RSDCUBEMULTIInfoCubes involved in a MultiCube
RSDICMULTIIOBJ MultiProvider: Selection/Identification of InfoObjects
RSDICHAPRO Characteristic Properties Specific to an InfoCube
RSDIKYFPROFlag Properties Specific to an InfoCube
RSDICVALIOBJInfoObjects of the Stock Validity Table for the InfoCube
Aggregates
RSDDAGGRDIR Directory of Aggregates
RSDDAGGRCOMP Description of Aggregates
RSDDAGGRTText on Aggregates
RSDDAGGLTDirectory of the aggregates, texts
ODS Object
RSDODSO Directory of all ODS Objects
RSDODSOT Texts of all ODS Objects
RSDODSOIOBJ InfoObjects of ODS Objects
RSDODSOATRNAVNavigation 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)
RODELTAMBW Delta Procedure (SAP Source System)
RSOLTPSOURCEReplication Table for DataSources in BW
InfoSource
RSIS Directory of InfoSources with Flexible Update
RSISTTexts on InfoSources with Flexible Update
RSISFIELD InfoObjects of an InfoSource
Communications Structure
RSKSCommunications Structure for InfoSources with Flexible Update
RSKSCommunications Structure (View) for Attributes for an InfoSource with Direct Update
RSKSFIELDTexts on InfoSources with Flexible Update
RSISFIELDInfoObjects 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
RSISOSMAPMapping Between InfoSources and DataSources (=OLTP Sources)
RSOSFIELDMAPMapping Between DataSource Fields and InfoObjects
InfoSpoke
RSBSPOKESELSETInfoSpoke Directory and Selection Options
RSBSPOKEVSELSETInfoSpoke Directory with Selection Options and Versioning
RSBSPOKEList of all InfoSpokes with attributes maintained with transaction RSBO which include the name of
the Source & Target Structures
RSBSPOKETList of all InfoSpokes with the Short & Long Descriptions (only one of these can be maintained).
RSBSTEPIDMESSContains 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
RSDDSTATBasic Table for InfoCubes/Queries
RSDDSTATAGGR Detail Table for Aggregate Setup
RSDDSTATAGGRDEFDetail Table of Navigation for each InfoCube/Query
RSDDSTATCONDInfoCube Compression
RSDDSTATDELEInfoCube Deletions
RSDDSTATWHMWarehouse Management
Misc
RSFECBW 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)
RSPSADELPSA Table deletion
TBTCPJob Schedule Definition
TBTCOJob Schedule Result
RSMONMESS Monitor Messages
RSERRORLOGCheck loading errors in table
V_RSZGLOBVReport Variables view table
DEVACCESSDeveloper Keys table
TSTCAll Transactions in the system
RSDDAGGRDIRDirectory of the aggregates
ROIDOCPRMSControl parameters for data transfer from the source system
SMEN_BUFFCObjects in User's Favorites
TSTCTTransaction Codes with Text
DD03Lfield names and corresponding data element names
DD03LTDescription of each data element
DD02LAll SAP Defined Table Names
DD02LTDescription of All SAP Defined Table Names
Web Item
RSZWITEMHeader Table for BW Web Items
RSZWMDITEMBW Web Metadata: Template Item ( Dataprovider, Item, ... ).
RSZWITEMXREFCross Reference of Web Items
RSZWMIMEIOBUFFERBuffer for Translation MIME Rep. to IO
RSZWOBJStorage of the Web Objects
RSZWOBJTXTTexts 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
RSARCHIPROIOBJBW Archiving: General Archiving Properties
RSARCHIPROLOCBW ARchiving: General Local Properties
RSARCHIPROLOCSELBW Archiving: Archived Data Area
RSARCHIPROPIDBW Archiving: Program References of InfoProvider
RSARCHREQBW Archiving: Archiving Request
RSARCHREQFILESBW Archiving: Verfified Archive Files
RSARCHREQSELBW Archiving: Request-Selections
Open Hub Destination
RSBOHSERVICETP Open Hub: Service Types
RSBREQUESTDELTA Open Hub: Cross Reference Outbound/Inbound
RSBREQUESTMESSOpen Hub: Log for a Request
RSBREQUIDOpen Hub: Requests
RSBREQUID3RDOpen Hub: Status of 3rd Party Requests
RSBREQUIDRUNOpen Hub: Table with Status for a Request
RSBSTRUCTUREOpen Hub: Generated Structures and Tables