topic Row wise total using ALV OOPS in Application Development and Automation Discussions

Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 09:47:05 GMT

Hi experts,

My requirement is to display rowwise sum in ALV .We have option to do column wise sum by setting do_sum field in fieldcatalog. Do we have anything to do rowwise sum?

Re: Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 09:49:29 GMT

Hi,

Are all fields currency or quantity fields?

Re: Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 09:51:06 GMT

Hi Satya,

Yes.They all are currency and quantity fields.

Re: Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 10:07:09 GMT

Hi rajan,

Try This code.

Take another field (TOATL) <type your currencyor quantity fields> in your final internal table.

In data filling loop.

loop at <itab> into <wa>.

w_final-f1 = wa-f1.

w_final-f2 = wa-f2.

w_final-f3 = wa-f3.

w_final-f4 = wa-f4.

w_final-f5 = wa-f5.

w_final-total = w_final-f1 + w_final-f2 + w_final-f3 + w_final-f4 + w_final-f5.

endloop.

next display your fields.

Re: Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 10:57:02 GMT

hi ,

1.u can use field symbol for row wise total .

2.First collect all data in internal table than use field symbol.

syntax:

FIELD-SYMBOLS: <work area> TYPE table structure.

LOOP AT internal table ASSIGNING <work area>.

ENDLOOP.

Re: Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 11:10:39 GMT

You have to do it manually.

Create a new column to display total.
Loop at your internal table. Calculate the totals and store in the new column.
Modify the field catalog and add the total column.

Regards,

Ashish

Re: Row wise total using ALV OOPS

former_member194739 — Wed, 07 May 2014 11:14:23 GMT

Dear Ranjan,

In ALV OOP no particular option(syntax or statement) for row wise total.

Use same as procedural oriented code as.

loop at it_final into wa_final.

wa_final-f4 = wa_final-f1 + wa_final-f2 + wa_final-f3.

modify it_final from wa_final index sy-tabix transporing f4.

endloop.

Regards,

Abbas.

Re: Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 11:25:34 GMT

Process the data into internal table with one additional filed.

Re: Row wise total using ALV OOPS

Former Member — Wed, 07 May 2014 11:35:49 GMT

U can use alv field catlog user command . put new button on PF -STATUS TOOL BAR .

When User Press Button , Append Field Catlog Stuture dymically and Put Field Symbol.

Regards ,

Anil Singh

Re: Row wise total using ALV OOPS

claudia_bolch — Wed, 07 May 2014 12:22:13 GMT

Hi,

as far as I know, you can't set something like do_sum for calculating rowwise sums.

You can add another column for the sum to your output structure and create the sum manually:

FIELD-SYMBOLS <s_data> LIKE LINE OF gt_data.

LOOP AT gt_data ASSIGNING <s_data>.

<s_data>-total = <s_data>-comp1 + <s_data>-comp2 + <s_data>-comp3.

ENDLOOP.

If you use a field-symbol here, it will be more performant, if your internal table has many entries.

If you already do a loop at your internal table somewhere before in the programm or you create your internal table row-by-row by appending them, better calculate the sum there to improve performance.

Regards,

Claudia

Re: Row wise total using ALV OOPS

VijayaKrishnaG — Wed, 07 May 2014 15:20:25 GMT

Hi Ranjan,

As of my knowledge, there is no direct method to calculate Row wise totals, I believe.

If your requirement is as follow,

Col1 Col2 Col3 Col4

2 5 6 13

4 5 3 12 (Col1 + Col2 + Col3)

Then before displaying the output just loop the internal table and calculate the Total as above and place that value in last column and modify internal table.

If user doesn't want it by default and he wants to see that whenever he required, just make one default layout without total Column.

If my understanding was wrong, hope you can elaborate your query.

Thanks & Regards,

Vijay

Re: Row wise total using ALV OOPS

Former Member — Fri, 09 May 2014 04:14:14 GMT

Thank you all for your reply.I have resolved it now.

Re: Row wise total using ALV OOPS

Former Member — Fri, 09 May 2014 04:48:12 GMT

HI,

Plz provide solovtion which u did...

Re: Row wise total using ALV OOPS

Former Member — Fri, 09 May 2014 05:56:46 GMT

Hi,

please set the thread's status to anwered or assumed answered..While status is not answered other SCN members join the thread and want to try to help you solve your open issue.

Regards,

Klaus