Skip to Content
0
Former Member
Jun 06, 2013 at 09:28 AM

convert char to dec/amount in BW

82 Views

Hello,

i loaded Data from Data Services in BW.

The generated DataSource deliver the DEC Attribute (AMOUNT) as CHAR, no DEC are supported by the Transfer Structure.

The field AMOUNT it's like "453,26-" or "1.189,82-".

When i load the data from PSA in DSO i become the error:

"The argument ' 453,26-' cannot be interpreted as a number"

How can i transform the field into decimal?

I read about the Function "HRCM_STRING_TO_AMOUNT_CONVERT" but I cant find it in my Customer system.

Thank you in advance for the response.

Regards,

Vjola