Skip to Content
0
Former Member
Apr 14, 2010 at 02:31 PM

sum of menge per item

259 Views

Hi everyone,

want the summation at the item level with out using the AT end of controls statements inside my internal table.

I have writen code for the same below. Could any one modify my code to get the summation for each item of an SO.

Example:-

(VBELN) (POSNR) ZDMENGE

100 10 100

100 10 400

100 20 600

100 30 50

100 30 150

200 10 400

200 20 300

200 20 200

Result must be as below(summation per item):

VBELN POSNR ZDMENGE

100 10 500

100 20 600

100 30 200

200 10 400

200 20 500

My current code:-

TYPES : BEGIN OF wa1_zmmt0006 ,

vbeln TYPE zmmt0006-vbeln,

posnr TYPE zmmt0006-posnr ,

zdmenge TYPE zmmt0006-menge ,

END OF wa1_zmmt0006 .

DATA : wa2_zmmt0006 TYPE wa1_zmmt0006 ,

wa_zmmt0006 TYPE wa1_zmmt0006 ,

it2_zmmt0006 TYPE wa1_zmmt0006 ,

it_zmmt0006 TYPE wa1_zmmt0006 .

SELECT vbeln posnr menge

FROM zmmt0006

INTO TABLE it2_zmmt0006

FOR ALL ENTRIES IN it_c_t_data

WHERE vbeln = it_c_t_data-vbeln

AND posnr = it_c_t_data-posnr

AND status = u2018 u2018 .

LOOP AT it2_zmmt0006 INTO wa2_ zmmt0006 .

wa_zmmt0006-posnr = wa2_zmmt0006-posnr .

wa_zmmt0006-zdmenge = wa2_zmmt0006-zdmenge .

wa_zmmt0006-zstatus = wa2_zmmt0006-zstatus .

Collect wa_zmmt0006 into it_zmmt0006 .

Endloop .

SORT it_zvitr_item_im BY vbeln ASCENDING posnr ASCENDING menge DESCENDING .

Regards,

Sonam

Edited by: sonamrata on Apr 19, 2010 7:55 PM