cancel
Showing results for 
Search instead for 
Did you mean: 

Hadling Data in XI

Former Member
0 Kudos

Hi All,

I am new to XI

I have a field Decimal.I am getting 4.14E10 value from Source System.I need to Convert it to Decimal like 414000000.00(in this format)

Can any one help on this?

thanks,

pachika

Accepted Solutions (1)

Accepted Solutions (1)

dharamveer_gaur2
Active Contributor
0 Kudos

write udf to convert from exponent format to decimal fromat

Answers (2)

Answers (2)

Former Member
0 Kudos

not good

former_member183906
Active Contributor
0 Kudos

Use type DEC with length 9 and 6 decimals

OR

You can use BAMNG data elemnt

(Use reference table EBAN ref. field MEINS)

Former Member
0 Kudos

Thanks for reply.

It is the problem in XI not ABAP.

thanks,

pachiks

former_member183906
Active Contributor
0 Kudos

You could achive with standard API FormatNumber in arithmatic category of Mapping.

here you could select the format that you are expecting as output as ####.### etc

source >FormatNumber->target

refer

format-number function

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9202d890-0201-0010-1588-adb5e89a...