Skip to Content
avatar image
Former Member

Modifying SQL in an infoset query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 20, 2007 at 08:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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 😊

  • avatar image
    Former Member
    Aug 20, 2007 at 08:22 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2007 at 07:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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