Field EDIT_MASK in ALV fieldcatalog

[eyal_alsheikh]

Hi,

How can I use edit_mask of ALV field catalog in order to

format the currency value sign to be on the left of the value instead of on the right?

Example: - 100.00 instead of: 100.00 -

My field to be displayed in the ALV column is of type CURR 13.

Is there any conversion routine or mask format?

Thanks,

Eyal.

[jayanthi_jayaraman]

Hi,

If you set a conversion exit (for example,

conv = ' ==ALPHA ' for function module CONVERSION_EXIT_ALPHA_OUTPUT ), you enforce output conversion for the associated output field.

WRITE amount TO output USING EDIT MASK 'RRV_____,___'.

Have a look at keyword documentation;

- RR = right justified

- V = sign

- _ = place holder for number

- , = decimal separator

- _ = place holder for decimals

Refer this link to get idea.

Or you can even solve this problem by moving it into char fields and then concatenating minus sign with it.

Hope it helps.

Rgds,

J.Jayanthi

[former_member795937]

How it can be used for value with thousand separator and decimal separator.

[Former Member]

Hi,

U can set the fieldcat as follows

ls_fieldcatalog-EDIT_MASK = '$___,__'.

Have a look into this link

Thanks & Regards,

Juidth

[Former Member]

Hi Eyal,

I am stuck with the same problem of a preceding sign for negative values.

Can you share it with me if you have the solution?

Thanks,

Harsha