topic Issue regarding Select Query in Application Development and Automation Discussions

Issue regarding Select Query

Former Member — Sat, 11 Oct 2008 03:52:00 GMT

Hello experts,

I want a join on table ekpo & mbew(for valuation class).

But its not working.

if valclass is initial.

select a_{ebeln a}ebelp a_{txz01 a}matnr a_{bukrs a}werks a~menge

a~mtart

b~bklas

from ekpo as a inner join mbew as b on b_{matnr eq a}matnr

into corresponding fields of table ekpo_mbew

where ( a~matnr eq mat_num ) and

( a~bukrs eq compcode ) and

( a~werks eq plant ) and

( a~mtart eq mat_type ) and

b~bklas in ('3001','3045' ,'3006','3055','3065') and

( a_{matnr eq b}matnr ).

else.

select a_{ebeln a}ebelp a_{txz01 a}matnr a_{bukrs a}werks a~menge

a~mtart

b~bklas

from ekpo as a inner join mbew as b on b_{matnr eq a}matnr

into corresponding fields of table ekpo_mbew

where ( a~matnr eq mat_num ) and

( a~bukrs eq compcode ) and

( a~werks eq plant ) and

( a~mtart eq mat_type ) and

( b~bklas in valclass ) and

( a_{matnr eq b}matnr ).

endif.

Plz tell where I m wrng.

Ravi.

Re: Issue regarding Select Query

Former Member — Sat, 11 Oct 2008 03:57:44 GMT

Hi,

What is the problem you are facing ?

Regards,

Pramod

Re: Issue regarding Select Query

former_member585060 — Sat, 11 Oct 2008 04:08:04 GMT

Hi,

Try the below code,

SELECT a_{ebeln a}ebelp a_{txz01 a}matnr a_{bukrs a}werks a~menge

a~mtart

b~bklas

FROM ekpo AS a INNER JOIN mbew AS b ON b_{matnr EQ a}matnr INTO CORRESPONDING FIELDS OF TABLE ekpo_mbew

WHERE a~matnr EQ mat_num AND

a~bukrs EQ compcode AND

a~werks EQ plant AND

a~mtart EQ mat_type AND

b~bklas IN ('3001','3045' ,'3006','3055','3065').

ELSE.

SELECT a_{ebeln a}ebelp a_{txz01 a}matnr a_{bukrs a}werks a~menge

a~mtart

b~bklas

FROM ekpo AS a INNER JOIN mbew AS b

ON b_{matnr EQ a}matnr

INTO CORRESPONDING FIELDS OF TABLE ekpo_mbew

WHERE a~matnr EQ mat_num AND

a~bukrs EQ compcode AND

a~werks EQ plant AND

a~mtart eq mat_type AND

b~bklas IN valclass .

Note :- ( a_{matnr eq b}matnr ) this is not necessary as the INNER JOIN is on that condition itself.

Regards

Bala Krishna