Workflow emails displaying comma as decimal separator

[Former Member]

Hello, My workflow for claims approval sends out email to the requester when a claim is approved. The problem is the amount mentioned in the email text is of the format 2.355,00. I want it to be displayed like 2,355.00. I have set the User's default settings for the approver in SU01 to "1,234,567.89", but that did not help. Please help. Thanks, Ashu

[Former Member]

Hello, My workflow for claims approval sends out email to the requester when a claim is approved. The problem is the amount mentioned in the email text is of the format 2.355,00. I want it to be displayed like 2,355.00. I have set the User's default settings for the approver in SU01 to "1,234,567.89", but that did not help. Please help. Thanks, Ashu

[Abhijit74]

Hello,

Use function module STRING_REPLACE to convert the decimal notation.

CALL FUNCTION 'STRING_REPLACE'

EXPORTING

pattern = ','

substitute = space

changing

text = lv_text

EXCEPTIONS

WRONG_STRING_LENGTH = 1

OTHERS = 2.

And also check

report zrich_0004.

data: c(100) type c.

data: length type i.

data: offset type i.

c = '1223,54'.

length = strlen( c ).

offset = length - 3.

translate c+offset(1) using ',.'.

write:/ c.

Or use replace all occurrences of statements

Thanks,

Abhijit

[Former Member]

Thanks for the reply Abhijit.

I can use that code, but the thing is the emails display correct format in our Development and Quality clients, only in Production this format is displayed.

Could this be some setting?

Thanks and Regards,

Ashu

[former_member194152]

Check the requestor decimal notation in SU01, also check the company code decimal notation in OY01.

[Former Member]

Thanks everyone for the replies.

Just found out the setting of the Workflow background user that is responsible for sending emails was incorrect.

I corrected the same and problem is resolved.

Thanks again.

Regards,
Ashu