topic Re: SAP Query - Selection screen field doubled in Application Development and Automation Discussions

SAP Query - Selection screen field doubled

axel_ — Wed, 07 Feb 2018 13:49:50 GMT

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

Re: SAP Query - Selection screen field doubled

Jelena_Perfiljeva — Wed, 07 Feb 2018 16:14:39 GMT

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.

Re: SAP Query - Selection screen field doubled

axel_ — Thu, 08 Feb 2018 11:37:38 GMT

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

Re: SAP Query - Selection screen field doubled

Jelena_Perfiljeva — Thu, 08 Feb 2018 20:46:13 GMT

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.

Re: SAP Query - Selection screen field doubled

axel_ — Fri, 23 Nov 2018 07:35:01 GMT

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.