Problem with aggregate function

[Former Member]

HI Guys,

I need your helpw with this requirement...

I need to Select dmbtr and menge from mseg where bwart is 261 and 262...

Thsn, I need to sum up menge where bwart is 261 and sum up menge where bwart is 262...

the same goes with dmbtr,,, I have to sum up dmbtr where bwart is 261 and sum up dmbtr where bwart is 262...

The trick is, after summing up the menge and dmbtr for 261 and 262 bwart...

I have to subtract teh summation of 262 from 261 for menge same goes for dmbtr...

To simplify:

Summation(MENGE for 261) - Summation(MENGE for 262)

and...

Summation(DMBTR for 261) - Summation(DMBTR for 262)

Thanks a lot!!

[Sm1tje]

Do a select on the table mseg like you already do in: Select dmbtr and menge from mseg where bwart is 261 and 262...

Put these fields in an internal table

SELECT DMBTR, MENGE FROM MSEG

INTO TABLE itab

WHERE BWART IN (261, 262).

loop over internal table.

if BWART = 261.

lv_menge_261 = lv_menge_261 + itab-menge.

lv_dmbtr_261 = lv_dmbtr_261 + itab-dmbtr.

elseif BWART = 262.

lv_menge_262 = lv_menge_262 + itab-menge.

lv_dmbtr_261 = lv_dmbtr_261 + itab-dmbtr.

endif.

endloop.

lv_menge = lv_menge_261 - lv_menge_262.

lv_dmbtr = lv_dmbtr_261 - lv_dmbtr_262.

Something like this??

endloop.