Deriving the Translation Date from Document Date – Step by Step TRM
The SAP Folks have been working on the TRM project.
This was useful in a case when we need to migrate data from SAP FI/CO to SAP TRM with changed translation date.
The translation date was incorrect in the TPM20 transaction code. This was because we were migrating old documents via Transaction code TBB1(Treasury Post Flow ) Transaction in SAP TRM module.
While posting the records to SAP TRM via transaction code TBB1 the translation (WEERT) was getting defaulted to the current date as expected in SAP TRM.
But as we were migrating old documents from SAP we do not want to change any transaction date as this is incorrect.
To achieve that we had implemented a BADI TPM_ACCIF_TRAC and tried to change the Translation date and document date together in the method IF_EX_TPM_ACCIF_TRAC~ACCIT_BLDAT_EXIT
But it was not successful only document date got changed but Transalation date change was unsuccessful.
To achieve the translation date change we had implemented the method IF_EX_TPM_ACCIF_TRAC~ACCIT_EXIT and bingo…. it worked 🙂
Explanations of date terminology used in this blog.
BUDAT: Posting Date (date when the document is posted)
BLDAT: Document Date/Invoice Date (date when the document is entered/parked)
WWERT: Translation Date (the date used to pick the exchange rates)
Requirement: The requirement was to derive the translation date from the document date.
Solution: This solution was achieved by implementing the BADI TPM_ACCIF_TRAC (SE18)
Conclusion: We can change the translation date and document date with the help of BADI implementation.
In the BADI documentation, there is no mention of the Transaction date change but we can achieve this with method IF_EX_TPM_ACCIF_TRAC~ACCIT_EXIT.
- Create an implementation for TPM_ACCIF_TRAC and implement via a Z class in Se19
- Implement the method IF_EX_TPM_ACCIF_TRAC~ACCIT_BLDAT_EXIT
- The class name is hidden to avoid any copyright violation
Change the document date ch_accit_bldat Here the translation date change will not work.
- Implement the method IF_EX_TPM_ACCIF_TRAC~ACCIT_EXIT
Change the translation date WWERT .There are two one for vendor and for customer.
ch_accit_c–wwert = ch_accit_c–bldat.
ch_accit_d–wwert = ch_accit_c–bldat.
Transaction code TPM20
Now the document date and translation date both got changed.
We have bypassed the standard logic which was getting defaulted to the current date.
This implementation was deactivated after the migration is completed.
I hope it’s useful for SAP TRM folks who are struggling with this kind of issue during migration work.