SAP NetWeaver Business Warehouse (formerly BI). This will also work on SAP BI 3.5 and BI 7.0.
This document will help us with the steps for adding RSRV tasks in Process Chain
Author: Swapnil G. Thakare
Company: Accenture Services Pvt. Ltd.
Created on: 29 March, 2013
Swapnil G. Thakare is a SAP BI Consultant currently working with Accenture Services Private Limited. He has over five and half years of experience in various BW/BI implementation and support projects.
RSRV is a tool where we can carry out various maintenance activities related to Master Data, Transactional Data, Cubes, DSO’s, PSA Tables, etc.
Most of the times these activities are part of our monthly/weekly schedules and needs to be performed periodically. But selecting the tools / tasks each time and then executing them and waiting for the result to come can be tedious and time consuming.
To overcome this, we will see that this document will help us to schedule the RSRV tasks through a process chain which can be executed any moment of time or can be scheduled for a later date and can execute any RSRV checks / tasks without any manual intervention.
Just to Begin, I will show you any random check for e.g.: Let’s take “SID Values in X and Y Tables”
Open T-code RSRV, Go to Test in Transaction RSRV à All Elementary test à Master Data à SID Values in X and Y Tables
Now drag the selected task to right hand side. You can drag them as many times as you wish (depending on number of objects we need to check)
Next, expand the items we have in right, here we will get a popup where we have three options.
1. Char. (Here we can directly give the name of characteristic for example 0Material)
2. Info Provider Characteristics. (Here we can give a Cube/Multi provider name under which all the characteristics will be checked)
3. All (Basic-) Chars. (All the basic characteristics in the environment / BW System will be considered for checking)
Here for example I will select one Characteristic and one Cube (Since we have 2 tasks in the right pane)
Since we selected the 2nd option as a Cube, all the characteristics from the Cube are listed below.
Now we are done with the selections for the checks.
Just assuming that these selections are the ones you need to perform checks every month so that we can save it as a package to refer it through the process chain.
Go to Edit –> Test Package –> Save
Give the Technical name and description
Click on Execute and you will get a message as below.
Now our package is ready to be used in process chain. Now let’s create a process chain and use this package.
Open T-code RSPC and create a process chain. Give technical name and Description for the process chain.
Create a Start Process for the process chain.
Now on the left hand side click on process types and expand General Services. Double click on ABAP Program.
Once you double click on program, you get a popup asking for the program. Click on the create button in order to create a new program
Click on Continue.
In the Next screen, we need to mention the program name and the package we created for the selections of our task. SAP has developed a Standard Program named “RSRV_JOB_RUNNER” which specifically is used to run the RSRV tasks and accepts the packages as parameters.
So we mention the program name as “RSRV_JOB_RUNNER” and for Program Variant, click on Edit
Give a Variant Name and click on Create
Next screen will ask for the package ID we created in T-code RSRV .
Click on possible selections inside Package ID to get the list of all the existing Packages
Select the package ID we created “SID_CHECKS”.
Level of Detail can be of your choice (Default is Level 2 but I will select as Level 3).
Cancellation of Process Chain from Selected Message Type should be selected as “E Error” so that the process chain terminates when an error occurs.
Now Click on Back. A popup appears to ask whether we need to save the changes. Select Yes.
Enter the description in the next screen.
Save the changes and go back.
Click Continue on the Insert ABAP Program Popup we had earlier.
The ABAP program process type now appears in the process chains. Link it to the Start process
Go to Check view and see if everything is ok and then activate and start the process chain immediately or you can schedule for a later date.
Once it’s started, you can see that the ABAP process running.
While the process chain is running, you can also see the job running in SM37 where you can see the detailed log of the steps being carried out.
Next time we can just schedule the process chain and perform the activity without any manual intervention. Accordingly you can include any RSRV task for similar automation.