topic Re: Converting SAP Query to Report Program in Application Development and Automation Discussions

Converting SAP Query to Report Program

former_member386063 — Fri, 01 Aug 2014 05:43:38 GMT

Hello Experts,

I'm stuck up with an issue.

I want to convert SAP query into a report program as the things which I need to implement is not possible with SAP Query anymore.

So I need to convert SAP query to Report program.

I'm very much aware about the SQ01--> Query --> More functions --> Display Report Program

But this Report Program generates is AQ..................... but if you see the code there will be buch of dynamic calls not as clear as ABAP code and not much flexibility to modify...

Please Provide a solution to this.

Regards,

Titiksha

Re: Converting SAP Query to Report Program

former_member201275 — Fri, 01 Aug 2014 06:53:28 GMT

If you want to generate program from query, then choose comand Query -> More Functions -> Display report name. Using this name you can see the generated program in SE38.

But honestly I would not recommend generating programs from SAP Queries, as you have to struggle with generated code and then maintain this program. Just imagine if user decided to add some more fields or logic to the resulting grid.

Re: Converting SAP Query to Report Program

VijayaKrishnaG — Fri, 01 Aug 2014 06:59:41 GMT

Hi Bhange,

has said very well and I support him. Even I suggest you to ignor the report generated with Query and develop a new report with the required business logic.

Regards,

Vijay

Re: Converting SAP Query to Report Program

former_member201285 — Fri, 01 Aug 2014 07:12:41 GMT

I absolutely agree with Glen. We had a project many years ago and a more or less clever consultant decided to copy a code from a query and modified it. The IT department (including me) got to know about it much later, and we were not amused to see that. Two years later we had to extend it with new fields and new logic - it was nearly impossible and took a lot of time finally. Everybody thought: If only we hadn't created this damned copy and had written an own report in the beginning...

Re: Converting SAP Query to Report Program

former_member386063 — Fri, 01 Aug 2014 07:44:39 GMT

Thank you Ulrich for your reply.

Regards,

Titiksha

Re: Converting SAP Query to Report Program

former_member386063 — Fri, 01 Aug 2014 07:45:20 GMT

Hello Vijaykrishna,

Thank you for your reply.

Regards.

Titiksha

Re: Converting SAP Query to Report Program

former_member386063 — Fri, 01 Aug 2014 07:46:00 GMT

Thank you Glen.

Regards,

Titiksha