Skip to Content
0
Former Member
Apr 14, 2010 at 01:58 PM

problem with inner join

348 Views

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