Conversion Routine

[Former Member]

I am new to Abap and BW .

In my source system I have a number format as 1.111,02 .

But I have to load the R/3 data to ODS in Bw which must have a number format as 1,111.02 .

Can you help me in writing the conversion routine ?

[Former Member]

hi,

for this i think u need to have some settings to be done.

<b>SYSTEM -> USER PROFILE -> OWN DATA</b>

here u can see decimal notation which u would like to have.

hope it helps..

reward if useful..

[Former Member]

Hi,

Please set the format in the SYSTEM menu->Own Data->Defaults tab -> Decimal Notation.

Hope this helps

Regards

Sunil.M

[andreas_mann3]

Hi,

i think, that you do'nt need the separation signs for thousands

so you must only replace the decimal notation.

move your values to a char-field c_val

and use abap-command:

transfer c_val using ',.'.

A.

[Former Member]

To change the number format you may probe this code:

<b>PARAMETERS: ek_netpr(18).

DATA: subrc LIKE sy-subrc.

INITIALIZATION.

ek_netpr = '2.000.000,00'.

START-OF-SELECTION.

REPLACE ',' WITH '#' INTO ek_netpr.

subrc = 0.

WHILE subrc = 0.

REPLACE '.' WITH ',' INTO ek_netpr.

IF sy-subrc = 0.

subrc = 0.

ELSE.

subrc = 1.

ENDIF.

ENDWHILE.

REPLACE '#' WITH '.' INTO ek_netpr.

CONDENSE ek_netpr NO-GAPS.

WRITE:/ ek_netpr.</b>

Regards.

[Former Member]

hi,

go for SYSTEM in menu bar,

then USER PROFILE>OWNDATA>DEFAULTS --> DECIMALS.

select which type display you want.

regards,