Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Z Table Insertion Problem in Background

abhishek_katti
Explorer
0 Likes
675

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
651

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

5 REPLIES 5
Read only

Former Member
0 Likes
651

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

SKJ

Read only

Former Member
0 Likes
651

Hi Abhishek,

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

Thanks,

Srinivas

Read only

Former Member
0 Likes
651

check the reference field (waers)

and try with the fm CURRENCY_AMOUNT_DISPLAY_TO_SAP and/or CURRENCY_AMOUNT_SAP_TO_DISPLAY

Regards, Sebastiá

Read only

Former Member
0 Likes
652

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

Read only

abhishek_katti
Explorer
0 Likes
651

Thanks Sudheer,

It worked....