Model-Driven Hana Sync

OBJECTIVES

To migrate the invoice and inventory approval processes from the S4/Hana system to model-driven apps.

CHALLENGES

• Encountered difficulties with integration; the client has multiple layers of security, and since S4/Hana is an on-premise system, their API blocks CORS.
• Issues in design due to the data structure of S4/Hana, which does not use a single ID but rather an ID detected from a set of keys.

SOLUTIONS

• Automate Approval Workflows: Set up automated approval workflows using Power Automate to handle invoice and inventory approvals, reducing manual intervention and increasing efficiency.
• Custom Power Automate APIs: Develop bespoke APIs to handle data interactions between S4/Hana and Model-driven apps, ensuring seamless management of unique ID structures.
• RFC Connector for Direct SAP ERP Connection: Establish direct connectivity with SAP ERP using RFC Connector, ensuring smooth data transfer while bypassing CORS issues.

BENEFITS

• The RFC connector utilized Microsoft’s direct connector through the SAP ERP Connection (a Microsoft pre-built connection).
• This approach avoided CORS issues and also prevented section duplication when calling the SOAP API.