topic Re: Range in Application Development and Automation Discussions

Range

Former Member — Fri, 16 Feb 2007 05:54:59 GMT

Hi,

I have to take sum of MENGE of Materails according to Movement types

I have created a Range ""r_bwart"" which has 101,102,105,106 .... movement types.

Suppose i need to take sum of MENGE of materials which are not in this Range r_bwart can i use the following code below ( Code commended in BOLD and underlined )...

LOOP AT t_mseg INTO w_mseg.

IF ( w_mseg-bwart = c_651 OR w_mseg-bwart = c_652 ).

w_custre = w_custre + w_mseg-menge.

ELSEIF ( w_mseg-bwart = c_101 OR w_mseg-bwart = c_102

OR w_mseg-bwart = c_105 OR w_mseg-bwart = c_106

OR w_mseg-bwart = c_122 OR w_mseg-bwart = c_123

OR w_mseg-bwart = c_301 OR w_mseg-bwart = c_302

OR w_mseg-bwart = c_305 OR w_mseg-bwart = c_306 ) .

w_posto = w_posto + w_mseg-menge.

ELSEIF ( w_mseg-bwart = c_601 OR w_mseg-bwart = c_602 ).

w_so = w_so + w_mseg-menge.

ELSEIF ( w_mseg-bwart = c_641 OR w_mseg-bwart = c_642

OR w_mseg-bwart = c_301 OR w_mseg-bwart = c_302 ).

w_stointm = w_stointm + w_mseg-menge.

ELSEIF ( w_mseg-bwart NOT IN r_bwart ).

w_otrmo = w_otrmo + w_mseg-menge.

ENDIF.

ENDLOOP.

Regards Avi

Re: Range

Former Member — Fri, 16 Feb 2007 05:59:01 GMT

Hi,

When you have checked for all conditions(movement Types) with ELSEIF's, then the last ELSE will automatically give the leftout sum of the quantities.

So just place ELSE instead of

ELSEIF ( w_mseg-bwart NOT IN r_bwart ).

Regards,

Anji

Re: Range

Former Member — Fri, 16 Feb 2007 06:01:37 GMT

i think in IF you can not use IN operator only range operator is [not] BETWEEN.

please correct me if i am wrong.

regards

shiba dutta

Re: Range

Former Member — Fri, 16 Feb 2007 06:02:55 GMT

so you can change

if w_mseg-bwart NOT between r_bwart..

regards

shiba dutta

Re: Range

Former Member — Fri, 16 Feb 2007 06:10:06 GMT

HI.

ELSEIF not w_mseg-bwart between r_bwart-low AND r_bwart-High

Regards

Sudheer

Re: Range

Former Member — Fri, 16 Feb 2007 07:36:52 GMT

U have to use as belwo:

ELSEIF NOT w_mseg-bwart IN r_bwart .

This will work. Reward points if this solves.

Try this for sample.

data: test LIKE mara-matnr value '10000002'.
if NOT test in s_test.
write:/ 'test mara'.
elseif NOT test in s_test.
endif.