topic Re: regarding total in smartforms in Application Development and Automation Discussions

regarding total in smartforms

Former Member — Wed, 29 Aug 2007 11:21:29 GMT

hi experts,

i have developed a smartforms in which the different materials quantity is coming,now i have to add these quantities material wise,means for first materail it will sumup(total) the quantity then for second material it will sumup(total) the quantity,as i m using table not templates in the smartforms,,,,plz help me cant we do with the help of calculations tab in the table options but how , i m using this tab but it is giving the summation of both the materail together not individually..............if possible kindly send me the steps

null

Re: regarding total in smartforms

former_member188827 — Wed, 29 Aug 2007 11:26:16 GMT

u can create program lines and do calculations...

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 11:26:20 GMT

If you want individual sum then do the coding in your ABAP report (which is calling report of SMARTFORM) and pass both the values to smartform.

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 11:26:52 GMT

Hi,

After Populating the Internal Table,Group the Internal Table Material Wise.Then Calculate the Total of that Particular Material.

Regards,

Padmam.

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 11:32:00 GMT

This is possible in the calculations tab.

In your tab you'll need to fill the columns with,

operand - SUM,

field name - the field holding the quantity

target field name - the working field you need to hold the total

time - after sorting

for field name - the material no fieldname

reset - for sort criteria

for field name - the field name of your material number

Regards,

Nick

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 11:37:31 GMT

hi ravi,

Calculate using PROGRAM LINES node and display the via TEXT node in the FOOTER of the TABLE.

regards,

Prabhu

reward if it is helpful.

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 11:37:37 GMT

See this sample doc and code and write the report

Message was edited by:

raam

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 11:46:59 GMT

in order to get the points u mr.raam dont try to become smart i m talking about smartforms not in normal report ,,,,,,,,,,,,,,,,,read carefully before sending any thing.......

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 12:12:21 GMT

hi nick plz explain these column "for field name".....where to put which field.

Message was edited by:

ravi

Re: regarding total in smartforms

Former Member — Wed, 29 Aug 2007 12:23:57 GMT

The list follows the order of the columns across the grid,

if your table has fields MATNR and MENGE, and your totals go into W_MENGE

operand - SUM,

field name - MENGE

target field name - W_MENGE

time - after sorting

for field name - MATNR

reset - for sort criteria

for field name - MATNR

If you check the sort criteria event for MATNR the field W_MENGE will hold the sub-total for each material as the data is processed.

Regards,

Nick

Re: regarding total in smartforms

Former Member — Thu, 30 Aug 2007 03:41:36 GMT

hi nick,

sorry to have disturbed u dear here what is happening here when i m giving the fields like this in my smartforms,

operand - total,

field name -itab_final_sfm-labst_tm

target field name - v_labst1

time - after sorting

for field name - MATNR

reset - for sort criteria

for field name - MATNR

after checking it is giving this error::::::MATNR is not a valid sort criteria......

though the field matnr is existing in my internal table....plz help me.

....