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

Total in smartforms

Former Member — Wed, 25 Jun 2008 06:15:23 GMT

Hi,

Iam working in smartforms. How can i get subtotals for each salesorder and below format in smartforms.could you please explain use of calculation tab in table.

for example

salesorderno itemno materialno nerprice

4969 000010 P-109 5.500,00

5.500,00

4970 000010 M-01 1.630,00

000020 M-02 4.000,00 5.630,00

Regaards,

Suresh.

Edited by: suresh m on Jun 25, 2008 8:15 AM

Edited by: suresh m on Jun 25, 2008 8:16 AM

Re: Total in smartforms

Former Member — Wed, 25 Jun 2008 06:17:08 GMT

In footer you can create program lines and write some code here for sub totals.

Amit.

Re: Total in smartforms

Former Member — Wed, 25 Jun 2008 06:19:41 GMT

Hi Suresh,

In Loop you can put the Command line and calculate the subtototal. and Print it in the text.

&**********Reward Point if helpful*************&

Re: Total in smartforms

Former Member — Wed, 25 Jun 2008 06:23:14 GMT

How can i get the below format.

salesorderno itemno materialno nerprice

4969 000010 P-109 5.500,00

5.500,00

4970 000010 M-01 1.630,00

000020 M-02 4.000,00

5.630,00

Regards,

Suresh.

Re: Total in smartforms

Former Member — Wed, 25 Jun 2008 06:27:14 GMT

Hi ,

In smart form you can use control break functionality.

Use " event on sort End" to get sub totals.

Check the following link with screen shots to get the above functionality.

http://saptechnical.com/Tutorials/Smartforms/ControlBreak/demo.htm

Regards,

Jaya Vani.

Re: Total in smartforms

Former Member — Wed, 25 Jun 2008 06:27:25 GMT

in the loop, use the at end of matnr....endat. statement and then print the output.

hope this will help you.