topic Re: Generating a report using ABAP query in Application Development and Automation Discussions

Generating a report using ABAP query

Former Member — Thu, 10 Jul 2008 23:52:51 GMT

Hi All,

I want to generate a anlytical report using ABAP query, There are 3 different transactions/steps have to be executed to get this data in an actionable form.

1. MB52 - Unrestricted Stock

2. ZCustomquery - Custom query in SAP R3

3. Combine above two in a single report.

Please suggest me how can i proceed,

1. Example i have created query name called Finalrepot

2. How can i call above zcustomquery and Transaction (MB52) in the Query.

Thanks for your help

Pradeep

Re: Generating a report using ABAP query

madan_ullasa — Fri, 11 Jul 2008 01:26:02 GMT

I think you are refering to SQ01, SQ02 and SQ03 transactions. Find the tables for MB52 and the custom report. The create a join condition for these table in the query. Create a transaction code to run this query..I believe this will work..

Regards,

Madan.

Re: Generating a report using ABAP query

Former Member — Fri, 11 Jul 2008 02:08:58 GMT

Hi,

Check below link to create ABAP query (SAP Query)

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

Best regards,

Brijesh

Re: Generating a report using ABAP query

Former Member — Fri, 11 Jul 2008 04:16:14 GMT

Hi madan

thanks for the reply...when i see the tables in mb52 (TABLES: rkpf, resb, prps, makt, t156t) these are the table i found...

you mean to say....those are the tables.... In custom abap query...how can i see, the list of tables

Pl suggest me

thanks

Pradeep

Re: Generating a report using ABAP query

Former Member — Fri, 11 Jul 2008 04:23:21 GMT

From SQ01 find out the report name for the query (Query->More functions->Display report name). Then from se38 display the report and search it with select statement. Or u can do the Environment Analysis from SE38 initial screen by pressing Shift + F4 button.

Regards,

Joy.

Re: Generating a report using ABAP query

Former Member — Mon, 10 Oct 2011 10:45:43 GMT

To see the Report name in SQVI you will go to menu Quick View, Additional Functions and display report name

Much simpler way is to take the program and go to SE80. Then pull down programs and input your program. You will see all the tables under Dictionary Structures