hi experts , can u pls help me out this query to break this in to three diffrent select stamtements . but i need to get the same o/p. pls look in to join ( how to break left outer join in the folloeing situation)
SELECT MKPF~MBLNR
MKPF~BUDAT
MKPF~XBLNR
MKPF~XABLN
MSEG~BWART
MSEG~MATNR
MSEG~WERKS
MSEG~EBELN
MSEG~EBELP
EKKO~LIFRE
EKKO~RESWK
INTO CORRESPONDING FIELDS OF TABLE T_TEMP_MATDOC
FROM MKPF JOIN MSEG
ON MKPFMBLNR EQ MSEGMBLNR
AND MKPFMJAHR EQ MSEGMJAHR
LEFT OUTER JOIN EKKO
ON MSEGEBELN EQ EKKOEBELN
WHERE MKPF~BUDAT IN S_BUDAT
AND MSEG~WERKS IN S_WERKS
AND MSEG~BWART IN R_BWART.
poits is reworded.