topic Re: Running Sum using SAP Program in Application Development and Automation Discussions

Running Sum using SAP Program

Former Member — Wed, 25 Apr 2012 23:52:17 GMT

Hello ,

I am trying to create a column which can return Running Sum of Quantity.

Wondering whether it is possible and how using ABAP?, I know i t can be done in BOBJ/Crystal but the requirement is to achieve in BW.

I have Input from a BW DSO1/Table1: Material, PO, Posting Date, Order Qty.

Output into an other BW DSO2/Table2: Material, PO, Posting Date, Order Qty, MaterialRunningSum.

Example Data:

Material	PO	Posting Date	Order Qty	Material Running Sum
123	1000	12/1	10	10
123	1001	12/2	5	15
123	1001	12/3	15	30
123	1002	12/3	-5	25
123	1002	12/4	10	35
456	1003	12/1	5	5
456	1004	12/1	15	20
456	1004	12/2	5	25

Your help would be appreciated!

Thanks in advance,

Moderator message : Not enough re-search before posting, discussion locked.

Message was edited by: Vinod Kumar

Re: Running Sum using SAP Program

Former Member — Thu, 26 Apr 2012 01:35:03 GMT

Hi DC,

Yes, its possible in ABAP. Please use the below logic to calculate the running sum of quantity.

LOOP AT ITAB.

lv_sum = lv_sum + itab-qty.

itab-sum = lv_sum.

MODIFY itab.
AT END OF matnr.
CLEAR lv_sum.
ENDAT.

ENDLOOP.

I tried this example, its calculating the running sum correctly. Check it..

Re: Running Sum using SAP Program

former_member585060 — Thu, 26 Apr 2012 01:53:49 GMT

Hi,

Instead of additional loop, you can do it while filling the final output table it self. but it depends on which table data you are using and filling the output table, if that table has MATNR as first column then you can use the same logic as Lakshmi proposed for calculation but MODIFY statement is not required, just clear the LV_SUM in AT END OF matnr.

If the MATNR field is not the first field, you can use the logic suggested by Lakshmi, below is similar to that one without MODIFY statement.

FIELD-SYMBOLS : <fs_final> TYPE ty_final.

LOOP AT i_final ASSIGNING <fs_final>.

v_sum = v_sum + <fs_final>-qty.

<fs_final>-sum = v_sum.

AT END OF matnr.

CLEAR : v_sum.

ENDAT.

ENDLOOP.

Thanks & Regards

Bala Krishna