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,

Murali

replied

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.

Regards,

Akhilesh Kiran.

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