topic Re: Internal table processing in Application Development and Automation Discussions

Internal table processing

Former Member — Tue, 10 Mar 2009 03:19:29 GMT

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.

Re: Internal table processing

Former Member — Tue, 10 Mar 2009 03:23:08 GMT

Hi,

DELETE ITAB WHERE movement type NOT IN S_MOVENTYPE.

Only this record will be left ..

008 I 10tp I 201.

Re: Internal table processing

Former Member — Tue, 10 Mar 2009 03:27:24 GMT

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

Re: Internal table processing

former_member156446 — Tue, 10 Mar 2009 03:29:29 GMT

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.

Re: Internal table processing

Former Member — Tue, 10 Mar 2009 03:35:26 GMT

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

Re: Internal table processing

Former Member — Tue, 10 Mar 2009 03:51:01 GMT

hi,

try: NOT IN Movement

ex:

delete ... where Movement NOT IN Movement

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

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