Modifying SQL in an infoset query

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member583013]

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.

[Former Member]

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

[Former Member]

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.