Generating a report using ABAP query

[Former Member]

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

[Former Member]

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

[madan_ullasa]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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