Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 29, 2016 at 02:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 08:45 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2016 at 05:02 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2017 at 08:50 AM

    Hi Selva,

    Please take a look at Class CL_UJP_CURR_CONVERSION and table UJP_STAMP_CT.

    Regards,

    Gersh

    Add comment
    10|10000 characters needed 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.