Skip to Content

wrong grouping and subsums in sap smart table (type analytical, screenshots inside)

Mar 17, 2017 at 09:54 AM


avatar image


we have tried to implement a smart table (type analytical). Querys like $select,filter,sorter,count etc are implemented in the backend. Does grouping / subsums also need a backend implementation? From our understanding the smarttable should be able to do this on its own?!

EDIT: also we found that a similar or maybe the same issues is present in a sapui5 explored Example (click). If you add price as a column it takes only the first value as a sum.

Here an example with screenshots.

First step

The initial request fetches the correct data, but the sum/total line is not showing the correct result in fact it only shows the value of the last line item (ID = 14) (Picture 1)

Second Step

The column 'Hauptkunde' is now grouped. Smarttable duplicates the group 14 times (count of selected dataset) and again shows the wrong sum from step one.

Third Step

Expanding one group row opens all duplicated rows (compare picture2).

Metadatafile. The column 'Zahl' in the table is the property 'Umsatz 2012' in the metadata file

It may be interesting that the metadata shows the correct data but in the case of grouping it does not submit the key while getting the specific data.

Screenshot of the first request

Screenshot of the second request

all.jpg (184.9 kB)
grouping1.jpg (115.6 kB)
grouping2.jpg (159.1 kB)
metadata.jpg (208.2 kB)
i1.jpg (63.0 kB)
i2.jpg (40.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Fabio F. Mar 27, 2017 at 07:53 AM

Hi Hendrick,

did you resolve the problem?

10 |10000 characters needed characters left characters exceeded
Hendrik Pöhlmann Mar 27, 2017 at 11:28 AM

Hi Fabio, unfortunately not. I saw several threads with this issue, but no help from offical site so far :|

10 |10000 characters needed characters left characters exceeded