topic Re: Subtotal in smartforms in Application Development and Automation Discussions

Subtotal in smartforms

Former Member — Thu, 23 Nov 2006 11:28:37 GMT

Hi,

I am facing problem in calculating subtoal of all the line items on separate pages.My Requirement is i have to calculate subtotal of line item on the first page at the first page end after that on the second page i need subtotal of all the amount(NETWR) present on all the line items on the second page subsequently.No of line items are not fixed on all the pages.It may be 4 on 1st page and 5 on second page.

Regards,

Mukesh Kumar

Re: Subtotal in smartforms

Former Member — Thu, 23 Nov 2006 11:30:29 GMT

you can use the sort option and use the SORT BEGIN and SORT END events in the table.After the event node is created,under the node add a code section to calculate the subtotals and output it.

Re: Subtotal in smartforms

Former Member — Thu, 23 Nov 2006 11:32:07 GMT

hi,

you create a program line in the table and calculate the sum by using

<b>var = var + wa-netwr</b>.then write the var in the window below the main window.

after writing create another program line and clear the variable.

Hope this will do.

Re: Subtotal in smartforms

Former Member — Thu, 23 Nov 2006 11:33:39 GMT

try to use condn....

sfsy-page ne sfsy-formpages

in coding node just sum on the basis of cond.

ex---

loop at itab.
w_sum = w_sum  + itab-netwr.
endloop.
if sfsy-page ne sfsy-formpages.
clear: w_sum.
endif.

where w_sum is sum of line item...

kishan negi

Re: Subtotal in smartforms

Former Member — Thu, 23 Nov 2006 11:40:29 GMT

hi ,

try this code

<b>In scripts and smartforms how to calculate totals and subtotals?</b>

Say if you have to add the unit price (KOMVD-KBERT) then in the main window whereever tat value is picked write this routine

/: DEFINE &TOT_PRICE&

/: PERFORM F_GET_PRICE IN PROGRAM <subroutine prog name> /:USING &KOMVD-KBERT& /:CHANGING &TOT_PRICE& /:ENDPERFORM

Then write the variable where ever you want it to be printed (mostly it will be in footer window)

Then create subroutine pool program and you have to write the code.

FORM F_GET_PRICE tables int_cond structure itcsy

outt_cond structure itcsy. data : value type kbert.

statics value1 type kbert.

Read int_cond table index 1.

value = int_cond-value.

value1 = value1 + value.

Read outt_cond table index 1.

outt_cond-value = value1.

Modify outt_cond index 1.

ENDFORM.

if this helps u ,reward the points,

shan