RAP Application EMail Template CDS Data Source picks...

[#1]

I have a RAP Read Only application with a button made with CDS Custom Entity.
This throws a popup with value help for user to pick a new departmentcode.

At the METHOD save_modified I am calling the email template created in SE80, the CDS view in email template is the Root CDS View which joins my custom table with sales tables.

The custom table has new departmentcode field which is getting updated.
How do I get the new departmentcode in email CDS instead of old departmentcode please?

[sravan_aleshwaram]

Hello @sh4il3sh 

The email template is likely reading data directly from the CDS view before the updated department code is committed to the database. In save_modified, the new value may exist only in the transactional buffer.

To get the new department code in the email:

Read the updated value from the RAP transactional buffer (entities) instead of the database.
Or trigger the email after successful save/commit so the CDS view reads the latest persisted data.
If using a CDS-based email template, ensure the updated record is committed before the template is generated.

Thanks,
Sravan