Join

[Former Member]

Hi, expert.Need an example of left outer join wiht more than 9 tables  (lfa1 , knvv ,t151t , bsis ,kna1 , lfb1 , bkpf , t001 , bsid )

[Former Member]

BSIS,BKPF,BSID,BSID - are your driving tables related to FI documents

Rest of the tables are giving the additional information of customer and vendor details!

- the report seems to be out going and incoming payment details!

[Former Member]

I'm try Thank you

[former_member187748]

Hi Semih,

please folow what Nabheet has sujjested, you can make subgroup of your tables in a set of 4 or 5.

Then your task will become easy, here i am showing you how to use inner join for 4 tables.

See , if you wants to do left outer join, then you have to change the declaration of left uoter join,

and also left outer join will be used differently, so you have to change this code, this is to just show you the use of join

select   essr~lblni

            essr~budat

            essr~xblnr

            essr~ebeln

            essr~ebelp

            essr~packno

            ekko~bedat

            ekko~kdatb

            ekko~kdate

            ekko~knumv

            ekpo~ebelp

            ekpo~werks

            ekpo~lgort

            ekpo~mwskz

            ekko~lifnr

            essr~txz01

            essr~lzvon

            essr~lzbis

            essr~lwert

            essr~netwr

            ekko~zterm

            tvzbt~vtext

            ekko~bukrs

            t001~butxt

            t001~adrnr

            into corresponding fields of table it_head

            from ( ( ( ( ekko

            inner join essr  on ekko~ebeln = essr~ebeln )

            inner join ekpo  on ekko~ebeln = ekpo~ebeln )

            inner join tvzbt on ekko~zterm = tvzbt~zterm )

            inner join t001  on ekko~bukrs = t001~bukrs )

            where lblni eq p_lblni

            and   tvzbt~spras = 'E'

            and   t001~spras  = 'E'

            and   ekko~loekz  = ''

            and   ekpo~ebelp  = p_ebelp

            and   ekpo~loekz  = ''

            and   essr~loekz  = ''.