topic Re: decimal format in sapscript in Application Development and Automation Discussions

decimal format in sapscript

Former Member — Wed, 20 Jun 2012 11:08:52 GMT

Requirement is to display the amount in format 1,233.00 Eur without changing the country specific settings in oy01 . current settings are printing it like 1.233,00

Any ideas please .

shld i do it by splitting and replacing , with period .

Regards

Re: decimal format in sapscript

former_member213851 — Wed, 20 Jun 2012 11:12:44 GMT

Hi Linda,

You can make use of SPLIT and Concatinate commands to disaply required format in SMARTFORM or script.

If you want this for saving in excel, just right click on that cell and select Format cell , select required currency format .

Re: decimal format in sapscript

Former Member — Wed, 20 Jun 2012 11:20:34 GMT

Hi Sachin,

Thanks . I was thinking to set the dec format just before the printing of the output . Is it possible ?I am currently looking for that way . otherwise yes this split and concatenate is the last option .

do you have any idea of setting the dec point format at runtime .

Thanks

Re: decimal format in sapscript

former_member213851 — Wed, 20 Jun 2012 11:33:58 GMT

Hi Linda,

Please refer below link:

You can take help from BI team for this.

http://scn.sap.com/thread/1703605

Re: decimal format in sapscript

Former Member — Wed, 20 Jun 2012 18:03:15 GMT

Hi, You can also think of making changes at user profile level. Go to SU01 and change the decimal notation in the DEFAULTS tab to your desired format. You need to logoff and login again to get the changes reflected.

Re: decimal format in sapscript

Former Member — Wed, 20 Jun 2012 18:38:10 GMT

You don't have to use transaction oy01 to change the country specific settings. You can do it directly in the SAPScript with:

/: SET COUNTRY 'USA'

or whatever country has the formatting you want (from BC 460)

Rob

Re: decimal format in sapscript

former_member209818 — Thu, 21 Jun 2012 09:15:32 GMT

You can move the contents of your Amount fields to another field using a EDIT MASK and then can use that field for print purpose

Re: decimal format in sapscript

Former Member — Thu, 21 Jun 2012 13:01:38 GMT

Using SAPScript??

Rob

Re: decimal format in sapscript

Former Member — Thu, 21 Jun 2012 13:10:04 GMT

Thanks all for the help.

Since the requirement was just to change the display . comma instead of period , without changing any country specific setting . So i opted to do it with the simplest way using the replace character functionality .

Regards

Re: decimal format in sapscript

Former Member — Thu, 21 Jun 2012 13:13:13 GMT

Simplest??

Rob

Re: decimal format in sapscript

Former Member — Tue, 10 Jul 2012 06:15:15 GMT

Hi Linda,

Can you tell me how did you replace character functionality?

Thanks..

Re: decimal format in sapscript

Former Member — Tue, 10 Jul 2012 06:49:28 GMT

Hi nishit,

Just use replace statement 3 times . first time make period to any other character say $ , then comma to period and then dollar to comma .

Try

Regards

Linda