Inspiration

Crisis can be powerful sources of inspiration...

Through my family in Spain, I was direct witness for the collapse of the sanitary system during COVID-19. People were deeply desperate -and depressed-, due to the impossibility to buy FFP3 masks for infected persons, in order to protect other family members from an infection. I know several families in which almost all members were infected by one single person. All that nice hand-made masks do not help in such situations. FFP3 standards become necessary.

Even sending masks from Germany to Spain was forbidden by the Spanish government, to stop the speculation, exploding black-market and price gouging.

Many of us had the sensation that Spain was thrown back to the middle age times.

And all that time, I could not stop thinking about, how easy all the solutions were, which I ideated, designed and in part developed for SAP systems in purchasing and SCM area (eBay integration with Catalog, Spot Quote for Ariba Network, One-Click Shopping Cart, SRM Sourcing Cockpit Integration with Ariba Network...). None of them were rocket science and almost all belong now to the standard product of SAP.

- Would it be possible to deliver any analogue technical solution to solve or at least to mitigate this issue?

- And if so, would it be possible to measure the effect of such a solution to the reduction of the problem?

What it does

The solution here intends to answer exactly that questions. It is basically a public platform to...

  • easily report product demands at the consumer level (hospitals, retirement homes, supermarkets, public institutions, offices, NGOs, etc.)
  • forecast the demand plan for selectable critical materials (demand plan calendar)
  • identify geographical gradients of the demand which could be balanced (demand plan map)

Who should use it?

  • Demanding organizations - to report demand plans
  • Material requirements planners - to identify when to increase production rate
  • Logistic companies - to identify regional gradients and estimate the probability of last-minute plan changes per region
  • Health authorities and governments - to monitor the demand evolution and degree of fulfillment and identify on time the need of measures

How I built it

  • The platform is done using the SAP HANA Express Edition, sitting on a Google Cloud Platform.
  • A small database for Demands has been created in the ABAP Data Dictionary.
  • A REST service is reading and writing on this database
  • The service is being called out of a web browser using a UI5 user interface

Challenges I ran into

Still on it... (24-Mai-2020, 8:30)

Accomplishments that I'm proud of

  • The easy, intuitive application, running in few clicks
  • Possibility to integrate it later with > 150.000 Companies using SAP SCM and other non-SAP products due to the usage of standard exchange.
  • Usage of United Nations conform material categories

What I learned

Still on it... (24-Mai-2020, 8:30)

  • Installed for the very first time GCP and SAP HANA Express.
  • Tried for the very first time to integrate GIS data and APIs

What's next for SCM Demand Plan Public Platform

  • Pretotype creation and check with potential user-organizations
  • Sending RfQs (requests for quotation) to a group of selected supplier companies in order to accelerate the provision and minimize so availability discontinuities.
  • Solving some technical themes, which were too time intensive for a Hackathon format
  • Moving the classic ABAP selection to a CDS view for a much higher performance
  • Studying the possibilities to increase the granularity of the UN material categorization
  • Discussion with health authorities, if individual persons should be able to post demands or not
  • Introduction of standard schemas for demand data and a header/item structuration instead of only a header level

Built With

  • abap
  • fiori
  • google-cloud
  • iaas-gcp
  • paas-sap
  • sap-hana-express-edition
  • sap-webide
  • ui5
Share this project:

Updates