Default decimal notation in user profile

[Former Member]

Dear All,

Is there any way by which we can ignore decimal notation saved in user profile.

I need to set the decimal notation 1,234,567.89 irrelevant of user profile setting. If user has saved any other optios for decimal notation in user profile then also i need to set the decimal notation as 1,234,567.89.

Thanks a adv.

[Former Member]

Hello

So, for this I have created in OY01 three countries:

Z1 with decimal notation 1.234.567,89

Z2 with decimal notation 1,234,567.89

Z3 with decimal notation 1 234 567,89

When I need to use in report some decimal notation I set particular country:

set country 'Z1'. " output will be in format 1.234.567,89
" or
set country 'Z2'. " output will be in format 1,234,567.89
" or
set country 'Z3'. " output will be in format 1 234 567,89

[Former Member]

Dear Dzed,

Thanks for your answer.

I am fetching data from custom database tables and i am using dynamic internal table (using field symbol) to fetch this data.

After this data i am creating file on application server as well as downloading the file in .txt format in presentation server depending upon the user input.

In the above case how can i use set country statement to override user pfofile settings.

Once again thanks a lot.

[Former Member]

Deleted.

Another folk has already posted the same answer.

Edited by: Amit Gujargoud on Mar 4, 2010 8:30 AM

[Former Member]

Hi Sheelesh,

you set according to your wish for the data fromat from user profile in the system itself.

Go to initial screen .i.e SAP easy accessSystem>userprofile--->Click on defaults tab and change the data according to your wish.

Regards,

Venkat.

[Former Member]

Dear Venkata,

This is not what i want.

My requirement is to set the decimal notation 1,234,567.89 irrelevant of user profile setting.

supose any user choose the profile setting as 1.234.567,89 then also i want my value as 1,234,567.89

[Former Member]

Hello,

As mentioned in one of the posts, create or check tcode OY01 and see the country for which the settings are as per your requirement (say 1,234,567.89).

In your program you have created an internal table dynamically and are populating the data from a table. Just before your are using that data to load in the app server or download as a .txt file write the statement set country 'Z1'.

Now the data in the internal table when processed will give you output as you desire.

Hope this helps

Regards,

Sachin.