topic Re: select querry in Application Development and Automation Discussions

select querry

Former Member — Thu, 16 Nov 2006 08:38:36 GMT

Hi Friends,

I need the bewtp to check twice with E and Q, My select querry is picking all the data. Pls check the select statement and correct it

SELECT ebeln

ebelp

belnr

budat

menge

dmbtr

matnr

werks

bewtp into corresponding fields of table lt_ekbe FROM ekbe

WHERE matnr IN so_matnr

AND budat IN so_budat

and bewtp EQ 'E'

OR bewtp EQ 'Q'.

Thanx and regards,,

Turbin

Re: select querry

Former Member — Thu, 16 Nov 2006 08:40:42 GMT

SELECT ebeln

ebelp

belnr

budat

menge

dmbtr

matnr

werks

bewtp into corresponding fields of table lt_ekbe FROM ekbe

WHERE matnr IN so_matnr

AND budat IN so_budat

and <b>( bewtp EQ 'E' OR bewtp EQ 'Q' )</b>.

Do the changes as highlighted.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: select querry

messier31 — Thu, 16 Nov 2006 08:46:11 GMT

Hi Line,

Try following......

SELECT ebeln

ebelp

belnr

budat

menge

dmbtr

matnr

werks

bewtp

into corresponding fields of table lt_ekbe FROM ekbe

WHERE matnr IN so_matnr AND

budat IN so_budat AND

( bewtp EQ 'E' OR bewtp EQ 'Q' ) .

hope this helps you...

Enjoy SAP.

Pankaj Singh.

Re: select querry

Former Member — Thu, 16 Nov 2006 08:55:09 GMT

SELECT ebeln

ebelp

belnr

budat

menge

dmbtr

matnr

werks

bewtp into corresponding fields of table lt_ekbe FROM ekbe

WHERE matnr IN so_matnr

AND budat IN so_budat

and (bewtp EQ 'E' OR bewtp EQ 'Q' ).

Message was edited by:

V.S.N.A.Subhakar Ramineni

Re: select querry

Former Member — Thu, 16 Nov 2006 09:01:50 GMT

<b>Just for your info</b>, we can acheive the same as below too...

SELECT ebeln ebelp belnr budat menge 
              dmbtr matnr werks bewtp 
              into corresponding fields of table lt_ekbe 
              FROM ekbe
              WHERE matnr IN so_matnr
              AND budat IN so_budat
              and bewtp <b>IN ('E', 'Q').</b>

Kind Regards

Eswar