topic Re: error in the code with multiple where conditions in Application Development and Automation Discussions

error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 16:55:22 GMT

Hi all,

select single * from marC where matnr = '1234' AND

WERKS = 'ABC' AND

WERKS = 'XYZ' .

even though the material exist in both the plant it returns a sy-subrc eq to 4.

Though it supposed to return sy-subrc eq 0.

Thanks

Suchitra

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 16:57:51 GMT

select single * from marC where matnr = '1234' AND

WERKS in ( 'ABC', 'XYZ').

Try This

The select U have written always return sy-subrc 4 because u where checking whether plant is both ABC and XYZ which is always false . hence the select query was failing

Re: error in the code with multiple where conditions

RichHeilman — Tue, 22 May 2007 17:00:12 GMT

Try this.

select single * from marC where matnr = '1234'
        AND ( WERKS = 'ABC' or WERKS = 'XYZ'  ).

Regards,

Rich Heilman

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:00:19 GMT

Use the <b>CONVERSION_EXIT_ALPHA_INPUT or OUTPUT </b> for the material field and pass the material no, because it has to be 18 char.

select single * from marC where matnr = <b>'000000000000001234' AND

WERKS in ( 'ABC', 'XYZ').</b>

Reward points if useful

Regards

Anji

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:01:46 GMT

use ranges :

tables : marc.

range p_werks for marc-werks.

start-of-selection.

r_werks-low = '1234'.

r_werks-option = 'EQ'.

r_werks-sign = 'I'.

append r_werks.

r_werks-low = '1235'.

r_werks-option = 'EQ'.

r_werks-sign = 'I'.

append r_werks.

select single * from marC

where matnr = '1234' AND

WERKS in p_werks.

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:12:53 GMT

Hi ALL,

I WANT TO CHECK WHETHER THE MATERIAL IS PRESENT IN BOTH THE PLANTS THEN ONLY IT SHOULD A SY-SUBRC EQ 0

EVEN THOUGH IT EXISTS IN ONE PLANT IT SHOULD RETURN A SY-SUBRC NE 0.

select single * from marC where matnr = '1234' AND

WERKS = ('ABC' , 'XYZ' ).

WHEN I DO THIS EVEN THOUGH IT EXIST IN ONE PLANT IT RETURNS A SY-SUBRC EQ 0.

WHICH IS WRONG

lET ME KNOW HOW TO ACHIEVE THIS

THANKS

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:18:39 GMT

In that case use like this and see, still it gives error or not.

select single * from marC where matnr = '000000000000001234'

AND ( WERKS = 'ABC' and WERKS = 'XYZ' ).

Reward points if useful

Regards

Anji

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:19:47 GMT

select single * from marC

where matnr = '1234' AND

( WERKS = 'ABC' and WERKS = 'XYZ' ).

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:20:41 GMT

Hi,

With the syntax you provided it gives a sy-subrc eq 4 even though it exists in both the plants

Thanks

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:22:16 GMT

select single * from marC

where matnr = '000000000000001234' AND

( WERKS = 'ABC' and WERKS = 'XYZ' ).

try this one.

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:27:41 GMT

Hi ,

I DID TRIED THIS ONE .

EVEN THOUGH THE MATERIAL EXISTS IN BOTH THE PLANTS IT RETURNS A SY-SUBRC EQ 4

LET ME KNOW

THANKS

Re: error in the code with multiple where conditions

suresh_datti — Tue, 22 May 2007 17:37:13 GMT

You cannot use one SELECT SINGLE. intstead try with two ie

select single * from marC 
where matnr = '1234' AND
WERKS = 'ABC'. 
if sy-subrc eq 0.
select single * from marC 
where matnr = '1234' AND
      WERKS = 'XYZ' . 
if sy-subrc eq 0.
* record found
else.
*error.
endif.
endif.

~Suresh

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:40:27 GMT

Hi Suresh ,

In your case even though it exists in one plant the sy-subrc is equal to 0 right.

I want the sy-subrc to be 0 only when it exist in both the palnts

Thanks

Re: error in the code with multiple where conditions

suresh_datti — Tue, 22 May 2007 17:41:00 GMT

pl see my edited post above with two select singles.

~Suresh

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:45:14 GMT

do not use select single and it will get one record from database.

use select * from marc and try now.

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:47:56 GMT

try like this and you will get exact results :

tables : marc .

data wa_marc like marc occurs 0 with header line.

parameters : p_matnr like marc-matnr.

*ranges : r_werks for marc-werks.

start-of-selection.

*r_werks-low = '1000'.

*r_werks-sign = 'I'.

*r_werks-option = 'EQ'.

*append r_werks.

*r_werks-low = '1100'.

*r_werks-sign = 'I'.

*r_werks-option = 'EQ'.

*append r_werks.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = p_matnr

IMPORTING

OUTPUT = p_matnr

select * from marc into table wa_marc

where matnr = p_matnr

and ( werks = '1000' and werks = '1100' ).

if sy-subrc eq 0.

write:/ 'Plant is okay'.

endif.

Reward Points if it is helpful

Thanks

Seshu

Re: error in the code with multiple where conditions

Former Member — Tue, 22 May 2007 17:54:12 GMT

Hi ALL,

THANKS FOR YOUR REPLIES.

i THOUGH OF DOING THIS WITHOUT CREATING ANY INTERNAL TABLES AND WITH A SINGLE STATEMENT.

I guess it doesn't seem to work that way

I went multiple select statements

I awarded points to all

Thanks AGAIN