topic Re: data formatting for quantity field in Application Development and Automation Discussions

data formatting for quantity field

Former Member — Tue, 11 Mar 2008 06:34:15 GMT

Hi,

while extracting the data for the quan field in a variable it is without comma(in table it is with comma) ...but i want that data in a variable with comma like if the data is 12345.000

i want it in the form of 12,345.000 and so on.

thanks in advance.

Re: data formatting for quantity field

Former Member — Tue, 11 Mar 2008 06:41:41 GMT

Hi,

change the user settings of your login.

go to tcode: SU3.

press default tab.

there you check the currency and qty fields. choose appropriate one and save, your problem will be get resolved.

Re: data formatting for quantity field

Former Member — Tue, 11 Mar 2008 06:46:05 GMT

You can change the User profile settings through:

System~~>User Profile~~>Own Data--> Defaults Tab

Change the Numbers tab as desired, you will achieve the o/p.

Hope this helps.

Regards

Vinayak

Re: data formatting for quantity field

Former Member — Tue, 11 Mar 2008 06:49:57 GMT

It depends upon the user setting in SU3.

change thhe same otherwise go to USR01 and check the same for the user

1.234.567,89

X 1,234,567.89

Y 1 234 567,89

replace the same based on value of DCPFM

use replace

Regards

Shiva