topic Re: Inner Join in Application Development and Automation Discussions

Inner Join

Former Member — Fri, 29 Jun 2007 07:06:46 GMT

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

Former Member — Fri, 29 Jun 2007 07:11:05 GMT

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 b_{matnr = a}matnr

innerjoin

mard as c

on c_{matnr = a}matnr

where a~matnr = s_matnr

and b~spras = sy-langu.

Regards..

Balaji ( Reward points if this useful...)

Former Member — Fri, 29 Jun 2007 07:14:08 GMT

Hi,

select a~vbeln

a~posnr

a~matnr

b~etenr

b~ettyp

c~mtart

from vbap as a

jOIN vbep as b

on a_{vbeln eq b}vbeln

join mara as c

on a_{matnr eq c}matnr

into itab.

reward points if useful,

Aleem.