data type

[Former Member]

there is a field in the report which has data type CURR length 8 and dec place 2.

because of this the value displayed has commas in between (like 100,000.00). how to do away with the commas?

thanks,

amit

[Former Member]

there is a field in the report which has data type CURR length 8 and dec place 2.

because of this the value displayed has commas in between (like 100,000.00). how to do away with the commas?

thanks,

amit

[Former Member]

Hello Amit,

Use the addition NO-GROUPING with the WRITE statement.

E.g: WRITE field CURRENCY curr NO-GROUPING.

Manoj

[Former Member]

thanks manoj.

but this is in a list(report).

[Former Member]

You can use the WRITE statement in a report..

E.g: WRITE <field> CURRENCY <curr> NO-GROUPING.

[Former Member]

Try this.

data: v_new(20).

write v_val to v_new. "V_val is your curr field

replace all occurances of ',' with '' in v_new.

write:/ v_new.

Regards,

ravi

[Former Member]

REUSE_ALV_LIST_DISPLAY is being used to display the results

[Former Member]

Of course, it can be a list program you have to mode the contents of the curr type field into a char type variable(Include another field in the internal table that is being displyed) and change the field catalog as well.

Regards,

Ravi

[Former Member]

in the fieldcatalog for that field , change the datatype to CHAR

wa_fcat-datatype = 'CHAR'.

[Former Member]

the data in the internal table is in the format 537863.39 . but when it is passed to REUSE_ALV_LIST_DISPLAY it is displayed with commas.

[Former Member]

You mean.. you want decimal in place of comma? whats your query..

[Former Member]

To change the settings, Go to system-> userprofiles->owndata. Select defaults tab and change the format..

Reward if usefull..