topic joining tables in Application Development and Automation Discussions

joining tables

Former Member — Sat, 04 Aug 2007 08:37:01 GMT

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 EBAN_{BADAT EBAN}LFDAT EBAN_{BANFN EBAN}MATNR EBAN_{MENGE EKPO}EBELN EKPO_{EBELP EKPO}STATU EKPO_{AEDAT EKPO}MATNR EKPO~MENGE

EKPO_{MEINS EKPO}NETPR EKPO_{PEINH EKPO}WERKS

INTO CORRESPONDING FIELDS OF TABLE IT_EKKO

FROM EBAN LEFT OUTER JOIN EKPO

ON EBAN_{BANFN = EKPO}BANFN

AND EBAN_{BNFPO = EKPO}BNFPO

WHERE EBAN~BANFN IN S_BANFN.

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

THANKS.

KHAN.

Re: joining tables

Former Member — Sat, 04 Aug 2007 09:52:05 GMT

in ekko and ekpo common is ebeln.

so u can join with it.

where as in likp , lips and ekpo common is netwr

i think it may be useful for u

regards

vidya

Re: joining tables

Former Member — Sat, 04 Aug 2007 14:08:27 GMT

Join EKPO and EKKN tables with EBELN and EBELP and take the VBELN and POSNR fields

which are nothing but sales order number and Sales order item

pass these VBELN and POSNR fields to LIPS-VGBEL and VGPOS and fetch the data from LIPS and LIKP tables

<b>Reward points for useful Answers</b>

Regards

Anji

Re: joining tables

Former Member — Mon, 06 Aug 2007 03:55:37 GMT

Please see this link for joininng the table

<a href="http://">http://www.geocities.com/sapcircle/Relations.pdf</a>

" page no 25 for LIKP & LIPS

.....

reward points if it is usefull .....

Girish

Re: joining tables

suredarreddy_pulimamidi — Sun, 12 Aug 2007 14:28:23 GMT

for better performance don't use joins instead of that use FOR ALL ENTRIES statement.if you use joins limit number of tables to 3 only.

p.surendarreddy