topic Re: Decimal notation based on Country in Application Development and Automation Discussions

Decimal notation based on Country

Former Member — Mon, 28 Apr 2008 11:32:12 GMT

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 — Mon, 28 Apr 2008 11:45:21 GMT

HI,

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

Reward points if useful

Former Member — Mon, 28 Apr 2008 11:47:37 GMT

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 — Mon, 28 Apr 2008 11:47:57 GMT

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.