cancel
Showing results for 
Search instead for 
Did you mean: 

Query of Default Documents/Reports

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Sorry, don't have any idea about that.

Regards,

Thanga Raj.K

former_member187989
Active Contributor
0 Kudos

Check this link