topic Re: using the IN statement in Application Development and Automation Discussions

using the IN statement

Former Member — Tue, 19 Dec 2006 17:04:43 GMT

Can soembody send soem sample code using an IN statement? I am using it but get errors. Proble is the editor is in German and I don't know what it is saying!

IF COMM_STRUCTURE-COSTELMNT IN ('84300005','84300006').

RESULT = 'PM_LABOR'.

elseif COMM_STRUCTURE-COSTELMNT IN (61100950).

RESULT = 'PM_NON_STOCK'.

endif.

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:07:08 GMT

Hi,

For IF statement you cannot use fixed values..Instead create a ranges..and use it in your IN..

Example..

RANGES: R_MATNR FOR MARA-MATNR.

R_MATNR-SIGN = 'I'.

R_MATNR-OPTION = 'EQ'.

R_MATNR-LOW = 'ABCD'.

APPEND R_MATNR.

R_MATNR-SIGN = 'I'.

R_MATNR-OPTION = 'EQ'.

R_MATNR-LOW = 'ABCDADSF'.

APPEND R_MATNR.

IF MARA-MATNR IN R_MATNR.

WRITE: / 'TRUE'.

ELSE.

WRITE: / 'FALSE'.

ENDIF.

Thanks

Naren

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:07:10 GMT

IF COMM_STRUCTURE-COSTELMNT IN ( '84300005' , '84300006' ).
RESULT = 'PM_LABOR'.
elseif COMM_STRUCTURE-COSTELMNT IN ( '61100950' ).
RESULT = 'PM_NON_STOCK'.
endif.

Make sure you have space after and before ().

Regards,

Ravi

Note - Please mark all the helpful answers

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:13:54 GMT

I did that and now it says

E:Comma without preceding colon (after IF ?).

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:17:20 GMT

The sample code I am looing at uses it. I thought it was due to missing spaces. I can't really use a range becuase in some cases it isn't a range of values so i quess I could use the equal to

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:18:09 GMT

Looks like the problem is with the statement before / after the IF statement.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:19:24 GMT

Hi,

For single values also you can use the RANGES..

You have to give EQ in the option..

RANGES: R_MATNR FOR MARA-MATNR.

R_MATNR-SIGN = 'I'.

R_MATNR-OPTION = <b>'EQ'</b>.

R_MATNR-LOW = 'ABCD'.

APPEND R_MATNR.

R_MATNR-SIGN = 'I'.

R_MATNR-OPTION = <b>'EQ'</b>.

R_MATNR-LOW = 'ABCDADSF'.

APPEND R_MATNR

Thanks,

Naren

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:20:57 GMT

Hi,

here is a suggestion for your statement. Instead of using IN Statement you can use this:

if COMM_STRUCTURE-COSTELMNT >= ''84300005' AND COMM_STRUCTURE-COSTELMNT <= '84300006'.

RESULT = 'PM_LABOR'.

elseif COMM_STRUCTURE-COSTELMNT = 61100950.

RESULT = 'PM_NON_STOCK'.

endif.

Is it useful?

Ashven

Re: using the IN statement

RichHeilman — Tue, 19 Dec 2006 17:24:03 GMT

Try this.




IF   ( COMM_STRUCTURE-COSTELMNT = '84300005'
    or COMM_STRUCTURE-COSTELMNT = '84300006' ).
   RESULT = 'PM_LABOR'.
elseif COMM_STRUCTURE-COSTELMNT = '61100950' .
   RESULT = 'PM_NON_STOCK'.
endif.

Regards,

Rich Heilman

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:24:05 GMT

WHEN i DO WHAT Narendran suggests it works. I think he is correct and I can't use constants with and IF

Re: using the IN statement

Former Member — Tue, 19 Dec 2006 17:26:31 GMT

Hi,

Please reward points for helpful answers..

Thanks,

Naren