topic Re: Fill an internal table using RANGES in Application Development and Automation Discussions

Fill an internal table using RANGES

Former Member — Thu, 26 Nov 2009 16:41:27 GMT

Hi,

I need to create an internal table with a join of several select options for then update another internal table.

I've this:

SELECT-OPTIONS: s_auart FOR zsd_ctrl_export-auart,

s_kunnr FOR zsd_ctrl_export-kunnr,

s_matnr FOR zsd_ctrl_export-matnr,

s_kwmenge FOR zsd_ctrl_export-kwmenge.

and i need to create a table with for all values in different select options i need to fill a table with this structure:

for exemple:

s_auart have values from Z200 to Z600

s_matnr have 2 or 3 materials

s_kunnr have some values

s_kwmenge have 1 value only.

at end my final table most be like this

AUART KUNNR MATNR KWMENGE

Z200 19999 1111111 1

Z300 19999 111111 1

Can i do "loop's" for a range ?

Thanks

Edited by: Ricardo Filipe Pimenta on Nov 26, 2009 5:41 PM

Re: Fill an internal table using RANGES

Former Member — Thu, 26 Nov 2009 16:53:48 GMT

Hi,

In your case , you can loop on select option.

Re: Fill an internal table using RANGES

Former Member — Thu, 26 Nov 2009 17:24:53 GMT

Hi,

You can loop on your select options and fill the final internal table.

Write your logic to handle 'I" (Include), 'E' (Exclude), 'EQ' and the rest.

Re: Fill an internal table using RANGES

Former Member — Thu, 26 Nov 2009 17:44:14 GMT

Hello,

It wouldn't really make sense to just loop at the select options and build your final internal table. Make a select query on your custom table zsd_ctrl_export with all the mentioned select-options in the where conditions and populate the final internal table

Vikranth