topic subtotal in smartforms in Application Development and Automation Discussions

subtotal in smartforms

Former Member — Wed, 23 Aug 2006 17:39:29 GMT

hi friend,

how to get subtotal in smartforms.

regards,

kathir.

Re: subtotal in smartforms

Former Member — Wed, 23 Aug 2006 18:12:06 GMT

hi krishna!

the only best way is to read sap help if u have sap help with you.

sap library~~>my sap technology comp~~>sap web application server~~>basis services~~>sap smart forms~~>using sap smartforms~~>printing data in a table~~>printing tables~~>calculations~~>examples~~>calculating subtotals

u can find here grand totals,subtotals,numbering table items.

telling how to do subtotals is not possible by simply typing here.so i gave u this navigation in sap help.

award points if helpful

Re: subtotal in smartforms

Former Member — Wed, 23 Aug 2006 19:02:51 GMT

In table node, we have calculatio tab.

For example: you are looping at interal table itab, one of the field in the table is NETWR, you need print the subtotal of NETWR on each page.

Declare a global varaiable v_subtotal type netwr.

Create a table node, under the data tab loop at the itab intenal table.

Under the same table node you have the calculation tab.

Mention the following data:

Operation : Total

Field value: itab-netwr

Target field name:v_subtotal

Time:After loop.

You will have subtotal value in the field v_subtotal.

Re: subtotal in smartforms

Former Member — Thu, 24 Aug 2006 02:17:54 GMT

Hi,

What you should do is add a new edit mask after the items loop, and have the totals prepared in advance in the print program of your smartform. Pass the totals to the form though another structure.

The other thing you could do, is add abap code in the items loop, summing data as you go in a separate global field defined in the smartform, and display the result in a separate structure after the loop.

Regards,

Shalini