Report Output for Currency Field--EKBE-WRBTR

[Former Member]

Hello ABAP Experts

Since the Issue is related with Related Report output. Thought ABAP General Forum would be right place to post.

If not Suggest an appropriate forum for the same. I shall post them in Correct Forum.

Currently the report display Currency value From EKBE- WRBTR field

Actual Record Stored in EKBE is like this

0,00

400,00

1.600,00

client requirement is

0, 00

400,00

1600, 00

Option-1

I have tried option for conversion to CHAR & printing in Output, the issue I face is when I export to Excel I am getting an ABAP Error CONVT_NO_NUMBER(Short Dump)-This dump is due to conversion while exporting to excel.

Option-2(from SDN)

Give a logic based on T005 table i.e. this table has the decimal place setting for a each country (this I need to Verify)u2014But the I fear that report output can be confusing.

Expecting all your expert inputs!!

BR

Bharath

[Former Member]

Hi,

Go to SU01, select your user.

goto defaults and you can choose the decimal notation settings available as dropdown.

choose the last option and run your report.

Check if this meets your requirement.

I have not tried this, but i guess you can give it a shot.

Regards,

Shruthi R

[Former Member]

Hi Bharat,

You can set it using user--profile I guess.

For own data go to

system>user profile>own data---> defaults.

There you can select the currency format.

Hope this helps you.

Thanks,

Arun