select join and for all entries

[Former Member]

how i can use

select sum(XX)

from join tables with the statment for all entries...

[Former Member]

Hi:

check it out. Hope it will help.

select mvke~mvgr4   mseg~grund  mkpf~budat mseg~bwart mseg~erfme sum( mseg~erfmg ) as erfmg 
    into corresponding fields of table it_mseg
    from mkpf
    inner join mseg on ( mkpf~mblnr = mseg~mblnr and mkpf~mjahr = mseg~mjahr )
    inner join mara on ( mseg~matnr = mara~matnr )
    inner join mvke on ( mara~matnr = mvke~matnr and mvke~vkorg = '1000' and mvke~vtweg = '20' )
    where mkpf~budat in mydate
    and   mvke~mvgr4 = botcp
    and   mara~matkl in ('001','002','003','004','005','006','007','008','009','010','012','013')
    and   mseg~bwart in ('921','922')
    and   mseg~grund in ('0013','0006','0003','0004','0007','0005')
    group by mvke~mvgr4  mseg~grund mkpf~budat mseg~bwart  mseg~erfme.

[Former Member]

Hi,

[Aggregate Function using For All Entries|]

[Aggregate Function In Select using Inner Join|]

[faisal_altaf2]

Hi, Sikken

Have a look at the following Thread it will halp you while using "for all entries in"

[Inner join with for-all entries |]

Kind Regards,

Faisal