Real Numbers extracted to a Key Figure

[Former Member]

I am extracting some data from a non SAP system. There is one field which I am mapping to a key figure. In the external system the field is of data type real. My key figure is a Floating Point Number.

When I extract this field in the PSA and Key figure representation it is shown for example as follows

8,0000000000000000E+00

Why is this and how can I just show the number? Thanks

[Former Member · Accepted solution]

floating point is 16 places. hence you will see that.

[Former Member · Accepted solution]

Raj,

Thanks for this. In order to see 16 what type should I define the key figure as?

[Former Member]

PSA is the representation of data extracted from source system without transformation, because of that you see the number in that way, have you tried to do a load?

[Former Member]

Hi Oscar

We are extracting from DB2 tables using DB Connect.

I have checked the DB2 table and the field value will appear for example as 16. Whereas in the PSA and DSO tables

1,6000000000000000E+01

Thanks