topic Re: Default decimal notation in user profile in Application Development and Automation Discussions

Default decimal notation in user profile

Former Member — Thu, 04 Mar 2010 07:05:57 GMT

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.

Re: Default decimal notation in user profile

Former Member — Thu, 04 Mar 2010 07:25:54 GMT

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

Re: Default decimal notation in user profile

Former Member — Thu, 04 Mar 2010 07:30:05 GMT

Deleted.

Another folk has already posted the same answer.

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

Re: Default decimal notation in user profile

Former Member — Thu, 04 Mar 2010 09:15:17 GMT

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.

Re: Default decimal notation in user profile

Former Member — Thu, 04 Mar 2010 09:25:22 GMT

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 access~~System~~>userprofile--->Click on defaults tab and change the data according to your wish.

Regards,

Venkat.

Re: Default decimal notation in user profile

Former Member — Thu, 04 Mar 2010 09:28:06 GMT

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

Re: Default decimal notation in user profile

Former Member — Thu, 04 Mar 2010 09:36:20 GMT

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.