Subtotals on tables using Webdynpor for JAVA

[Former Member]

Hi everybody

On requirement of my project, I need to manage subtotals on table which function are consult information.

For example I want this:

Supplier Document Total

MCA SA. 1000001 $100

MCA SA. 1000002 $200

MCA SA. 1000003 $300

Sutotal

[Former Member]

Hi everybody, I solved my problem.

Firstable I create a Table1 which contain the principal information of Supplier

No Supplier No.of_Docs Total

1 SUPP1 3 1000

The field Total is a CalculatedAttribute.

And then I implemet a cell popin on field No.of.Docs, when the user click on this field a popin opens.

This popin shows the documents of the supplier.

Finally I get the Global Total of supplier, and this can solver with CalculatedAttribute.

[Former Member]

Thanks for your help, I think that it so helpful, I'll do your suggestions.

[Former Member]

Hi Jesus

Did you try out the solution ?

Regards,

Sayan Ghosh

[Former Member]

Thks, Your suggest so helpful for my webdynpro view,

but I need to add a row on a table, whch contains only the subtotal

This is an example of a view, is only one table

Supplier Document Ref Amount

A.................12...........QA..........10

A.................13...........PA...........20

..................................................30 (this a subtotal of supplier A)

B.................12...........QA.........100

B.................23...........PB..........100

B.................33...........PC..........100

................................................300 (this a subtotal of supplier A)

And in othe field I can show the total of table

Total: 330

[Former Member]

Hi Jesus,

You can add the FixedBottomCell UI under the Amount TableColumn UI in the Table. The FixedBottomCell will automatically create an additional row in the table showing the Summation Value under the Amount Column.

You can also add another FixedBottomCell under the Ref TableColumn, and in its Editor, put a textView UI containing text Subtotal. So the subtotal text will appear under the Ref column in the same row as the Calculated value.

Hope this helps !!!

Regards,

Sayan Ghosh

[Former Member]

The example is

Supplier Document Total

MCA SA. 1000001 $100

MCA SA. 1000002 $200

MCA SA. 1000003 $300

Sutotal $600

Supplier Document Total

MCA SA. 1000001 $200

MCA SA. 1000002 $200

MCA SA. 1000003 $300

Sutotal $700

it is on only table view

Anybody have an idea?

Edited by: Jesus Salinas on Mar 23, 2011 11:34 PM

[Former Member]

Hi Jesus,

For such case you can use the calculated attribute and in that attribute's getter method you can put the logic for addition.

for using calculated attributes please follow this E-Doc [Calculated Attributes in Web Dynpro Java|http://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/e093a9d8-c00e-2b10-7dae-b72c3a8c5536].

Regards

Jeetendra

[Former Member]

Hi Jesus,

You can use the Calculated Attribute as suggested by Jeetendra in the above post. In order to show the total in the bottom of the table column, you can use a FixedBottomCell (TableStandardCell) under the TableColumnUI of the required column in the Table.

You can use a TextView as the Editor of this FixedBottomCell UI and bind it to the Calculated value in the context.

Regards,

Sayan Ghosh

Edited by: sayan ghosh on Mar 25, 2011 11:04 AM