Decimal notation based on Country

[Former Member]

Hi

I am displaying data including amount in ALV grid and I am using OOP's ALV to display data in ALV.

Here, If the country is DE then the amount will be 1,000.20

if country is Germany then it should be 1.000,20

This is the format for Germany for amount columns.

Based on the country I have to get this format and have to display in ALV grid.

How to achieve this....

now,Always, its showing same format for all countries....

I found the table...the table name is T005X

But where to assign this in ALV grid...hw to convert...

Edited by: Sumi Vasu on Apr 28, 2008 1:32 PM

[Former Member]

HI,

Go to transaction SU3 and change the decimal notation as required.

Reward points if useful

[Former Member]

Hi,

Thanks for the reply.

I cant ask the user to change manually...

This I have to incorportate in code...

If I can do manually, I can do it through user profile.

But Based on the country they are giving as input, I need to display....

This is the requirement.

[Former Member]

hi you can use these statements:

data: amount1(30) type c.

amount = 1000.20.

write amount to amount1 currency docu_curr.

Pass relavent currency in docu_curr and now use amount1 to display instead of amount.

reward if useful.