topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Thu, 20 Jan 2005 16:26:13 GMT

I want to read 200 registers of a table into an internal table, but 50 are limited to 90 kwh, 50 >90 kwh and <100kmw,....

ex:

select * into ita_reg from z where cod < 90.

endselect.

select * into ita_reg from z where (cod < 100 and cod >90).

endselect.

...

how can i do it?

RichHeilman — Thu, 20 Jan 2005 16:37:40 GMT

can you use the "UP TO n ROWS" extension?

Regards,

Rich Heilman

Message was edited by: Rich Heilman

Former Member — Thu, 20 Jan 2005 16:40:36 GMT

You can use Ranges

RANGES wa_z FOR marc-matnr.

CLEAR wa_z.

wa_z-sign = 'I'.

wa_z-option = 'BT'.

wa_z-low = 90.

wa_z-high = 100.

APPEND wa_z.

Then:

Select *

INTO TABLE ita_reg

FROM z

WHERE cod IN wa_z.

Hope this works for you.