cancel
Showing results for 
Search instead for 
Did you mean: 

Syntax of select-options in select query ?

Accepted Solutions (0)

Answers (3)

Answers (3)

SugguSandeep
Contributor

Hi jospehb

Hope you are doing well 🙂

__________________________

First Thing You Need to learn is Go Through The SAP ABAP - Key Word Documentation which resource handled Officially by SAP Itself...

__________________________

Even Through you finding doubts, come back to SAP Community

Solution For Your Question : Refer This Link SELECT-OPTIONS

__________________________

If you find this helpful,

Reward It 🙂

Thanks,

Suggu Sandeep.

0 Kudos

It's Very Helpful Sandeep

Thank You So Much,

For Guiding me in a proper way, steps to follow in order way to get preparation Of in SAP ABAP...

adityaIngale
Active Participant

Hi Joseph,

Go through this link first to get the syntax Select option

Regards,

Aditya

adityaIngale
Active Participant

Suppose if you want to add matnr field from mara table in select-option then

1. Declare the local variable for matnr

2. Then use select-options

3. Write your select query and give your select options in where condition

For Example:-

Data lv_matnr type mara-matnr.
select-options so_matnr for lv_matnr.
Select Matnr, mbrsh, mtart from mara into @data(lt_mara) where matnr in so_matnr.

0 Kudos

Thank You Aditya

Sandra_Rossi
Active Contributor

Better learn by yourself, using Google or any Web search engine:

Syntax of select-options in select query site:sap.com

One of the answers (select-options in where condition of select statement | SAP Community😞

or

SELECT OPTIONS use in select statement | SAP Community

etc.

DominikTylczyn
SAP Champion
SAP Champion
0 Kudos

sandra.rossi I see you are using <code> tag to quote. That works partially but is not the nicest option. Personally I prefer italics but that is not optimal either. Obviously SAP Q&A lacks a simple quote block formatting. Therefore I put forward a simple improvement proposal Blockquote formatting in SAP Community Q&A. The blog article provides a link to the SAP Influence improvement proposal. You may want to spread the word and vote on the proposal. Maybe, someday, SAP Q&A will get that needed feature.

Sandra_Rossi
Active Contributor

3a9e4ce873a94034b33dc62b0ce600ee

(Already) voted!