topic Re: Conversion Routine in Application Development and Automation Discussions

Conversion Routine

Former Member — Tue, 10 Oct 2006 06:01:56 GMT

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 ?

Re: Conversion Routine

Former Member — Tue, 10 Oct 2006 06:15:39 GMT

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..

Re: Conversion Routine

Former Member — Tue, 10 Oct 2006 06:19:19 GMT

Hi,

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

Hope this helps

Regards

Sunil.M

Re: Conversion Routine

andreas_mann3 — Tue, 10 Oct 2006 06:29:23 GMT

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 ',.'.

Re: Conversion Routine

Former Member — Tue, 10 Oct 2006 06:45:41 GMT

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.

Re: Conversion Routine

Former Member — Tue, 10 Oct 2006 06:48:48 GMT

hi,

go for SYSTEM in menu bar,

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

select which type display you want.

regards,