SAP-Data structure conversion

Data for various production plants from SAP was exported as an Excel file, as a result of which leading zeros were lost in the article numbers. However, these were automatically added during my further processing. Each article was initially available with a single data record, with the “Plant” field containing a semicolon-separated list of the plants involved. From this data, my tool created a separate data record for each combination of article number and plant. This newly structured form made it possible to reference other data pools such as work plans, tools, parts lists and quantities produced and delivered. By entering a date range, quantity and cost data for this period could be added automatically. Once the process had been created once, it could be repeated by employees at any time.