06-29-2007 8:06 AM
Hi,
Can any body drop me a piece of code for INNER JOIN of three tables (VBEP, VBAP, MARA)
Plz traet this urgent..
Thanks
Sangram
06-29-2007 8:14 AM
Hi,
select a~vbeln
a~posnr
a~matnr
b~etenr
b~ettyp
c~mtart
from vbap as a
jOIN vbep as b
on avbeln eq bvbeln
join mara as c
on amatnr eq cmatnr
into itab.
reward points if useful,
Aleem.
06-29-2007 8:11 AM
Hi sangram,
Tables : mara.
Select-options : s_matnr for mara-matnr.
select a~matnr
b~maktx
c~labst
into table itab
from mara as a
inner join
makt as b
on bmatnr = amatnr
innerjoin
mard as c
on cmatnr = amatnr
where a~matnr = s_matnr
and b~spras = sy-langu.
Regards..
Balaji ( Reward points if this useful...)
06-29-2007 8:14 AM
Hi,
select a~vbeln
a~posnr
a~matnr
b~etenr
b~ettyp
c~mtart
from vbap as a
jOIN vbep as b
on avbeln eq bvbeln
join mara as c
on amatnr eq cmatnr
into itab.
reward points if useful,
Aleem.