Internal table processing

[Former Member]

HI guru's,

I have the field in selection screen as

Movement type as select-option.

and i have the internal table...

matnt I lgort I movement type I

01 I 10tp I 100

02 I 10tp I 101

-

---

-

---

007 I 10tp I 200

008 I 10tp I 201.

If i enter the movement type as 100 to 200..

i don't want to select the material whic hit the movement type in between 100 to 200..

from the above example i want the data like this..

matnt I lgort I movement type I

008 I 10tp I 201.

can any one please explain me..

Thanks & Best Regards,

Praveen.

[Former Member]

Hi,

DELETE ITAB WHERE movement type NOT IN S_MOVENTYPE.

Only this record will be left ..

008 I 10tp I 201.

[Former Member]

Hi praveen,

U can populate the range having high value as 200 and low value is 100 sign as I option as BT and

Select the data where movement type not in the range

i.e Select * from tablename where movement not in renage[].

Thanks & Regards,

Ruchi Tiwari

[former_member156446]

Try this way:

data: ra_range type selopt.

ra_range-sign = 'E'.  "excluding
ra_range-option = 'EQ'.
ra_range-low = '100'.
ra_range-high = '200'.

select...

 where field in ra_range.

[Former Member]

Hi,

We can populate the data not in this range low 100 to 200. Enter thsi range in seelct option as Exclude range.

Regards

Md.MaahboobKhan

[Former Member]

hi,

try: NOT IN Movement

ex:

delete ... where Movement NOT IN Movement

or

loop at itab into ... where Movement NOT IN Movement

if you do not use other Movenent type, just use it in select statement.