convert char to dec/amount in BW

[Former Member]

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

[jayanthi_jayaraman]

Hi,

Just try by removing comma in char using Replace statement and then assign it directly to decimal target structure.