3543037 - The "Totals" of Net Value is not the Sum of Net Value in the "Sales Order Fulfillment Issues - F0029A" App

 In the "Sales Order Fulfillment Issues - F0029A" app, the total value of the "Net Value" column is not the sum of all the net values in the table.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

SAP S/4HANA Cloud Public Edition

CDS view C_SlsDocFlfmtIssue is used to retrieve the data such as Net Value (TOTALNETAMOUNT). This field is defined as " @DefaultAggregation: #MAX" for CDS annotations that (as a rule) are evaluated during runtime -- to aggregate the data dynamically and returns the largest of the specified values.  

"
   @DefaultAggregation: #MAX
   @Semantics.amount.currencyCode: 'TransactionCurrency'
   @Consumption.filter.hidden: true
   SalesDocument.TotalNetAmount,
"

For the performance consideration, it does not retrieve whole data for aggregation from the database.

This is a standard system design according to the CDS view. The value of the "Net Value" column is the highest value from the list for each currency, rather than a total. 

Sales order fulfillment issues, F0029A, Sales, Net Value, Totals, Sum, Max, Calculation, CDS view, largest, currency , KBA , SD-FIO-HBA-2CL , Analytical Apps (Public Cloud) , Problem

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions