Automate download of STAD data.

[Former Member]

Hi,

We want to capture the daily user activity in our Prod ECC5. I understand that STAD only stores a few days of data.

What I do daily is to run STAD and manually download the data into my PC. This process takes a long time and it sometimes slows the system down.

Is there a way to automate this process? If this could be automated, I can run this overnight and dump the data into a temporary directory in the server.

Thanks for your help.

KRBas

[Former Member · Accepted solution]

Hi KRBas,

Instead of running STAD do one one. Schedule the report RSSTAT26 to run daily in background. It will create a spool request which you can download daily.

Regards.

Ruchit.

[Former Member · Accepted solution]

Hi Ruchit,

Creating a batch job requires a variant. Any suggestions on how to update the "Start Date" of the variant since start date will have to be changed daily.

Thanks,

KRBas

[Former Member · Accepted solution]

You can do this with a selection variable of type "D" (Dynamic date calculation).

• Open up your RSSTAT26 variant for editing

• Go to Variant Attributes

• For the row field where you want to use a selection variable (e.g. RDAY), go under column heading Selection variable and use the drop-down to select D (D:Dynamic date calculation)

• Under Name of Variable column, use the drop-down to select "Current date"

Hope this helps.

[Former Member · Accepted solution]

Can you explain better how to do this?

• Open up your RSSTAT26 variant for editing

• Go to Variant Attributes

• For the row field where you want to use a selection variable (e.g. RDAY), go under column heading Selection variable and use the drop-down to select D (D:Dynamic date calculation)

• Under Name of Variable column, use the drop-down to select "Current date"

I can't find how to set the dynamic date calculation

[Former Member]

HI,,

You can use tcode ST03 AS WELL..

THanks,

[Former Member]

Thanks all for your reply.

kbas

[AndreasVogel]

Hi,

instead of archiving the output of STAD you could use Tx ST03N. The aggregations available in ST03N are calculated from the statistical records you can see in STAD. There are aggreagtions for executed transactions, user statistics, and much more.

If you really need the statistical records you may consider an implementation of the user exit (see SAP note 143550) or you may use a SAP function module to access the stat file. If you like I could look up the name of such a function.

Regards,

Andreas

[Former Member]

Hi,

Use the concept of SAP archiving for MONI tables to archive this data and run RSSTAT60 and your own intervals to delete that data

Just an idea

Regards,

Phani