Skip to Content

Applies to:

SAP NetWeaver Business Warehouse (formerly BI). This will also work on SAP BI 3.5 and BI 7.0.

Summary :

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

Author Bio:

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.

Procedure:

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

1.JPG

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)

2.JPG

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)

3.JPG

Here for example I will select one Characteristic and one Cube (Since we have 2 tasks in the right pane)

4.JPG

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

5.JPG

Give the Technical name and description

6.JPG

Click on Execute and you will get a message as below.


7.JPG

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.

8.JPG

Create a Start Process for the process chain.

9.JPG

Now on the left hand side click on process types and expand General Services. Double click on ABAP Program.

10.JPG

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

11.JPG

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

12.JPG

Give a Variant Name and click on Create

13.JPG

Next screen will ask for the package ID we created in T-code RSRV .

14.JPG

Click on possible selections inside Package ID to get the list of all the existing Packages

15.JPG

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.

16.JPG

Save the changes and go back.


Click Continue on the Insert ABAP Program Popup we had earlier.

17.JPG

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

Select the package ID we created “SID_CHECKS”.

The ABAP program process type now appears in the process chains. Link it to the Start process

18.JPG

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.        

19.JPG

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.

20.JPG

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.          

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Manohar Delampady

    Hi Swapnil,

         A great document indeed and thanks for detailing it.

    My only doubt would be to know of a scenario where you’d want to carry out such tests as scheduled tasks. Once the process chain completes and if some of the checks have failed, is there a way the user can know it..? Will the process chain terminate when the tests fail so that the user can then login to RSRV and correct the errors ? Please clarify and thank you in anticipation..

    Regards,

      Manohar. D

    (0) 

Leave a Reply