decimal format in sapscript

[Former Member]

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

[former_member213851]

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 . 

[Former Member]

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

[former_member213851]

Hi Linda,

Please refer below link:

You can take help from BI team for this.

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

[Former Member]

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.

[Former Member]

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

[former_member209818]

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

[Former Member]

Using SAPScript??

Rob

[Former Member]

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

Ls

[Former Member]

Simplest??

Rob

[Former Member]

Hi Linda,

Can you tell me how did you replace character functionality?

Thanks..

[Former Member]

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