Inner Join

Former Member — Thu, 29 Jan 2009 05:20:13 GMT

Hi,

Can i write my select query like below.In this query ,i have joined ekko,ekpo and eket with ebeln but for lfa1 table i have used lifnr,is it the correct way or can i write in some othe way also?

select a_{ebeln b}ebelp a~ekorg

d_{name1 d}lifnr a~ekgrp

b_{MATNR b}idnlf b~txz01

b_{labnr b}menge b~meins

c_{eindt c}slfdt c~bedat

into corresponding fields of table gitab

from ( ( ( ekko as a inner join ekpo as b

on a_{ebeln = b}ebeln ) inner join eket as c

on b_{ebeln = c}ebeln ) inner join lfa1 as d

on a_{lifnr = d}lifnr )

where b~elikz <> 'X'

and b~loekz <> 'X'

and a~ekorg in s_ekorg

and a~ekgrp in s_ekgrp

and d~lifnr in s_lifnr

and b~werks in s_werks

and b~matnr in s_matnr

and c~eindt in s_eindt

and c~slfdt in s_slfdt

and c~bedat in s_bedat.

Re: Inner Join

Former Member — Thu, 29 Jan 2009 05:23:30 GMT

Hi,

Check this below link

http://www.sap-img.com/abap/inner-joins.htm

Hope this helps.

Regards,

Anki Reddy

topic Re: Inner Join in Application Development and Automation Discussions

Inner Join

Re: Inner Join