Tables and T-Codes

Link to Article

Extraction Logistics Datasources - T-Codes and Programs

An overview of Datasources and the programs filling the relevant setup table (named MC*SETUP). With this handy table you can find the status of your current job or previous initialization jobs through SM37.

Datasource	Tcode	Program
2LIS_02*	OLI3BW	RMCENEUA
2LIS_03_BX	MCNB	RMCBINIT_BW
2LIS_03_BF	OLI1BW	RMCBNEUA
2LIS_03_UM	OLIZBW	RMCBNERP
2LIS_04* orders	OLI4BW	RMCFNEUA
2LIS_04* manufacturing	OLIFBW	RMCFNEUD
2LIS_05*	OLIQBW	RMCQNEBW
2LIS_08*	VTBW	VTRBWVTBWNEW
2LIS_08* (COSTS)	VIFBW	VTRBWVIFBW
2LIS_11_V_ITM	OLI7BW	RMCVNEUA
2LIS_11_VAITM	OLI7BW	RMCVNEUA
2LIS_11_VAHDR	OLI7BW	RMCVNEUA
2LIS_12_VCHDR	OLI8BW	RMCVNEUL
2LIS_12_VCITM	OLI8BW	RMCVNEUL
2LIS_12_VCSCL	OLI8BW	RMCVNEUL
2LIS_13_VDHDR	OLI9BW	RMCVNEUF
2LIS_13_VDITM	OLI9BW	RMCVNEUF
2LIS_17*	OLIIBW	RMCINEBW
2LIS_18*	OLISBW	RMCSNEBW
2LIS_45*	OLIABW	RMCENEUB

Important Tcodes in BPS, IP, BW, ECC and BPC

Important Transaction Codes 

BPS-SEM

BPS0 - Planning Work bench

UPSPM - Customize folders

UPSPL - Execute folders

BPSSTAT - Statistics

Most of the transactions in BPS starts with UPS*


BI-IP - Integrated Planning

RSPLAN - Planning Modler

RSPLF1 - ABAP class - Planning function

RSPLSE - Lock - can be used in BPS also


Important Transactions in BW

RSA1 AdminWB

RSD1 - Info object

RSA5 - Data source

RSA6 - Generate Data spurce

RSA3- Simulate DS

RSA7 - Delta queue

RSRV - repair and check

RSO2 - create/Change custom DS

LISTCUBE- List viewer for InfoCubes

RSSE- Selection start InfoCube

LISTSCHEMA- List Schemas

RSINPUT Manual Input of Data into Cube

RSOR BW Metadata Repository

RSMO Data-Load-Monitor Start

RSRQ Data Load Monitor for a Request

RSPC Process Chain Maintenance

RSA2 Datasource Repository

RSO2 Datasource Repository (Customer)

RSA6 Maintain DataSources

RSRT Query Monitor

RSBBS Query Jump Targets

RSZC Copy Queries between cubes

RSZDELETE Delete queries and workbooks

RSBBS Query Jump Targets

MODELING

RSORBCT - Business Content

RSORMDR - Meta Data Repository

Object Maintenance

RSDMPROM - MultiProvider

RSISET - InfoSet

RSDCUBE - InfoCube

RSDODSD - ODS Object

RSD1 - Info Object

Master Data Maintenance

RSDMD - Master Data

RSH1 - Hierarchies

BUSINESS EXPLORER

RRMX – Analyzer

Authorizations:

 

PFCG - Maintain Roles

RSSM - Reporting Authorizations Objects

Query:

 

RSZC - Copy

RSZDELETE - Delete Object

RSBBS - RRI targets

BEx Monitor:

 

RSRT1 - Query Monitor

RSRTRACE - Trace Tool

RSRCACHE - OLAP : Cache Monitor

SMICM - ICM Monitor

S02_MIME_REPOSITORY - Mime Repository


Important ECC Transaction Codes:

RSA5

RSA6

RSA3

RSA2

RSO2

RSA7


Important BPC Tcodes:

All the transactions related to BPC starts with UJ*

For example:

UJ_VALIDATION

UJ_SCRIPT


Easyway to find the transaction codes in any area ECC or BW or BPS or BPC do the following:

1.Got to SE16 or SE11

 
2.Enter the table name TSTC

or go to SE93


For BW tcodes

search by RS*


For BPC search by UJ*.


Some other important tcodes :

RSMO Data Load Monitor Start

RSMON BW Administrator Workbench

RSOR BW Metadata Repository

RSORBCT BI Business Content Transfer

RSORMDR BW Metadata Repository

RSPC Process Chain Maintenance

RSPC1 Process Chain Display

RSPCM Monitor daily process chains

Miscellaneous:

SE11 ABAP Dictionary

SM64 Trigger Events and background process

Se16

SE38

SA37


Database :

DB02 Tables and Indexes Monitor

DB14 Display DBA Operation Logs

DB16 Display DB Check Results

DB20 Update DB Statistics


Analysis of Job:

SM37 Overview of job selection

SM50 Work Process Overview

SM51 List of SAP Systems

SM59 RFC Destinations (Display/Maintain)