‎2007 Apr 04 7:34 PM
Hi Experts,
I'm updating one Z table through a file which resides on application server. I'm doing this process in background mode.
Process is working fine, but my file contains currency values without decimals, while updating this file in foreground mode table gets updated by taking exact values from file, but in Background mode it changes the values.
for eg. value 500 is getting changed as 50,000.00
I cant understand why such thing is happening.
Please help!!
Regards,
Abhishek Katti
‎2007 Apr 04 8:44 PM
Hi,
After moving all the data from the Aplication server to Internal table, just add this logic...
data: cur(13) type c.
LOOP AT ITAB.
write: ITAB-FIELD to Cur. " ITAB-FIELD is the currency field here
Move CUR to ITAB-FIELD.
Modify ITAB index sy-tabix.
ENDLOOP.Regards
Sudheer
‎2007 Apr 04 7:39 PM
Check the user settings in SU01 under DEFAULTS tab and Decimal notatin section.
SKJ
‎2007 Apr 04 7:52 PM
Hi Abhishek,
Please go through System->User Profiles->User Defaults and change the decimal notation and try.
Thanks,
Srinivas
‎2007 Apr 04 7:54 PM
check the reference field (waers)
and try with the fm CURRENCY_AMOUNT_DISPLAY_TO_SAP and/or CURRENCY_AMOUNT_SAP_TO_DISPLAY
Regards, Sebastiá
‎2007 Apr 04 8:44 PM
Hi,
After moving all the data from the Aplication server to Internal table, just add this logic...
data: cur(13) type c.
LOOP AT ITAB.
write: ITAB-FIELD to Cur. " ITAB-FIELD is the currency field here
Move CUR to ITAB-FIELD.
Modify ITAB index sy-tabix.
ENDLOOP.Regards
Sudheer
‎2007 Apr 05 9:17 AM