In this Microhack we will:
- Extract (Historical) Sales Orders from SAP S/4HANA and load this in Synapse
- Upload historical payments from a non-SAP system, in this example Cosmos DB, to Synapse
- Visualize the extracted Sales Orders and invoice data with Power BI
- Predict incoming cash flow forSales Orders
When customers buy goods, the corresponding payments are not done immediatly. Some customers will pay directly and other customers will pay at end of the payment terms. This makes it diffucult for companies to predict the incoming cashflow. In this simplified exercise we'll use Azure tooling to predict the incoming cashflow. For this we need data on past Sales Orders and past payments. The Sales Order information we'll retrieve from an S/4HANA system. For the payments we assume these are kept in a non SAP system. This non-SAP System is represented by a Cosmos DB.
The implementation steps beneath assume you've setup a S/4HANA system based upon a SAP S/4HANA Fully Activated Appliance 1909 or 2020 image from SAP CAL. Also a Cosmos DB were the corresponding payment data is uploaded is assumed to be available.
If you want to setup your own SAP CAL system and Cosmos DB, follow the steps at MicroHack Setup.
To execute the Microhack follow the steps below: