Skip to Content
0
Former Member
Apr 27, 2009 at 10:07 AM

Join conditions

109 Views

Hi all,

I need to JOIN few tables. I will post you my code example and I need any info on corrections of this JOIN conditions because I get too many records in output. Also columns of data that is supposed to be fetched from VBAK table are empty.Here it is:

SELECT *

FROM vbak AS ak INNER JOIN vbfa AS fa

ON akvbeln = favbelv

INNER JOIN vbrk AS rk

ON favbeln = rkvbeln

INNER JOIN kna1 AS a1

ON rkkunrg = a1kunnr

INTO CORRESPONDING FIELDS OF TABLE it_report

WHERE fa~vbeln IN s_vbeln

AND rk~fkart IN s_fkart

AND rk~fkdat IN s_fkdat

AND rk~vkorg EQ 'HTSD'

AND rk~vtweg IN s_vtweg

AND rk~kunrg IN s_kunrg

AND rk~kunag IN s_kunag

AND a1~stcd1 IN s_stcd1

AND rk~erdat IN s_erdat

AND ak~vkbur IN s_vkbur

AND ak~augru IN s_augru.