topic Re: find Query name for ABAP Generated Program in Application Development and Automation Discussions

find Query name for ABAP Generated Program

Yasin — Wed, 10 Jun 2020 14:28:29 GMT

Hi,

I have an ABAP Program looks like query generated pro, how can i find the original query name

ABAP Pro Name: GPAXU98VEJJ9IVVOPTNNTZUD7F9200

Regards

Re: find Query name for ABAP Generated Program

rupesh_brahmankar — Wed, 10 Jun 2020 14:37:52 GMT

Hello,

Go to SE37 use FM RSAQ_DECODE_REPORT_NAME then test FM INREPORT = GPAXU98VEJJ9IVVOPTNNTZUD7F9200 execute it.

Then you get the results User group and Query name

Best Regards,

R.Brahmankar

Re: find Query name for ABAP Generated Program

Sandra_Rossi — Wed, 10 Jun 2020 17:40:42 GMT

Query... SAP Query? Or you mean Report Painter? (or report writer) I don't remember that GPxxxxxxxxxxxxxxxxxx could correspond to any kind of object in SAP Query.

Re: find Query name for ABAP Generated Program

Yasin — Wed, 10 Jun 2020 18:24:59 GMT

Hi Sandra

am not sure about it. it is generated code but am not sure mabe it is not query based

coz when i run FM: RSAQ_DECODE_REPORT_NAME result is empty

I think it was created by SD or FI Cons.

Thanks,

Re: find Query name for ABAP Generated Program

Yasin — Wed, 10 Jun 2020 18:29:07 GMT

Hi Brahmankar

RSAQ_DECODE_REPORT_NAME result is empty

Regards

Re: find Query name for ABAP Generated Program

michael_piesche — Thu, 11 Jun 2020 03:39:46 GMT

Go to SE38 and view the coding of the report. The most important information about the generated program (GP) and where it comes from, will most likely be displayed in the first part of the report and in the comments. If it still doesnt make sense to you, please post a screenshot or the coding/comments of the first part of the generated report, so we can figure out where this report comes from. Also look and post information about the Goto->Attributes of the report.

1. Data Retention Tool (DART)

Is the Report based on report rtxwvgtemplate? In that case you need to access SAP menu /nFTW0, goto Information System and Data Extract Views and then you will find your Query program name.

report rtxwvgtemplate no standard page heading.
*----------------------------------------------------------------------*
* template program for data view query
*----------------------------------------------------------------------*

2. Report Painter / Report Writer

Does the coding of your GP* report start like this, using MESSAGE-ID GR?

REPORT GPAXU98VEJJ9IVVOPTNNTZUD7F9200 MESSAGE-ID GR
                NO STANDARD PAGE HEADING
                LINE-SIZE 132 LINE-COUNT 59.

In that case it is part of the Report Painter / Report Writer package and the executable for a Report Group. In the first comments you should find information about the library (GR23) and the report group (GR53).

3. Transformation

If it is a transformation, you can use use table RSTRAN, look for the report name in field TRANPRG and check the field TRANID containing the Transformations ID.

4. Include to an executable report

If it is just an Include program, you will have to use the "Where-Used List" Function to find the actual executable report(s) and find out more from there.

5. many more....

There are many more sources for a generated program. So we will need more information if you have not been able to figure it out by now.

Re: find Query name for ABAP Generated Program

rupesh_brahmankar — Thu, 11 Jun 2020 04:36:47 GMT

Hello,

Please make sure you have enter the correct query report name

As its working fine for me.

Best Regards,

R.Brahmankar

Re: find Query name for ABAP Generated Program

Yasin — Fri, 12 Jun 2020 07:07:08 GMT

Dear Micheal,

Thanks for the great information, as per your explanation it is a Report Painter / Report Writer.

almost we reached. now how can i edit the source report / find the original report so i can modify on it.

and regenerate the program.

Regards

Re: find Query name for ABAP Generated Program

michael_piesche — Fri, 12 Jun 2020 08:28:52 GMT

yaso80, congratulations, you do know the report group now, correct?The generated report is based on the report group that is mentioned in the top comments of the report. You maintain the report group with "GR52 Change Report Group", or simply view it with "GR53 Display report group". You can also generate it from GR52. Or you can use "GR5G Generate report groups" if you want to re-generate more than one report group at once.

If you want to find out more about Report Painter / Report Writer, please have a look at the SAP Help Documentation, or google or search in the community.

- SAP Help Documentation: Report Painter / Report Writer

I would recommend closing this question as it has been answered. If you have further questions regarding Report Painter / Report Writer, please have a look at available ressources, and if there are still open questions, feel free to open another question in the community.