Skip to Content
avatar image
Former Member

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

Hello!

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 27, 2017 at 07:53 AM

    Hi Hendrick,

    did you resolve the problem?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 :|

    Add comment
    10|10000 characters needed characters exceeded