Skip to Content
1
Former Member
Aug 04, 2007 at 08:37 AM

joining tables

176 Views

hi experts,

I am making Purchase Requisition report. for that i have to use EBAN, EKPO, EKKO, LIPS, and LIKP tables. User enters Purchase requisition no. on that condition it fetches data. I have joined EBAN and EKPO and the data fetches correctly. but how can I join other tables in the same select statement.

Required field from lips and likp is----


Delivery No. (VBELN)

Delivery Date. ( when delivery created) (ERDAT)

Delivery material. (MATNR)

Delivery Qty. (LFIMG)

PGI.

***************************************************

my select statement is -


******************************************************

SELECT EBANBADAT EBANLFDAT EBANBANFN EBANMATNR EBANMENGE EKPOEBELN EKPOEBELP EKPOSTATU EKPOAEDAT EKPOMATNR EKPO~MENGE

EKPOMEINS EKPONETPR EKPOPEINH EKPOWERKS

INTO CORRESPONDING FIELDS OF TABLE IT_EKKO

FROM EBAN LEFT OUTER JOIN EKPO

ON EBANBANFN = EKPOBANFN

AND EBANBNFPO = EKPOBNFPO

WHERE EBAN~BANFN IN S_BANFN.

***************************************************************************************

THANKS.

KHAN.