Hi, I am a newbie so forgive my ignorance.

Is it possible to view the sql query created by a baan report i.e sales history. If so...how?

Go to Application Development=>Reports=>Maintenance=>Maintain Reports {ttadv3130m000}. Search for the report you want to check out. If the vrc of your username is not the same as that of the reports then click on Copy button on the toolbar and make a copy of the report in your current vrc and save it. At the bottom of this session you would find Edit Scripts button, click on it and it will show you the script behind the report..

I hope this is what you were looking for...

sk

Welcome to Board. :)

Are you talking about standard sales history session? If yes, you can use set TT_SQL_TRACE=0000200 in BW command.

regards,

-Suhas