Expansion of the existing automatic SD order creation system. Preparation of Excel files with different structures for automatic SD order creation.
Supplement
The process for creating SD orders using the standard BAPI remains unchanged. Only the preparation of the raw data provided by the customer into the SAP structure for the automatic creation of SD orders has been automated.
Subject description
The customer uses SAP SD to create SD orders. Previously, orders were created automatically by importing a .csv file prepared by the customer. This file was imported into SAP, checked, and used to create orders via a standard SAP BAPI. Orders were created for each customer and split number. Since preparing the .csv file was very time-consuming and error-prone for the customer, the creation of the .csv file was automated. In the future, the raw data from the customer will be imported into SAP, prepared, enriched with additional information, and stored in SAP. Changes to quantities or prices can be made. Similar to the manual checklist, there is a dashboard that shows the status of the input files for monthly billing. The further development builds on the existing order creation process so that it can continue to be used.