topic Re: NOT in Operator in Application Development and Automation Discussions

NOT in Operator

Former Member — Wed, 24 Sep 2008 08:13:36 GMT

Hello Experts,

Plz tell where i m wrong in my code.

if ( record-EKORG_002 NOT IN ('1000','1100' ,'1200' ) ).

move-corresponding record to it_error.

append it_error.

if ( record-bukrs_001 cs 'XYZ' ).

if ( ( record-ekorg_002 ne '1000' ) or ( record-ekorg_002 ne '1100' )

or ( record-ekorg_002 ne '1200' ) ).

move-corresponding record to it_error.

append it_error.

endif.

Re: NOT in Operator

Former Member — Wed, 24 Sep 2008 08:16:36 GMT

Hi,

Try this.

If u r using the second stmt, then try like this

if ( record-bukrs_001 cs 'XYZ' ).

if ( ( record-ekorg_002 ne '1000' ) AND

( record-ekorg_002 ne '1100' ) AND

( record-ekorg_002 ne '1200' ) ).

move-corresponding record to it_error.

append it_error.

endif.

Sharin

Re: NOT in Operator

Former Member — Wed, 24 Sep 2008 08:16:40 GMT

Hi,

chnage your below code as

if ( record-bukrs_001 cs 'XYZ' ).

if ( ( record-ekorg_002 ne '1000' ) and ( record-ekorg_002 ne '1100' )

and ( record-ekorg_002 ne '1200' ) ).

move-corresponding record to it_error.

append it_error.

endif.

Regards,

Paliwal

Re: NOT in Operator

Former Member — Wed, 24 Sep 2008 08:31:52 GMT

hi,


> if ( record-bukrs_001 cs 'XYZ' ).
> 
>    if ( ( record-ekorg_002 ne '1000' ) or ( record-ekorg_002 ne '1100' )
> or ( record-ekorg_002 ne '1200' ) ).
>     move-corresponding record to it_error.
>     append it_error.
> 
>   
>   endif.
> endif.

in place of OR use AND in the second IF statement.

thus your statement will look like following.


if ( ( record-ekorg_002 ne '1000' ) AND
  ( record-ekorg_002 ne '1100' ) AND
  ( record-ekorg_002 ne '1200' ) ).

Re: NOT in Operator

Neslinn — Wed, 24 Sep 2008 08:56:14 GMT

Hi ,

U have to use AND instead of OR condition as it is a NE operation. If you are gng for a EQ condition u can use the or condition.

Regards, Neslin.