Create Txn for a Query

[Former Member]

Dear All,

Could someone tell me the steps to create a transaction for a query?

Thanks,

DM

[Former Member]

No need to use small report

No need to use generated program name (it really can change)

Just create a parameter transaction with reference to START_REPORT transaction. When creating a parameter transaction you have to set the following parameters:

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = precisely the first 12 characters - query user group (including trailing spaces), 13-th character is G for global queries

D_SREPOVARI-EXTDREPORT = Query name as shown in SQ01.

That's it.

Well, and do not forget to check the flag "Skip first screen".

To all others interested: just try to add some SAP query into a role via PFCG, then run it, and then via System -> Status look into the definition of the transaction generated, and you'll see the answer.

[Former Member]

No need to use small report

No need to use generated program name (it really can change)

Just create a parameter transaction with reference to START_REPORT transaction. When creating a parameter transaction you have to set the following parameters:

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = precisely the first 12 characters - query user group (including trailing spaces), 13-th character is G for global queries

D_SREPOVARI-EXTDREPORT = Query name as shown in SQ01.

That's it.

Well, and do not forget to check the flag "Skip first screen".

To all others interested: just try to add some SAP query into a role via PFCG, then run it, and then via System -> Status look into the definition of the transaction generated, and you'll see the answer.

[Former Member]

Hi,

Thank you very much for the answers, much appreciated. One more question....how can the generated program name change? When I was going through that option.....it make me wonder.

Cheers,

DM

[Former Member]

Don't bother answering that question. I got it.....it's coz the query can change and we might have to regenerate the program. Am I right?

[Former Member]

HI

GOOD

GO THROUGH THESE LINKS

http://www.sappoint.com/abap/ab4query.pdf

http://www.howforge.com/how-to-create-user-groups-for-abap-4-query

THANKS

MRUTYUN