Skip to Content

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

Value is round when load data form source to target table

Hi All,

I am facing a different issue when I am working on support environment.

Here I am proving example

My Source ( Oracle Table)


Qty,  Exchange_Rate, Bill_Rate

17.5,  6869.5,             934.36

when I load this data into target values are rounding, such as

My Target ( Oracle Table)


Qty, Exchange_Rate, Bill_Rate

18,   6870,                  934

How to solve this issue please guide me it is very urgent issue .

Thanks and Regards,



Hi @Murali Krishna,

You can use to_decimal function as i mentioned above and change the data type to decimal in the query level of the particular columns.

Please close the thread by marking it as Helpful or Answered.


Akhilesh Kiran.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question