topic Re: data type in Application Development and Automation Discussions

data type

Former Member — Mon, 11 Dec 2006 11:40:14 GMT

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

Re: data type

Former Member — Mon, 11 Dec 2006 11:42:34 GMT

Hello Amit,

Use the addition NO-GROUPING with the WRITE statement.

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

Manoj

Re: data type

Former Member — Mon, 11 Dec 2006 11:42:48 GMT

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

Re: data type

Former Member — Mon, 11 Dec 2006 11:43:01 GMT

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

Re: data type

Former Member — Mon, 11 Dec 2006 11:44:38 GMT

thanks manoj.

but this is in a list(report).

Re: data type

Former Member — Mon, 11 Dec 2006 11:46:07 GMT

You can use the WRITE statement in a report..

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

Re: data type

Former Member — Mon, 11 Dec 2006 11:46:18 GMT

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

Reward if usefull..

Re: data type

Former Member — Mon, 11 Dec 2006 11:46:30 GMT

REUSE_ALV_LIST_DISPLAY is being used to display the results

Re: data type

Former Member — Mon, 11 Dec 2006 11:49:44 GMT

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

Re: data type

Former Member — Mon, 11 Dec 2006 11:50:45 GMT

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

wa_fcat-datatype = 'CHAR'.

Re: data type

Former Member — Mon, 11 Dec 2006 12:02:59 GMT

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.