topic Modifying SQL in an infoset query in Application Development and Automation Discussions

Modifying SQL in an infoset query

Former Member — Mon, 20 Aug 2007 19:14:48 GMT

Dear SDN experts,

Can you please tell me if there is a way to modify the sql statement for an InfoSet query that was generated from a quickviewer?

Preferably this should be done without copying the generated code and then directly editing the ABAP, because I am just a poor application consultant without those kinds of programming priviliges.

Thank you very much in advance.

/Ulrik

Re: Modifying SQL in an infoset query

Former Member — Mon, 20 Aug 2007 20:02:28 GMT

Ulrik,

I dont think you can change the SQL statement that way. Instead of that why dont you change the the Infoset as usual? Let me know what exactly is your requirement, I will try to provide you some clues.

Thanks

Re: Modifying SQL in an infoset query

Former Member — Mon, 20 Aug 2007 20:22:36 GMT

Code from an Infoset query can be changed on ABAP editor...But trust me...It's too pain to do it that way...You better modify the code on the infoset query tool...

Greetings,

Blag.

Re: Modifying SQL in an infoset query

Former Member — Tue, 21 Aug 2007 06:28:06 GMT

Thank you Sameer (and also thank you to Alvaro).

As an example of a specific requirement I need to show only the most recent purchase order created for specific vendor(s), and I figure I could accomplish this by tweaking the SQL statement. Or maybe I could load the resultset into an internal table an manipulate this.

I have a feeling I need to go to coding section under extras on the InfoSet. But I think I just need a couple of nudges to get to that moment of revelation

Re: Modifying SQL in an infoset query

Former Member — Fri, 24 Aug 2007 07:11:55 GMT

Ulrik,

I think there is something like Ranked list in Infoset Query... which i assume would help you to get what you are looking at... something like the latest POs...

<i><b>Reward points if this info is helpful.</b></i>

Balaji

Re: Modifying SQL in an infoset query

Former Member — Sun, 26 Aug 2007 13:13:01 GMT

Thank you Balaji. If by "ranked list" you mean sorting the result list based on the PO document date then I am aware of this functionality - if you are referring to something else then please elaborate.

However, since I only want to show one line per vendor (the line being for the latest PO) I don't think that sorting the list will produce the result I am looking for - It will only get me to the point where I am at now trying to post-process the resultset, to get rid of the extra lines.