Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Restrict the company codes in query.

former_member876555
Member

‎2023 Sep 01 9:02 AM

0 Kudos
266

Hello Everyone,

I had a problem with infoset (SQ02). When I run the query (SQ01) by giving input of company code(BSIK -bukrs) it's displaying the data of two tables(Lfbk &bsik). I need to write a logic in SQ02 to restrict the company codes like if we give 1001,1002,1003 it should display the data other than the company code it should give the error message as company code restricted...

The local variable for retrieving the data using is %SELOPT

It's urgent.

Please help me with this with logic used and where to apply the logic..I am new to this SAP Query related work.

Appreciate your time and response!

1 REPLY 1

AnnePetteroe
Community Manager
Community Manager

‎2023 Sep 01 9:02 AM

0 Kudos
233

Hi Priya,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,
Anne