table T005X

[Former Member]

Hi all

Currently in table T005X , for country IN , the value

of field XDEZP (Decimal Notation ) is space . we

wish to update it to 'X' . As per my understanding ,

this can be done in some customisation settings .

Can anyone guide how to go about this ?

Thanks all,

[Former Member]

Hi,

You can do this by following below steps.

1. Use SM30 and give the view name as V_T005. Then click On Maitain.

2. If it allows to change the settings, then all avaialable records will be displayed.

3. Choose the Country code for which you need to change the settings, and then clici on change button.

4. You can see Date format and Decimal format. Change the radiobuttons appropriately and then SAVE.

AS these are general settings the changes may not be allowed for normal users. Check before you do any changes as this will reflect in entire system

Regards,

Ashok

[Former Member]

If the output is to be printed in the format as per the country code then you have to get the decimal notation of that country from the table t005x. The decimal notation field

is xdezp.

Then convert the value as per the decimal notation required. You can use it this way.

• Translate the Component value

• If comma is used for decimal separator "e.g. 1.500.010,009

if l_xdezp eq space.

TRANSLATE px_in-value USING '. '.

TRANSLATE px_in-value USING ',.'.

• If dot is used for decimal separator "e.g. 1,500,010.009

elseif l_xdezp eq 'X'.

TRANSLATE px_in-value USING ', '.

endif.

[Former Member]

Try OY01