topic Copying internal table values into select options in Application Development and Automation Discussions

Copying internal table values into select options

Former Member — Wed, 16 Jan 2013 09:51:12 GMT

Hello all,

in the selection screen I am having two fields as select options, for eg date and vendor number. When date is filled, I would like to get the vendors automatically into the vendors field based on the date range.

I have created an internal table and retreived the values but unable to copy those into the select options field before executing the report.

can someone share their views on how to achive this.

thanks.

Re: Copying internal table values into select options

yogendra_bhaskar — Wed, 16 Jan 2013 09:59:22 GMT

Hi Chakravarthy ,

select options work same as range table ,

insert your data in select options as per as range table .

it will work

For help , View this :

TABLES SBOOK.

SELECT-OPTIONS FL_DATE FOR SBOOK-FLDATE.

INITIALIZATION.

MOVE: 'BT' TO FL_DATE-OPTION,

'19960101' TO FL_DATE-LOW,

'19960630' TO FL_DATE-HIGH.

APPEND FL_DATE.

MOVE: 'I' TO FL_DATE-SIGN,

'EQ' TO FL_DATE-OPTION,

SY-DATUM TO FL_DATE-LOW.

APPEND FL_DATE.

Re: Copying internal table values into select options

RaymondGiuseppi — Wed, 16 Jan 2013 10:07:30 GMT

(FAQ) Just loop at your internal table of vendors, and append records into the select-options parameter which is also an internal table, First read the select-options statement documentation.

Regards,

Raymond

PS: Spoiler (select to display) : If you cannot find it yourself , use SIGN = 'I', OPTION = 'EQ' and LOW = LIFNR.

Re: Copying internal table values into select options

Former Member — Wed, 16 Jan 2013 10:44:09 GMT

Hi,

thanks for the replies, I am able to retreive the records, but my question is how can i populate them in the select options field before executing the report.

regards.

Chakravarthy

Re: Copying internal table values into select options

former_member491621 — Wed, 16 Jan 2013 10:44:25 GMT

Hi Kumar,

 When date is filled, I would like to get the vendors automatically into the vendors field based on the date range.

From the above statement I assume you want to populate vendors within the selected date range. If so, then try the below code:

Suppose V_TAB is your vendor table.

DATA : wa_vendor LIKE LINE OF s_vendor.

DELETE V_TAB WHERE date > s_date-high and date < s_date-low.

SORT V_TAB ASCENDING BY vendor.

LOOP AT v_tab INTO wa_vtab.

wa_vendor-low = wa_vtab-vendor.

APPEND wa_vendor TO s_vendor.

ENDLOOP.

Hpoe this helps

Re: Copying internal table values into select options

Former Member — Wed, 16 Jan 2013 10:52:25 GMT

Hi Chakravarthy,

do u mean to tell that as soon as u type or input the date in input field, ur select option for vendor should get populated...means without executing? I think that will not be possible in core abap..u can do that in webdynpro etc..

Re: Copying internal table values into select options

Former Member — Wed, 16 Jan 2013 11:00:26 GMT

Hi Chakravarthy,

One option to do that is u can use AT SELECTION-SCREEN OUTPUT event...enter the dates and click enter... if u r getting the dates by F4 help then use the event AT SELECTION-SCREEN ON VALUE REQUEST... i hope it works...do let me know if this works..

good question anyway

Re: Copying internal table values into select options

yogendra_bhaskar — Wed, 16 Jan 2013 11:01:18 GMT

Hi kumar ,

I am not getting exactly , what you want ?

You want to display the records on selection screen ?

you want to populate the records in select option ?

Re: Copying internal table values into select options

Former Member — Wed, 16 Jan 2013 11:22:23 GMT

Hi Yogendra,

I would like to populate the records.

scenario is we need to do some pre-work in excel and then copy them to the select option vendor field and then execute the report.

so I am able to retreive the records as needed but dont know how to populate them in the field, as there would be no user action other than keying in the required fields.

Re: Copying internal table values into select options

Clemenss — Wed, 16 Jan 2013 11:26:25 GMT

Hi chakravarthy kumar,

you need a selection-screen event.

You may use AT SELECTION SCREEN and put the code as mentioned here.

Check SAP help on report selection screen events.

Regards

Clemens

Re: Copying internal table values into select options

Former Member — Wed, 16 Jan 2013 11:32:25 GMT

Hi Shahir,

i have tried at selection screen, but the issue is we cannot get the date values, anyways thanks a lot for all the inputs, maybe I should give some user event and use at user command.

Re: Copying internal table values into select options

yogendra_bhaskar — Wed, 16 Jan 2013 12:16:29 GMT

hi Chakravarthy ,

First of all write the code at selection screen output.

If you are getting the data from excel to any internal table e.g. it_tab

you have to write such code :

loop at it_tab into wa_itab.

MOVE: 'I' TO S_VENDOR-SIGN,

'EQ' TO S_VENDOR-OPTION,

wa_itab-kunnr to s_vendor-low.

append s_vendor.

endloop.

Re: Copying internal table values into select options

former_member491621 — Wed, 16 Jan 2013 13:02:02 GMT

Hi Chakravarthy,

Maybe you can use function key in you selection screen. It allows you to add a button on the application toolbar of the screen. After you enter date on the screen, you can click the button and get the vendor values in the select-options.

Here You have to use the ucomm of the table SSCRFIELDS(for selection screen fields).

You have to right the code in AT SELECTION SCREEN event for the button.

Hope this helps

Do revert back if you nedd anything

Re: Copying internal table values into select options

Former Member — Wed, 16 Jan 2013 19:02:29 GMT

thanks all, with at selection screen output was able to achive it.

so-vendor-sign = i

so-vendor-option = eq

loop at itab

so-vendor-low = itab-vendor1.

append so-vendor.

endloop

Re: Copying internal table values into select options

arumallaanusha — Mon, 14 Oct 2019 10:41:05 GMT

Is it possible to move the select statement output(structure) to the parameter value?

when I select the value from the search help of another parameter?

PARAMETERS:p1 TYPE zd_studentno MATCHCODE OBJECT z1132_sh,
p2 TYPE zd_studentname.

AT SELECTION-SCREEN OUTPUT .
SELECT SINGLE studentname FROM ztt_sd WHERE studentno = @p1 INTO @p2.