Automatizace procesů v SAPu pomocí VBA

This bachelor thesis is focused on creating orders, which are received from the company’s webshop into SAP. The aim of this bachelor thesis was to analyse possible “challenges” and conditions that need to be verified, and based on them to subsequently design and implement a macro in VBA, which would be able to automatically create an entire order. Finally, also to evaluate how significant benefit this automation is to the company.The theoretical part of thesis provides with the definitions of the most important terms – such as automation, business processes, system. The business information system is described there and then ERP systems are characterized, with a specific example – SAP. There are also mentioned ways in which SAP can be automated.The methodological part mentions the tools that will be used for the subsequent implementation. Specifically, it is mainly VBA programming language, followed by SAP Script and to a lesser extent Google Apps Script. In the practical part, individual conditions, which may occur in certain situations, are discussed. A process model, which shows how the creation of order looks like is also presented to complement this part.The result is completed functional macro in Excel, which makes the work of logistics department much easier – creating orders is approximately about two thirds faster than creating them manually.