Deseo unir 2 tablas internas en otra tabla, agrego codigo de consultas:
SELECT kunnr vkorg vtweg
FROM knvv
INTO (it_clien_empl-kunnr , it_clien_empl-vkorg_knvv, it_clien_empl-vtweg)
WHERE konda = '06' OR konda = '16'
AND bzirk = '9000'.
APPEND it_clien_empl.
ENDSELECT.
SELECT a~vkorg a~matnr
a~knumh b~kbetr
b~kmein
INTO (it_prod_pm-vkorg_a004, it_prod_pm-matnr,
it_prod_pm-knumh, it_prod_pm-kbetr,
it_prod_pm-kmein)
FROM a004 AS a
INNER JOIN
konp AS b
ON
a~knumh = b~knumh
WHERE
a~kschl = 'ZPVM' AND a~datbi GE sy-datum AND
a~datab LE sy-datum.
ENDSELECT.
Ambas tablas tienen como campo de enlace VKORG, y deseo unir las 2 tablas en otra tabla, como puedo hacer dicha union?
SELECT a~kunnr a~vtweg
a~vkorg
b~matnr b~knumh
c~kbetr c~kmein
c~konwa
into (it_carg_prec_empl-kunnr , it_carg_prec_empl-vtweg,
it_carg_prec_empl-vkorg, it_carg_prec_empl-matnr,
it_carg_prec_empl-knumh, it_carg_prec_empl-kbetr,
it_carg_prec_empl-kmein, it_carg_prec_empl-konwa)
from
knvv as a
INNER JOIN
a004 as b
on a~vkorg = b~vkorg
INNER JOIN
konp as c
on b~knumh = c~knumh
WHERE
a~konda = '06' OR a~konda = '16'
AND a~bzirk = '9000'
and b~kschl = 'ZPVM' AND b~datbi GE sy-datum AND
b~datab LE sy-datum.
APPEND it_carg_prec_empl.
ENDSELECT.
queria saber si existia otra manera, no con un doble inner join. Gracias