How to include RSRT into process chain

[Former Member]

Hi Gurus ,

I need to include the RSRT into my process chain,

Can anyone guide me

Thanks in advanvce

[Former Member · Accepted solution]

Saravanan,

If you r requirement is to call the transaction RSRT in the process chain, you can do that. But the when that process comes the t-code RSRT will be called.

You can include this via an ABAP program. In the ABAP program you can use "call transaction" to call RSRT and include the program in the process chain which will get executed and the transaction RSRT will be called.....hope you got my point. I hope I understood your requirement correctly, else please give more details about the same....

[Former Member]

Hi,

why would you do that?? Is it that you want to execute some query and then evaluate a result in order to take a decision? RSRT is a transaction to be used mainly in dialog; process chains are fired in background processing...

You have definitively other means for that; read an infoprovider, run a query with rscrm_report....

let us know your process case

Olivier.

[Former Member]

Hi , thanks for the reply,

Here is my issue,

I have a few query which is really complicated selection and took about 4-5 minutes to generate the report. Manually i can cut down this time by running the generate report option in the RSRT. Now i need to automate this.This query has the variable entry for the fiscal year and currency type.

Please guide me to resolve this issue

Thank you in advance

[Former Member]

Hi,

first of all the report should be regerated only if you have changes in its definition.

More over, generating a query will empty its cache; OK, if you are loading one of its IProvider during this chain then the cache will be invalidated anyway.

I don't get the point of the variables at this stage; the generation of the report is like a "compilation of its code"; not an execution of it.

If you need to execute it once after the loading by the chain (or any other process within your chain) then you can use the reporting agent in order to precalculate it (search this forum for precalculation or help.sap.com).

If you really want to regenerate your query, you'll have to write an ABAP report and add it to your chain;

here you go:

TYPE-POOLS: RRO01.

data: l_s_rkb1d   type rsr_s_rkb1d,
        l_sx_report type rro01_sx_report,
         i_s_repkey LIKE RSZCOMPKEY.

*BREAK-POINT.

SELECT SINGLE GENUNIID INTO i_s_repkey-GENUNIID
FROM RSRREPDIR
WHERE COMPID = 'ZRT_ZICRT_C07_003' "the techname of your query
  AND OBJVERS = 'A'.

check sy-subrc = 0.

call function 'RRI_REPDIR_READ'
     importing
        e_s_rkb1d  = l_s_rkb1d
    changing
        c_s_repkey = i_s_repkey
    exceptions
        others     = 1.

check sy-subrc = 0.

call function 'RRI_REPORT_GENERATE'
    exporting
        i_pretty_print = ' '
    changing
        c_sx_report    = l_sx_report
        c_s_rkb1d      = l_s_rkb1d
    exceptions
        others         = 0.

hope this helps...

Olivier.