Skip to Content
0
Feb 25, 2009 at 07:49 AM

problem in joins

127 Views

Hi folks,

in my following code the idnlf data is not fetching.other than idnlf field all datas are fetching..please help

me on this as soon as possible..

if iam using for all entries it is showing error..

can u please provide me a sample coding in this case.

tables: mara,marc,eina.

at selection-screen on oldmatno.

select single bismt from mara into w_bismt

where bismt = oldmatno.

start-of-selection.

if oldmatno is not initial.

select mara~mtart

mara~mfrpn

mara~mfrnr

mara~brand_id

marc~nfmat

marc~atpkz

makt~maktx

into table itab

from mara inner join marc

on maramatnr = marcmatnr

inner join makt

on maramatnr = maktmatnr

where bismt in oldmatno

and makt~spras = 'EN'.

select idnlf from eina into table itab1

where matnr = mara-matnr.

Thanks,

Neelu.