topic Re: Conversion in Application Development and Automation Discussions

Conversion

Former Member — Mon, 02 Jul 2007 05:10:44 GMT

Hi friends,

My upload file contains the price field and it contains the value as 3,200.00 I want to change it to 3.200,00. if my upload file contains the value 3.200,00 that time I don’t need to change. How to do this.

Please help me.

Thanks to all.

Re: Conversion

Former Member — Mon, 02 Jul 2007 05:17:08 GMT

Hi Bharat,

You can change the currency format in su01 itself so that system takes care of such conversions.

goto su01 -> give userid -> change -> defaults tab -> Change the Decimal notation to required format.

Reward points if useful,

Aleem.

Re: Conversion

seshatalpasai_madala — Mon, 02 Jul 2007 05:18:16 GMT

Hi,

CHeck by maintianig the decimal notaiton in your user profile.

Goto menu SYstem->User Profile->Own Data.

Defaults Tab - Decimal Notation.

Regards,

Sesh

Re: Conversion

Former Member — Mon, 02 Jul 2007 05:20:23 GMT

Hi Bharat,

First read this currency field in any char field of the table( lets say lv_curr_char), then use

REPLACE ALL OCCURANCES OF '.' FROM lv_curr_char BY spaces.

REPLACE ALL OCCURANCES OF ',' FROM lv_curr_char BY spaces.

CONDENSE lv_curr.

lv_curr_char = lv_curr_char / 100.

WRITE lv_curr TO lv_curr.

lv_curr is actual currency field.

Reward points if useful.

Regards,

Atish

Re: Conversion

Former Member — Mon, 02 Jul 2007 05:20:53 GMT

Hi thank you for your reply but in my system defualts it is in the format 3.200,00

but when i am trying to upload the file contains the value 3,200.00 then it is not converting automatically.

Re: Conversion

Former Member — Mon, 02 Jul 2007 05:31:21 GMT

Hi,

First you store all the upload files data into Internal table using UPLOAD Function module and then check your condition,

for example:

LOOP AT ITAB.

IF ITAB-PRICE = 3,200.00.

ITAB-PRICE = 3,200,00.

UPDATE ITAB.

ENDIF.

ENDLOOP.

IF U CAN'T UNDERSTAND THIS CODE, SEND YOUR CODE I WILL CORRECT IT.

IF USEFULL REWARD,