Custom Email Template for Email Integration for Purchase Requisition Approval in SAP S/4HANA

Introduction:  

In this blog, the steps outlined for setting up Custom Email Template for Purchase Requisition (PR) Item release with email Integration. This will help us set up an Email Header and Body as per Customer requirements. The SAP S/4HANA system can be configured to notify approvers via email about new work items in their inbox. By default, the approvers are informed by means of notifications in the SAP Fiori Launchpad. Sending emails provides them with an additional notification channel.

SAP BW Extractor ( DataSource) based on HANA Model

In this blog, I would discuss how can we load data from HANA models/Database Procedure  to BW DataSource based on Function Module.

Scenario 1 : 
You have a HANA model which gives you  every day snapshot of open order / delivered order in real time . You want to store the data somewhere  to see trend over time.  Reporting security is implemented in BW side and you want to reuse that .You also want to use Master Data / Text available in BW.

Scenario 2: 
You have BW on HANA and HANA native in same database , and there is hybrid data model which uses data from both BW Schema and HANA native schema.  If the tables are small , you might pull the data by  some way and build your model in BW . However, if the tables are big and requirement is not straight forward, a calculation view can be handy and comes with great performance benefit by using Input Parameter.  We can also model very complex requirement by using  stored  procedure or Script Based Calcuation view.  But , for some reasons we want data to be persisted in BW , like business wants Key and Text side by side for variable help values which still does not work well in native HANA.