consulta en abap de Outer join

[raul293]

Quisera hacer una consulta quisiera saber si se puede hacer una consulta que una dos inner join en con un outer join,es decir (A inner join B) outer join (C inner join D), en abap, ( en sql si funciona ), estuve buscando x la red y no encontre solución, bueno dejo el ejemplo.

SELECT *
FROM
(SELECT T1.MBLNR,T1.MJAHR,T3.MENGE,T3.MEINS
FROM
SAPSR3.MKPF@pro60 T1,SAPSR3.MSEG@pro60 T3
WHERE T1.MBLNR = T3.MBLNR ) AS TA1
FULL OUTER JOIN (
SELECT T2.BUKRS,T2.BLART,T2.MONAT,T4.DMBTR,T4.BWKEY,T4.MATNR
FROM
SAPSR3.BKPF@pro60 T2,SAPSR3.BSIM@pro60 T4
WHERE
T2.BELNR = T4.BELNR) AS TA2
ON TA1.MBLNR=TA2.AWKEY
WHERE TA1.MBLNR IS NULL

[SidV]

Hola.

Creo que esto debería haber sido posteado en Programación ABAP, y no en:
> TRABAJO Y FORMACION > RUEGOS Y PREGUNTAS

[Dlanor20777]

Tengo un inner join asi:

select EBAN~BADAT EBAN~BANFN EBAN~BEDNR EBAN~BNFPO EBAN~BSART EBAN~BSTYP EBAN~EKGRP EBAN~FRGKZ EBAN~FRGST EBAN~FRGZU EBAN~MATNR EBAN~STATU
EBAN~LOEKZ EBAN~TXZ01 EBAN~WERKS EKET~BANFN EKET~BNFPO EKET~EBELN EKET~EBELP EKKO~ANGDT EKKO~BSTYP EKKO~EBELN EKKO~LIFNR EKKO~STATU
EKKO~SUBMI EKKO~WAERS EKPO~BRTWR EKPO~EBELN EKPO~EBELP EKPO~KTMNG EKPO~LOEKZ EKPO~MEINS EKPO~MENGE EKPO~NETPR EKPO~STATU
into (EBAN-BADAT , EBAN-BANFN , EBAN-BEDNR , EBAN-BNFPO , EBAN-BSART , EBAN-BSTYP , EBAN-EKGRP , EBAN-FRGKZ , EBAN-FRGST , EBAN-FRGZU
, EBAN-MATNR , EBAN-STATU , EBAN-LOEKZ , EBAN-TXZ01 , EBAN-WERKS , EKET-BANFN , EKET-BNFPO , EKET-EBELN , EKET-EBELP , EKKO-ANGDT
, EKKO-BSTYP , EKKO-EBELN , EKKO-LIFNR , EKKO-STATU , EKKO-SUBMI , EKKO-WAERS , EKPO-BRTWR , EKPO-EBELN , EKPO-EBELP
, EKPO-KTMNG , EKPO-LOEKZ , EKPO-MEINS , EKPO-MENGE , EKPO-NETPR , EKPO-STATU )
from ( EBAN
inner join EKET
on EKET~BANFN = EBAN~BANFN
and EKET~BNFPO = EBAN~BNFPO
inner join EKKO
on EKKO~EBELN = EKET~EBELN
inner join EKPO
on EKPO~EBELP = EKET~EBELP
and EKPO~EBELN = EKKO~EBELN )
where EBAN~BANFN in SP$00001.

Lo que indicas no lo he probado.