script -decimals & comma

[Former Member]

I have a quan value.

while passing it in script, it gets converted into thousand seperator (.)

I want to display a value in script with thosand seperator as (,) comma. eg 2,000.00

Thanks,

Gaurav

Edited by: Gaurav Kumawat on Apr 22, 2009 6:53 AM

[Former Member]

Well try this :

  DATA int1 TYPE i VALUE 12345678.
  DATA int(10) TYPE c.
  WRITE int1 TO int USING EDIT MASK '__,___.__'.

i.e declare a char type variable and then write the contents of ur field to this variable using edit mask.

this should work

tx

Ashwa

[matt]

Moved SAPScript questions belong in Form Printing, not general.

[Former Member]

Try any one of these solutions

1.system>user profile> own data > defaults

then set your value as required.

2.u can move this amount to type c varaible and then use:

replace ',' in ch with space.

condense ch.

[Former Member]

hi ,

use this link it will solve ur problem .

.

[Former Member]

HI Gaurav,

Declare that variable as the TYPE P.

Thanks!

[Former Member]

Hi Gaurav,

The decimal and separaters are from the user settings.

In transaction SU01, you can set your decimal and separaters.

use the WRITE statement in your print program and will get the decimal and separaters for the quatity field in the output.

Hope this will help you.

Regards,

Phani.

[Former Member]

hi,

On logging into the system, chk this

system->userprofile->owndata->

under this goto the default tab and chk for the decimal notation.

change it according to ur requirement.( for commas or decimals)

regards,

Lokesh

[Former Member]

this is also depended on the type you have selected for the currency

change that type you will get comm also .

rgds ankit

[Former Member]

hi,

Please contact to ur basis guy.

[Former Member]

hi,

You need to change your User profile settings...

User profile---> Own data.

Choose the required format for separators.

Regards

Sharath

[Former Member]

Thanks but tht we tried..its not closing tht issue..

pls suggest any other conversion..

[Former Member]

hi,

Set the country key inside the script.

/: SET COUNTRY &country_key&

(The formatting for certain field types depends on the country settings. These field types include, for example, date fields and number fields that include either a decimal point or the u2018thousandsu2019 separator character)

with ref to SAP library.

regards

Sharath