topic Re: loop at select options in Application Development and Automation Discussions

loop at select options

Former Member — Mon, 22 Sep 2014 08:59:04 GMT

Hi All,

Based on the earlier discussions I have tried the suggested solutions. But nothing works for my case. Kindly help.

I am declaring select options as follows.

SELECT-OPTIONS: s_no for vbak-vbeln.

LOOP AT s_no INTO wa_s_no.

...

ENDLOOP.

Suppose if I give the document number in the range like this 9200101150 to 9200101155.

I need to get all the documents in place. VBELN is of the type char. So I cannot increment also.

Please suggest any ways.

Re: loop at select options

Former Member — Mon, 22 Sep 2014 09:03:14 GMT

Get it from DB VBAK like below.

Select * into table lt_vbak

from vbak

where vbeln in s_no.

Re: loop at select options

rosenberg_eitan — Mon, 22 Sep 2014 09:09:44 GMT

Hi,

This work for the rest of us:

DATA: r_vbeln TYPE RANGE OF vbak-vbeln."Same as SELECT-OPTIONS:

DATA: it_vbak TYPE TABLE OF vbak .

SELECT * INTO TABLE it_vbak
FROM vbak
WHERE
    vbeln IN r_vbeln .

What is different in your case ?

Regards.

Re: loop at select options

PeterJonker — Mon, 22 Sep 2014 09:09:52 GMT

What is the problem ?

Why you want/need to loop over your select-options ?

Like Niyaz said, you can use the select-options in your select without doing anything,so why are you looping ? What is it you want to achieve ?

Re: loop at select options

rosenberg_eitan — Mon, 22 Sep 2014 09:16:18 GMT

Hi,

About the increment:

Regards.

Re: loop at select options

RaymondGiuseppi — Mon, 22 Sep 2014 10:00:36 GMT

Can you elaborate on actual requirement, some preliminary remarks :

You can use the range in a "WHERE vbeln IN s_no." to get information from database, e.g. table VBAK
You can add 1 to such fields, here VBELN usually contains only numbers, so implicit conversion to and from number should be successful, but you can (should) of course add some TRY/CATCH/ENDTRY

Converting such a range to a list of value can generate some problems, e.g. dump if you generate a too wide range for a SQL statement, performance problem if you use a FOR ALL ENTRIES.

So why (and what) do you ask this ?

Regards,

Raymond

Re: loop at select options

Former Member — Mon, 22 Sep 2014 12:06:29 GMT

Hello guys,

Based on the requirement i cannot take this S_no directly from VBAK. I need to append these document numbers with VBFA records and then i have to get it from VBAK. SO I need to loop at s_no. VBAK-VBELN is of char type and so I cannot increment it.

Re: loop at select options

Former Member — Mon, 22 Sep 2014 12:11:41 GMT

hi Raghavendra Ghooli,

befor you can loop through the vbeln given in your select-option, you have to add an additional step and select them manually from Database.

Because as you already figured you can give ranges and will just have 2 numbers in your select-option.

So do a simply select - as by examples above already provided - and you will get a table suited with all the vbeln.

regards

Stefan Seeburger

Re: loop at select options

VenkatRamesh_V — Mon, 22 Sep 2014 12:58:32 GMT

Hi,

Hope it help full.

Select-options: s_no for vbak-vbeln.

if s_no-high is initial.

move s_no-low to s_no-high.

endif.

Select * from vbak

where vbeln between s_no-low and s_no-high.

Endselect.

Regards,

Venkat.

Re: loop at select options

Former Member — Mon, 22 Sep 2014 13:00:33 GMT

Dont loop the selection screen parameter.

First create internal table and work area.

TABLES : VBAK.

DATA: lt_tab type table of VBAK,

wa_tab type VBAK.

Then,select all entries from Database by the range given in S_NO .

for this follow this code.

SELECT * FROM vbak INTO TABLE lt_tab WHERE vbeln IN s_no.

then loop this internal table(lt_tab) into work area(wa_tab).

inside the loop just type all the fileds you need to display using WRITE statment.

LOOP AT LT_TAB INTO wa_tab.

.....

ENDLOOP.

Regards,

Ganesa Moorthy S.

Re: loop at select options

Former Member — Mon, 22 Sep 2014 14:26:33 GMT

Guys,

Thanks for your all suggestions.

My requirement is to initially query VBFA table. Now append S_no data to this selected VBFA.

After this we have filters and some other logic. At the end of this, based on this selected VBELN I have to query VBAK.

Suppose if I have 100s of documents in s_no, I am looping at it and selecting the data from VBAK. Why looping means we have some other requirements and logic. This is working fine and even performance wise it is agreed.

Now suppose if document range is given then it is taking only one loop and I am not able to get all the documents which are there in between.

Kindly help.

Re: loop at select options

Former Member — Mon, 22 Sep 2014 14:53:28 GMT

Hi,

as mentioned above, dont work with select-option directly. preselect your numbers to an internal table

regards

Stefan Seeburger

Re: loop at select options

Former Member — Mon, 22 Sep 2014 15:12:56 GMT

Do you have any select on vbak already use the output of the same if not, then as everyone has suggested only option is to fetch from vbak and use.

Re: loop at select options

Former Member — Wed, 24 Sep 2014 03:24:48 GMT

This was related to performance also. I wanted to avoid multiple selects for a single table. As loop at s_no is not possible, selecting from same table multiple times. Let me wait for the review result.

Thank you all.