topic Loading multiple entries into database table through selection screen in Application Development and Automation Discussions

Loading multiple entries into database table through selection screen

former_member791715 — Wed, 17 Mar 2021 12:45:34 GMT

I am trying to load multiple entries at a time into database table through selection screen. For this I used select-options but still it's allowing a single entry at a time. There is one column Select Single Values here I can only select multiple entries to display but not able to load multiple entries into the table.

SELECT-OPTIONS: s_id FOR zsample_tab-cid OBLIGATORY .

please let me know how to achieve this..

Re: Loading multiple entries into database table through selection screen

Former Member — Wed, 17 Mar 2021 12:45:49 GMT

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.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

Best,

Your SAP Community moderator

Re: Loading multiple entries into database table through selection screen

Sandra_Rossi — Wed, 17 Mar 2021 13:09:03 GMT

Please read carefully the ABAP documentation. Use IN operator:

SELECT * FROM table 
WHERE id IN s_id                            "<======= use "IN"
INTO TABLE @DATA(rows_from_table).