Regarding Inner join query

[Former Member]

Hi Guriji,s

I wrote one inner join query. it is working fine. but when i exceute this query it is fetching the data only 261 movement type but but i also fetch the data movement type 201. for this plz tell me the correction in this query.

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and a}bwart = '261' or a~bwart = '201'

and b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' .

thanks.

[Former Member]

Hi,

Change OR to AND in the where clause condition of the query

Vikranth

[kesavadas_thekkillath]

Code like this

select a~matnr a~werks a~bwart b~budat into table t_itab 
from mseg as a inner join mkpf as b on a~mblnr = b~mblnr
where a~werks in plant 
and a~bwart in('261','201')
and b~tcode2 in ('mb1a','mfbf') .

[praveen_hannu]

Hi Sachin

try to use like below

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and ( a}bwart = '261' or a~bwart = '201' )

and ( b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' ).

or try to fill ranges like select-options or use like

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and a}bwart in ('261', '201')

and b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' .

Regards

Praveen

[Former Member]

HI ,

U write as like this

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and ( a}bwart = '261' or a~bwart = '201 ' )'

and b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' .

Thanks

Shambhu

[Former Member]

HI ,

U write as like this

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and ( a}bwart = '261' or a~bwart = '201 ' )'

and ( b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf )' .

Thanks

Shambhu