Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Decimal Problem

select

T0.U_ItemCode,

T0.U_ItemName,

T0.U_Forecast,

SUM(T0.U_mrpqty)'Simulated Qty',

(select sum(onHand) from OITW T1 where T1.ItemCode = T0.U_itemcode) 'Current Quantity',

(select T3.ItmsGrpNam from OITM T2 inner join OITB T3

on T2.ItmsGrpCod = T3.ItmsGrpCod where T2.ItemCode = T0.U_itemcode)'Item group name'

from [dbo].[@QUOTA1] T0

where T0.U_ItemCode >= '[%0]' and T0.U_ItemCode <= '[%2]'

and T0.U_Forecast = '[%1]'

group by

T0.U_itemcode,

T0.U_itemname,

T0.U_Forecast

When I run this query in SQL server 2008, in 'Simulated Qty' and Current Quantity the values are coming like 0.002084

6 decimal places after point, but in SAP B1, it comes .00

Former Member
Not what you were looking for? View more on this topic or Ask a question