topic Re: Z Table Insertion Problem in Background in Application Development and Automation Discussions

Z Table Insertion Problem in Background

abhishek_katti — Wed, 04 Apr 2007 18:34:39 GMT

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

Re: Z Table Insertion Problem in Background

Former Member — Wed, 04 Apr 2007 18:39:42 GMT

Check the user settings in SU01 under DEFAULTS tab and Decimal notatin section.

SKJ

Re: Z Table Insertion Problem in Background

Former Member — Wed, 04 Apr 2007 18:52:54 GMT

Hi Abhishek,

Please go through System->User Profiles->User Defaults and change the decimal notation and try.

Thanks,

Srinivas

Re: Z Table Insertion Problem in Background

Former Member — Wed, 04 Apr 2007 18:54:42 GMT

check the reference field (waers)

and try with the fm CURRENCY_AMOUNT_DISPLAY_TO_SAP and/or CURRENCY_AMOUNT_SAP_TO_DISPLAY

Regards, Sebastiá

Re: Z Table Insertion Problem in Background

Former Member — Wed, 04 Apr 2007 19:44:59 GMT

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

Re: Z Table Insertion Problem in Background

abhishek_katti — Thu, 05 Apr 2007 08:17:25 GMT

Thanks Sudheer,

It worked....