SAP Knowledge Base Article - Preview

2120917 - group by function returns incorrect results on numeric datatype from SAP


  • SAP table has Numeric as data type and it is imported as Numeric in Data Services.
  • Data Services query transform has an aggregate function like group by on this column of type Numeric. The group by doesn't work properly.



SAP Data Services 4.x


SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2


numeric, decimal, primary key, aggregate, group by, ds, data services , KBA , EIM-DS-SAP , SAP Interfaces , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.