regarding inner joins and calculations

[Former Member]

Dear Experts,

I have a simple problem but i am a little confused. The problem is that i have 3 tables one is ekpo, ekes,ekbe

from ekpo i have to take matnr value and with respect to the matnr value i have to do this

Field discription is opening stock to get this value i have to do this

FOR ANY material sum of MENGE of EKES minus sum of MENGE of EKBE where VGABE=1

Where EKES. EBELN = EKBE. EBELN And EBELP

For input date range for EKBE BUDAT, EKES EINDT

could you help me out with this problem

[santosh_kumarm]

Hi ,

Don't use inner join for 3 tables. Instead extract the data from 2 tables EKES and EKBE and store in a internal table. for EKPO store in another internal table. now you write the logic to calculate the desired result. By doing this way it will not cause any problems on performance.

[Former Member]

could you help me with the code for the inner join of those tables and also i want to know how can that calculation be done in the report.