topic Re: Using operator 'OR' in WHERE condition in Application Development and Automation Discussions

Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 07:44:35 GMT

Hi,

I have a doubt in using the relational operator 'OR'.

Consider the below case:

To fetch data where FLTYP is equal to A or B or G.

1) SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR AND SPRAS = 'E' AND

( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ).

It is not working if i give it like this

2) WHERE TPLNR = T_ILOA-TPLNR AND

( FLTYP = 'B' ) OR ( FLTYP = 'A' ) OR ( FLTYP = 'G' ) AND SPRAS = 'E' .

If i give it as above , its not fetching data where FLTYP = B, but its fetching for 'A' and 'G'.

3) WHERE ( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ) AND

( SPRAS = 'E' AND TPLNR = T_ILOA-TPLNR ).

This is also not working.

How do i check this condition with 'OR' operator.

Help me on this issue.

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 07:57:22 GMT

Here is some analysis.

1) SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR AND SPRAS = 'E' AND

( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ).

- In this case first it will check TPLNR value and then language 'E' if both the conditions satisfied then only it will check for FLTYP is B or A or G.

2) WHERE TPLNR = T_ILOA-TPLNR AND

( FLTYP = 'B' ) OR ( FLTYP = 'A' ) OR ( FLTYP = 'G' ) AND SPRAS = 'E' .

Here analyzing is difficult. it will check TPLNR value and fltyp value B. if the combination is wrong then only it will check fltyp = A. i mean here even though TPLNR value is not in list it will fetch data based on fltyp = A or G. as you specified AND for language at the end .. it will work like this

case 1: TPLNR value satisfied and fltyp = B - record will fetch

case 2: case 1 not satisfied. fltyp = A and language = E - record will fetch

case 3: case 1 and 2 not satisfied. fltyp = G and language = E - fetches the record

all other conditions dont fetch record.

3) WHERE ( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ) AND

( SPRAS = 'E' AND TPLNR = T_ILOA-TPLNR ).

here fltyp should be one among B/A/G and language shld be E and TPLNR should match.. then only record will come.

basically OR will work as any of the value is true then it will fetch record. here i think your prob is with AND.

if you want records with FLTYP = B/A/G and language = E give like this

where ( FLTYP = 'B' or FLTYP = 'A' or FLTYP = 'G' ) AND SPRAS = 'E'.

not in the abouve records you want only records whose TPLNR is in your list.. then give another AND

where ( FLTYP = 'B' or FLTYP = 'A' or FLTYP = 'G' ) AND SPRAS = 'E' AND TPLNR = T_ILOA-TPLNR.

my suggestion is first give only ( FLTYP = 'B' or FLTYP = 'A' or FLTYP = 'G' in WHERE check the result next add SPRAS .. check output next add TPLNR condition..

it will work.

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 07:59:23 GMT

Hi,

SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR

AND SPRAS = 'E'

AND ( FLTYP = 'B'

OR FLTYP = 'A'

OR FLTYP = 'G' ).

this should work.

it is better create a range table for FLTYP and fill that range table and use .

data:

t_range type range of FLTYP.

t_range-low = 'A'.

t_range-sigh = 'I'.

t_range-option = 'EQ'.

append t_range.

t_range-low = 'B'.

t_range-sigh = 'I'.

t_range-option = 'EQ'.

append t_range.

t_range-low = 'G.

t_range-sigh = 'I'.

t_range-option = 'EQ'.

append t_range.

and write select as .

SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR

AND SPRAS = 'E'

AND FLTYP in t_range.

or u can write select as.

SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR

AND SPRAS = 'E'

AND FLTYP in ( 'A' 'B' 'G').

please check syntax for this.

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 07:59:41 GMT

Hi,

You might want to try this:

SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR AND SPRAS = 'E' AND

FLTYP IN ('B','A','G').

Re: Using operator 'OR' in WHERE condition

rainer_hbenthal — Thu, 25 Sep 2008 08:01:44 GMT


and  FLTYP in ('B','A','G' )

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 09:35:10 GMT

Hi,

Thanks for your help and effort taken to explain but none of it is working.

Can you suggest any other method?

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 09:36:27 GMT

Hi,

Thanks for your help but none of it is working.

Can you suggest any other method?

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 09:43:07 GMT

Hi,

Thanks Rainer Hübenthal . Its not working.

Anyother option?

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 09:50:03 GMT

hi,

c1: TPLNR = T_ILOA-TPLNR

c2: SPRAS = 'E'

c3: FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G'

FLTYP should be one of the B,A,G, so you must put bracket for this set of condition.you can consider like above.you can change the order of above. but condition(c3) must be in brackets.so your first code is right.The below all coding are correct. it will give same result, but order is changed.

TPLNR = T_ILOA-TPLNR AND SPRAS = 'E' AND

( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' )

TPLNR = T_ILOA-TPLNR AND ( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ) AND SPRAS = 'E'

SPRAS = 'E' AND

( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ) AND TPLNR = T_ILOA-TPLNR

Re: Using operator 'OR' in WHERE condition

JozsefSzikszai — Thu, 25 Sep 2008 09:55:06 GMT

I think there could be two reasons:

1. Really no record matches with the selection criteria ==> this could be easily checked in SE16

2. There is a conversion exit on TPLNR, so the question is how t_iloa is filled with values?

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 10:01:34 GMT

Hi,

I have done the conversion as given below,hope am correct ,the problem is with the OR operate used in the where condition.

The converted TPLNR from ILOA exists in IFLO table in SE16.

SELECT ILOAN

TPLNR

FROM ILOA INTO TABLE T_ILOA

FOR ALL ENTRIES IN T_EQUZ

WHERE ILOAN = T_EQUZ-ILOAN.

*To convert the format of TPLNR from ILOA table

LOOP AT T_ILOA INTO W_ILOA.

CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT'

EXPORTING

INPUT = W_ILOA-TPLNR

IMPORTING

OUTPUT = W_ILOA-TPLNR.

MODIFY T_ILOA FROM W_ILOA.

ENDLOOP.

*To fetch the TPLNR and FLTYP by passing the ILOA-TPLNR with the condition FLTYP = A/B/G

IF T_ILOA[] IS NOT INITIAL.

SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR AND ( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ).

*To convert the format of TPLNR from IFLO table

LOOP AT T_IFLO INTO W_IFLO.

CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT'

EXPORTING

INPUT = W_IFLO-TPLNR

IMPORTING

OUTPUT = W_IFLO-TPLNR.

MODIFY T_IFLO FROM W_IFLO.

ENDLOOP.

Can you suggest any conclusion for this issue?

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

JozsefSzikszai — Thu, 25 Sep 2008 10:04:06 GMT

remove (or comment) this part:

*To convert the format of TPLNR from ILOA table

LOOP AT T_ILOA INTO W_ILOA.

CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT'

EXPORTING

INPUT = W_ILOA-TPLNR

IMPORTING

OUTPUT = W_ILOA-TPLNR.

MODIFY T_ILOA FROM W_ILOA.

ENDLOOP.

this is the case when you DON'T need the conversion exit, because the data is directly from the DB in unconverted format and that is the format you'll need by DB selection as well.

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 10:16:43 GMT

Hi,

Thanks for your response Eric Cartman.

As per your suggestion i removed that conversion part but still its not working.

When i use it as below its working,but that is not the correct way.

SELECT TPLNR

FLTYP

FROM IFLO INTO TABLE T_IFLO

FOR ALL ENTRIES IN T_ILOA

WHERE TPLNR = T_ILOA-TPLNR OR ( FLTYP = 'B' OR FLTYP = 'A' OR FLTYP = 'G' ).

No other way is working.

I tried all the replies pertaining to this thread but its ineffective.

What else can be done?

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 10:24:45 GMT

Hello,

Please use conversion routine 'CONVERSION_EXIT_TPLNR_INPUT while selecting data from IFLO view.

Regards,

Rajat

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 10:35:54 GMT

Hi,

The FM 'CONVERSION_EXIT_TPLNR_INPUT' does nothing.

Anyother suggestion?

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

JozsefSzikszai — Thu, 25 Sep 2008 11:05:20 GMT

as I told the other problem could be that the record really does not exist (with the given conditions) - this can easily be checked in SE16. Could you please check if it is maintaned in English? and the FLTYP is A or B or G...

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 11:25:42 GMT

Hi,

I checked in SE16 the record for my input exists in both ILOA and IFLO.Tried passing i/p data in DB level with SPRAS = 'E' and without passing the lang(SPRAS) ,it gives me the result.

Lang SPRAS = 'E' is correct.It exists for the given input in SE16.Hope this is not the problem.

I removed the condition SPRAS = 'E' in my where condt but still its not working.

Can you give me anyother suggestion?

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 11:35:31 GMT

Hi,

My i/p is in such a way that ITS FLTYP is either A/B/G and has lang="E' and IFLO-FLTYP amtches with ILOA-FLTYP.

Regards,

P.S.Chitra

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 11:45:49 GMT

Hi chitra,

Instead of INTO TABLE T_IFLO you can try using INTO CORRESPONDING FIELDS OF TABLE T_IFLO as you are selecting only two fields.

Try and revert back.

Regards

Karthik D

Re: Using operator 'OR' in WHERE condition

Former Member — Thu, 25 Sep 2008 11:58:58 GMT

Hi Karthik,

Good attempt but its not working.

Anyother suggestions?

Regards,

P.S.Chitra