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.