topic Re: Inner join ( 3 tables) in Application Development and Automation Discussions

Inner join ( 3 tables)

Former Member — Thu, 28 Sep 2006 04:41:03 GMT

Hi Frendz,

i have three tables EKKO, EKPO and T024.

EKKO - ebeln ebelp zconf ekgrp netwr

EKPO - ebelp

T024 - eknam

I want to link these three tables using inner join, can u give me the syntax ?

Points for sure,

thanks in advance

Srini Kumar

Re: Inner join ( 3 tables)

Former Member — Thu, 28 Sep 2006 04:43:33 GMT

SK ,

u can link/ join EKKO+EKPO but not T024 @ the time of selection.

select     ekko~ebeln ekko~bukrs ekko~lifnr ekko~bedat ekko~knumv
             ekko~kalsm ekpo~ebelp ekpo~matnr ekpo~meins ekpo~mwskz
             ekpo~txjcd ekbe~vgabe ekbe~gjahr ekbe~belnr ekbe~buzei
             ekbe~menge ekbe~lfgja ekbe~lfbnr ekbe~shkzg ekbe~lfpos
             ekbe~budat ekbe~dmbtr ekbe~xblnr ekbe~bwart
     from ekpo
     inner join ekko
        on ekko~ebeln = ekpo~ebeln

regards

Prabhu

Re: Inner join ( 3 tables)

Former Member — Thu, 28 Sep 2006 04:48:57 GMT

inner join ekko

on ekko_{ebeln = ekpo}ebeln

inner join t024

on t024_{ekgrp = ekko}ekgrp

Re: Inner join ( 3 tables)

Former Member — Thu, 28 Sep 2006 04:49:03 GMT

Hi,

You can use the join on the ekko and ekpo. tHEN select from t024 based on the EKGRP FOR ALL ENTRIES IN

This will help you.

Please reward if it helps

Regards,

Brijesh Patel

Re: Inner join ( 3 tables)

Former Member — Thu, 28 Sep 2006 04:49:58 GMT

SELECT

mseg_{bukrs mseg}ebeln mseg~ebelp

mseg_{kostl mseg}lifnr mseg~matnr

mseg_{mblnr mseg}meins mseg~menge

mseg_{mjahr mseg}shkzg mseg~waers

mseg_{werks mkpf}budat mkpf~vgart

ekpo_{brtwr ekpo}knttp ekpo~kzwi6

ekpo_{loekz ekpo}matkl

ekpo~meins as meins1

ekpo~menge as menge1

ekpo~netwr

ekpo_{pstyp ekko}bsart ekko~ekgrp

ekko~waers as waers1

INTO TABLE t_mtab

FROM mseg

INNER JOIN mkpf ON mkpf_{mblnr = mseg}mblnr

and mkpf_{mjahr = mseg}mjahr

INNER JOIN ekpo ON ekpo_{ebeln = mseg}ebeln

and ekpo_{ebelp = mseg}ebelp

INNER JOIN ekko ON ekko_{ebeln = ekpo}ebeln

WHERE

MSEG~BUKRS IN S_BUKRS

AND MSEG~WERKS IN S_WERKS

AND MKPF~BUDAT IN S_BUDAT

AND MKPF~VGART IN S_VGART

AND EKPO~LOEKZ IN S_LOEKZ

AND EKPO~MATKL IN S_MATKL

AND EKKO~BSART IN S_BSART

AND EKKO~EKGRP IN S_EKGRP.

if sy-subrc <> 0.

leave list-processing.

else.

*For Purchasing Group Names

select ekgrp

eknam

from t024

into table t_pgroup

for all entries in t_mtab

where ekgrp = t_mtab-ekgrp.

Re: Inner join ( 3 tables)

Former Member — Thu, 28 Sep 2006 04:51:39 GMT

hi,

select a_{ebeln a}ebelp a_{zconf a}netwr c~eknam

into table itab

from ( ( ekpo as b inner join ekko as a

on b_{ebeln = a}ebeln ) inner join t024 as c

on a~ekgrp = c`EKGRP ) where

b~ebeln = (input from the selection screen).

Reward useful answers,

Regards,

Shrita.