SAP upgrade - questions for report painter and query

[Former Member]

Hi Experts,

I have two quwstions of SAP upgrade.

My requirement is: SAP upgrade from 4.6B to ECC 6.0 with non-unicode.

1.Does SAP upgrade influence the report painter? If influence, could you tell me what should I do for this case.

2. We have so many queries (SQ01) in our system and many of them haven't been run for a long time. we need a tool to get the runtimes of queries in a certain durition.

For example: From 2008/01/01 to 2008/03/31,I want to know how many queries had been run/ query name/ runtimes of each query.

Best regards,

[Former Member]

Hello Frank,

The issue with Queries and the transaction monitor is, that queries are not captured if they are run directly with transaction SQ01.

Depending on the release you are currently on you should implement OSS Note 151748 and also include transaciton SQ01 which was "forgotten" by SAP.

Going forward all queries whether they are executed directly via SQ01 or any other transaction will be captured.

There is a tool available from IBIS called RBE Plus. The original RBE tool was co-develeoped by SAP AG and IBIS Prof. Thome AG and since 2004 IBIS is provided RBE Plus to serve the market. The tool is much more advance the the original tool but it is not for free anymore.

Hope that helps,

Heiko

[markus_doehr2]

> 1.Does SAP upgrade influence the report painter? If influence, could you tell me what should I do for this case.

You can check

Note 1155524 - ReportWriter: Upgrade Issues ECC6.0 -Common Customer Issues

> 2. We have so many queries (SQ01) in our system and many of them haven't been run for a long time. we need a tool to get the runtimes of queries in a certain durition.

Such a tool was RBE (Reverse Business Engineer) - which is out of support.

You can try to get that information from ST03. If that is not enough there's no other way than booking an SLO service to find out the queries that have not been used (http://service.sap.com/slo).

Markus

[Former Member]

Hi Markus,

Take a look at RBE Plus from IBIS. There was a press release by SAP and IBIS in 2004 announcing continued support by IBIS and RBE Plus to reverse enginieer SAP systems.

Regards,

Heiko

[markus_doehr2]

> Take a look at RBE Plus from IBIS. There was a press release by SAP and IBIS in 2004 announcing continued support by IBIS and RBE Plus to reverse enginieer SAP systems.

Yes - correct - but that's something you need to buy separately.

Markus