select
mara~matnr
mara~mtart
mara~matkl
mara~bmatn
mara~bismt
mara~meins
mara~mfrpn
mara~mfrnr
makt~maktx
lfa1~lifnr
lfa1~name1
into table lt_output
from mara
inner join makt on mara~matnr = makt~matnr
inner join lfa1 on mara~mfrnr = lfa1~lifnr
where
mara~matnr in s_matnr and
mtart in s_mtart and
matkl in s_matkl and
bmatn in s_bmatn and
bismt in s_bismt and
meins in s_meins and
mfrpn in s_mfrpn and
mfrnr in s_mfrnr.
when I inner join these three tables am getting 34 records in the output table but when I enter material number matnr and check it, no records was showing up....I think inner join was failed can any one help me
Edited by: Thomas Zloch on Apr 14, 2010 4:21 PM - tags added