Skip to Content
0

Currency Translation - Repeat for the same selection data returns 0 records

Dec 29, 2016 at 01:30 AM

75

avatar image

Hi,

I ran the currency translation using data manger package for a selection criteria.

Category: Actual

Entity: C1001

Time: 2016.11

Reporting Currency: USD

Currency translation was successful and i was able to view both the LC and reporting currency.

Now, I ran the currency translation data manager package with the same selections. Status was successful but it did not process any records. The logs mentioned 0 records processed. Can I know how this is handled by the system? Is there any place holder where it maintains the status of the translated records?.

Also, I deleted the data of the currency translated records and ran the DM package. Now currency translation worked and converted the amounts. Can you help me in the understanding this mechanism how system handles?

Thanks,

Selva.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Gersh Voldman
Dec 29, 2016 at 02:22 AM
0

Hi Selva,

Yes, currency translation works on changed records only. There is a table in which it records when was the last CT and doesn't translate it if value didn't change from last translation.

So, if you rate changes or rule changes you have to remove results and run CT again.

Regards,

Gersh

Share
10 |10000 characters needed characters left characters exceeded
Selva AM Dec 29, 2016 at 08:45 PM
0

Hi Gersh,

Thanks for your reply. Can I know the table which holds this information. Also, can I l know which program or Badi is used for currency translation in the back end for debugging purposes.

Thanks,

Selva.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 30, 2016 at 05:02 PM
0

I don't remember the table but for the code: look on the code of UJK_SCRIPT_LOGIC_EXECUTE function module, you will find currency conversion code in 5 minutes.

Share
10 |10000 characters needed characters left characters exceeded
Gersh Voldman
Jan 02, 2017 at 08:50 AM
0

Hi Selva,

Please take a look at Class CL_UJP_CURR_CONVERSION and table UJP_STAMP_CT.

Regards,

Gersh

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Gersh,

Not sure about UJP_STAMP_CT

Just tested in my test system - no records are generated for currency conversion using standard script...

Model - simple periodic financial model created in the copy of environmentshell.

0