Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
AmitSAP11
Explorer
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.

Problem Statment:

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.

Steps:



  • 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.

Results :

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.
1 Comment
former_member820179
Discoverer
0 Kudos
Hi Amit,

Hope you doing good,

Currently i am testing this forward contract transaction tx01/ Mark to market posting and maturity posting.

2.MTM& maturity posting owth accounting entry posting can you help on this its very urgent.

Please treat this its my request. 4 more days left.

 

 
Labels in this area