Query of Default Documents/Reports

[Former Member]

Dear All,

I want to get the Query of Default Documents/Reports , like Purchase Analysis (Purchasing Reports), Open Item List (Sales Reports) etc.

Thanks,

Ghazanfar Ahmed

[Former Member]

Hai!

To view System Report Queries (Purcahse Analysis,TB ..)

You can able to see this through SQL Trace.

Open SQL Management Studio.

Open Tools>Sql Server Profiler.

Open File>New Trace.

This will continously trace the changes done in SQL.

Open the Purcahse analysis report now in SAP B1. U will get the query from Trace Window

Regards,

Thanga Raj.K

[Former Member]

Dear Thanga Raj,

Thanks, I have tried it but I need any tool provided by SAP B1 ID like Query manger.

Regards,

Ghazanfar Ahmed

[Former Member]

Sorry, don't have any idea about that.

Regards,

Thanga Raj.K

[former_member187989]

Check this link