topic Re: Totalling with out NESTED LOOPS?? in Application Development and Automation Discussions

Totalling with out NESTED LOOPS??

Former Member — Mon, 12 May 2008 20:06:11 GMT

Hi Experts,

I hv data in t_vbak and t_vbap itabs.

I need to SUM the QUANTITY i.e. VBAP-KWMENG for each VBELN in VBAK i.e each Doc.

So, normally, I use,

loop at t_vbak.

loop at t_vbap where vbeln = t_vbak-vbeln

tot_qty = tot_qty + vbap-kwmeng

endloop.

modify ......

endloop.

But, I do not wanna to use NESTED LOOPS, so, pls. let me any other solution?

thanq

Re: Totalling with out NESTED LOOPS??

Sm1tje — Mon, 12 May 2008 20:11:40 GMT

Forget it, wasn't look to well a coding....vbaK and vbaP

Sort the table by VBELN and next use SUM (standard ABAP statement) within loop at vbap.

Edited by: Micky Oestreich on May 12, 2008 10:12 PM

Edited by: Micky Oestreich on May 12, 2008 10:14 PM

Re: Totalling with out NESTED LOOPS??

Former Member — Mon, 12 May 2008 20:13:43 GMT

make vbeln in another table of the same structure of t_vbap a key and then do this


loop at t_vbap.
read table t_vbak with key vbeln = vbap-vbenln.
if sy-subrc eq 0.
collect vbap into other_vbap.
endif.
endloop.

You will have the sum in kwmeng in the other table

Re: Totalling with out NESTED LOOPS??

naimesh_patel — Mon, 12 May 2008 20:21:31 GMT

Use COLLECT statement.


* Declare IT_SUM with VBELN and QTY

LOOP AT IT_VBAP.
IT_SUM-VBELN = IT_VBAP-VBELN.
IT_SUM-QTY = IT_VBAP-MENGE.
COLLECT IT_SUM.
CLEAR   IT_SUM.
ENDLOOP.

Regards,

Naimesh Patel