Skip to Content
avatar image
Axel Radack

SAP Query - Selection screen field doubled

Feb 07, 2018 at 01:49 PM | 83 Views

Hi Folks,

I got an infoset with a selection to check authorizations as described in below blog

https://blogs.sap.com/2015/11/23/custom-authorization-in-sq01-queries/

The field I use in the selection I want also to use in the Output. However, when I insert the field into the field list of the SAP Query and execute the query I get two time the selection field (one from the infoset and the other from the sap query). Strangely I cannot disable selection for the field in the sap query Definition. Only complete removal works to get only one field.

Any ideas what I am doing wrong?

Thanks for all replies in advance.

Axel

ABAP Development
sap query | infoset | sq01
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Axel Radack
    Nov 23, 2018 at 07:35 AM

    For all that face the same issue:

    The trick is .... first delete the selection in the infoset code etc.

    Then go to the query an uncheck there the selection.

    Now re-implement the seleciton in the infoset. Finally you got the selection just one time on the screen.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Axel Radack
    Feb 08, 2018 at 11:37 AM

    Hi Jelena,

    if I insert the field into the Basic list the selection check box is marked and grayed out -> cannot be unchecked.

    Best regards,

    Axel

    Add comment
    10|10000 characters needed characters exceeded

    • Jelena Perfiljeva
      Feb 08, 2018 at 08:46 PM

      Please use "Comment on this answer" button to reply, otherwise the person you're replying to is not notified. And it's confusing to the readers as well.

      Sorry, I'm confused by this statement... How do you "insert" the field in the Basic list? The fields are in the infoset. In the query, basic list shows all the fields in the infoset and we can check some checkboxes. There is no "inserting", to my knowledge. Please post more details about your objects and the screenshots, as was suggested.

  • avatar image
    Jelena Perfiljeva
    Feb 07, 2018 at 04:14 PM

    This means that you have a selection field in the infoset and the same selection field in the query. If an obvious solution of unchecking the selection checkbox in query (Selections screen or Basic List screen) does not work try the menu Query -> More functions -> Adjust and Generate program. Maybe query is just stuck with the old setting somehow.

    If the issue persists then post a screenshot, including the options for the field in question in both infoset and query.

    Add comment
    10|10000 characters needed characters exceeded