Hello all, I want to combine two internal tables, which don’t have a key. I would have used another JOIN but there are conditions that use the same field. Any ideas would be greatly appreciated. Also, the parts which have a ‘*’ don’t work somehow. SELECT vbak~bstnk, vbfa~vbelv, vbap~posnr, vbfa~vbelnFROM vbfa AS vbfaINNER JOIN vbak AS vbakON vbfa~vbelv = vbak~vbelnINNER JOIN vbap AS vbapON vbak~vbeln = vbap~vbelnINNER JOIN likp AS likpON likp~vbeln = vbfa~vbelnINNER JOIN vbkd AS vbkdON vbfa~vbelv = vbkd~vbelnINNER JOIN vbuk AS vbukON vbuk~vbeln = vbfa~vbelvWHERE vbfa~vbtyp_n = ‘J’ AND* vbkd~podkz = ‘X’ AND* vbuk~wbstk = ‘C’ AND vbak~vkorg IN @s_vkorg AND vbak~vtweg IN @s_vtweg AND vbap~vstel IN @s_vstel AND vbak~kunnr IN @s_kunde AND vbak~bstnk IN @s_bstnnr AND vbak~auart IN @s_auart AND vbap~pstyv IN @s_pos AND vbak~vbeln IN @s_vbeln AND vbak~erdat IN @s_audat AND likp~vbeln IN @s_liefnr AND likp~erdat IN @s_lidatINTO TABLE @DATA(it_bel). SELECT vbfa~vbelv, vbfa~vbeln FROM vbrk AS vbrk INNER JOIN vbfa AS vbfa ON vbrk~vbeln = vbfa~vbeln INNER JOIN likp AS likp ON likp~vbeln = vbfa~vbelv WHERE vbfa~vbtyp_n = ‘U’ AND likp~vbeln IN @s_liefnr AND likp~erdat IN @s_lidatINTO TABLE @DATA(it_pro).