Creating internal machine configuration and sales price lists
Project duration: 8 months
Brief description
The machine configuration and sale price list consists of the combination of SAP master data that can be output to SAP clients with an SAP GUI when prepared as an Excel XML document. The Excel folder created here is used as an electronic document and as a printout.
Supplement
After the predecessor solution increased the application's processing speed with combined ABAP/VBA functions, its performance must now be further increased for large data volumes. The improvement will be achieved by carrying out the data collection, preparation and alignment within the individual table sheets directly in XML elements in ABAP, using ABAP objects and the SAP XML library. By creating data in the form of an ML spreadsheet, it is possible to avoid using VBA code to a large extent. This makes it possible to significantly enhance the performance further.
Subject description
The system environment consists of the server and client sides. SAP R/3 ECC Basis 7.0 is used on the server side: the document management system integrated in SAP is used to store the Excel template and other Excel files. On the client side, SAP GUI 6.40 is used with the Windows XP Professional / Vista operating system with Microsoft Office 2003 / 2007.