regarding total in smartforms

[Former Member]

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

[Former Member]

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.

[former_member188827]

u can create program lines and do calculations...

[Former Member]

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.

[Former Member]

Hi,

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

Regards,

Padmam.

[Former Member]

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

[Former Member]

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

Message was edited by:

ravi

[Former Member]

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

[Former Member]

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.

....

[Former Member]

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.

[Former Member]

See this sample doc and code and write the report

Message was edited by:

raam

[Former Member]

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.......