Skip to Content
0
Former Member
May 13, 2008 at 08:49 AM

joins

20 Views

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.