Issue regarding Select Query

[Former Member]

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.

[Former Member]

Hi,

What is the problem you are facing ?

Regards,

Pramod

[former_member585060]

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