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

[selva_amd]

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.

[Former Member]

Hi Selva,

Please take a look at Class CL_UJP_CURR_CONVERSION and table UJP_STAMP_CT.

Regards,

Gersh

[former_member186338]

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.

[former_member186338]

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.

[selva_amd]

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.

[Former Member]

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