Skip to Content

We have a requirement wherein user want to know when was the report refreshed from source system i.e. on which date and time it was loaded into data target.We can get this information from two standard tables RSREQDONE and RSBKREQUEST.

RSREQDONE gives the information about timestamp of Infopackage.

RSBKREQUEST gives the information about timestamp of Data Transfer Process(DTP).

To get this information updated in Infocube, we have written code at the end routine level before updating Infocube by doing a lookup on these tables

RSREQDONE and RSBKREQUEST.

Below is the code starting with declaration part ,

1.JPG2.JPG

In below code, we have maintained entry for Infopackage in TVARVC.This can be achieved by using STVARV tcode.

3.JPG

Tcode: STVARV

4.JPG

Below is the screen where we are fetching Infopackage technical name mentioned in table TVARVC.

5.JPG

Here variable ZLOGPID will have values of Infopackage name which is read from table TVARVC.

By passing ZLOGPID value too table RSREQDONE ,we are getting the extraction timestamp from the value of TIMESTAMPBEGIN.

To convert this TIMESTAMPBEGIN value into date and time,we have used standard function module’RSSM_GET_TIME’.

6.JPG

By passing Infocube name in where condition, we are doing lookup into the RSBKREQUEST table and getting the timestamp value of TSTMP_START of the Data Transfer Process.

Again to convert this TSTMP_START value into date and time,we have used standard function module ‘RSSM_GET_TIME’.

7.JPG

Finally we are updating these timestamp fields into target infoobjects.

8.JPG

9.JPG

After completion of data load, we can see this information populated in the report output.

10.JPG

You can also check the Infopackge extraction information from the PSA manage screen, as shown.

11.JPG

Infocube loaded date and time from DTP monitor screen.

12.JPG

To report this post you need to login first.

2 Comments

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

  1. Chintan Gandhi

    Hey but here you will get multiple time stamps right? As same DTP and infopackage will be used for daily loading. So everytime we will have to sort it and then take up the first entry? correct?

    (0) 

Leave a Reply