Useful SAP standard ABAP programs for BW

SAP provides some useful standard ABAP programs for BW (business warehouse) for different purposes, which are described in the documentation. They can be executed with transaction SE38: ABAP editor and the button ” Execute” (F8). For some of them there are specific selections. Here is a list with some tested and used programs.  This posting will be updated when there is new information. They are separated by their purpose:

Consistency check and repair

When working with BW objects you may meet different problems connected with inconsistency.

There are standard ABAP programs for BW, which can help you executing tasks and solve such problems.

1. Consistency check and repair: RSTRAN_ROUT_RSFO_CHECK – One very useful program. It which checks formulas and routines with regard to completeness or consistency of metadata.

This program can fix errors in transformations. Sometimes errors appear by releasing a transport or by importing the transport in the target system. This standard ABAP program corrects wrong entries in transformation tables, which were not deleted properly or appeared by other circumstances. The program should be executed in both source and target system.

Always use the tool ‘RSTRAN_ROUT_RSFO_CHECK’ in simulation mode first and then execute the tool in repair mode. You can use the generic placeholder ‘*’ for TRANID.Repair mode is activated by deactivating the SIMULATE indicator. If the indicator REPAIR_W is activated, transformations that are selected as yellow in the overview are also repaired.

Example for error is:

Object directory entry R3TR ROUT 00O2TLMC5XO9917R494IFCJEY does not exist

Diagnosis

The object directory entry (TADIR) for object R3TR ROUT 00O2TLMC5XO9917R494IFCJEY cannot be displayed since it does not exist at this time.

We can try to solve this error with the program for repairing. The program has to be executed for M and A state in the source and target system.

2. Program for analyses of Query tables in BW: ANALYZE_RSZ_TABLES

With this program you can check for inconsistency of queries and query elements. The program analyses the RSZ tables, where the information for query elements is stored. By execution the program will first show all identified problems. There is an option to correct the inconsistencies as next step.

3. Show metadata

RSTRAN_DDIS: Program RSTRAN_DDIS is used to dispay transformation metadata in the related tables.

Programs for activation

SAP gives option for activation of BW objects with programs. You can activate transformations, Data transfer process, info-cubes etc.

1. RSDG_TRFN_ACTIVATE: Program RSDG_TRFN_ACTIVATE is used for checks and to regenerate transformation objects in the case of technical incompleteness or inconsistency of metadata without creating a transport. With note 1927521 a new ‘Check’ functionality is implemented.
2. RSDG_CUBE_ACTIVATE is for activation of cubes

More programs for activation you can find in this article.

 

Index creation: ABAP program for BW on HANA

RSDDB_LOGINDEX_CREATE – create index for infocubes in BW on HANA

RSDDB_INDEX_CREATE_MASS – create index for selection of infocubes at once

They can be used when there is a problem with the infoprovider’s indexes in BW on HANA.

 

Tool for SQL script exits

RSPLS_SQL_SCRIPT_TOOL – for BW on HANA – BW planning: Tool for SQL script exits. There you can create SQL script for characteristic relationships, function types, data slices.

 

One longer list with ABAP programs for BW and function modules you can find here.