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.