topic Re: table T005X in Application Development and Automation Discussions

table T005X

Former Member — Tue, 26 Feb 2008 11:09:06 GMT

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,

Re: table T005X

Former Member — Tue, 26 Feb 2008 11:43:46 GMT

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

Re: table T005X

Former Member — Tue, 26 Feb 2008 11:48:15 GMT

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.

Re: table T005X

Former Member — Thu, 28 Feb 2008 08:55:56 GMT

Try OY01