07-02-2007 6:10 AM
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 dont need to change. How to do this.
Please help me.
Thanks to all.
07-02-2007 6:17 AM
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.
07-02-2007 6:20 AM
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.
07-02-2007 6:18 AM
Hi,
CHeck by maintianig the decimal notaiton in your user profile.
Goto menu SYstem->User Profile->Own Data.
Defaults Tab - Decimal Notation.
Regards,
Sesh
.
07-02-2007 6:20 AM
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
07-02-2007 6:31 AM
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,