Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Inner join ( 3 tables)

Former Member
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

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

Former Member
0 Kudos

inner join ekko

on ekkoebeln = ekpoebeln

inner join t024

on t024ekgrp = ekkoekgrp

Former Member
0 Kudos

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

Former Member
0 Kudos

SELECT

msegbukrs msegebeln mseg~ebelp

msegkostl mseglifnr mseg~matnr

msegmblnr msegmeins mseg~menge

msegmjahr msegshkzg mseg~waers

msegwerks mkpfbudat mkpf~vgart

ekpobrtwr ekpoknttp ekpo~kzwi6

ekpoloekz ekpomatkl

ekpo~meins as meins1

ekpo~menge as menge1

ekpo~netwr

ekpopstyp ekkobsart ekko~ekgrp

ekko~waers as waers1

INTO TABLE t_mtab

FROM mseg

INNER JOIN mkpf ON mkpfmblnr = msegmblnr

and mkpfmjahr = msegmjahr

INNER JOIN ekpo ON ekpoebeln = msegebeln

and ekpoebelp = msegebelp

INNER JOIN ekko ON ekkoebeln = ekpoebeln

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.

Former Member
0 Kudos

hi,

select aebeln aebelp azconf anetwr c~eknam

into table itab

from ( ( ekpo as b inner join ekko as a

on bebeln = aebeln ) inner join t024 as c

on a~ekgrp = c`EKGRP ) where

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

Reward useful answers,

Regards,

Shrita.