Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I determine what report was used to start the SQL statement?

determine report sql Used
0
Posted

How can I determine what report was used to start the SQL statement?

0

In SAP versions up to 6.40, the prerequisite is that you can determine the report that implemented an processing-intensive SQL statement using the SAP profile parameter dbs/ada/register_appl_info. Set this parameter in the instance profile. For more information, see Note 216208. If the setting was made in line with Note 216208, the list layout can be changed in the Command Monitor so that the calling ABAP program is also displayed. You can then go directly from the Command Monitor to the call point in ABAP. If it is still not clear there in which context the source code will run, a where-used list can return further information. Information on the triggering transaction can also be determined by capturing a current query in SM66 or by a permanent SQL trace restricted to the table using ST05. If no report name is displayed in the Command Monitor, the statement is called by a tool or script outside the R/3 System. If branching using a source code button fails, you may have dynamically ge

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123