Converting SAP Query to Report Program

[former_member386063]

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

[former_member201275]

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.

[former_member386063]

Thank you Glen.

Regards,

Titiksha

[VijayaKrishnaG]

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

[former_member386063]

Hello Vijaykrishna,

Thank you for your reply.

Regards.

Titiksha

[former_member201285]

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...

[former_member386063]

Thank you Ulrich for your reply.

Regards,

Titiksha