Our company is looking for experienced VBA developers with a knowledge and understanding of SAP landscape integration via SAP BAPI (Business Application Programming Interface). Our projects essentially require VBA and Excel skills as the end product is an MS Excel application designed for SAP users and/or Business Analysts. The SAP connectivity capabilities are brought by our Excel Application development tool, for which we provide an access and a training session for the selected freelancers. Our SAP experts are available for questions. You can find more information on our finished product on: [url removed, login to view]
Product Network Analysis (Excel Application - expected timeline is 4 to 5 man days over 1 to 2 weeks):
VBA Excel development within our Excel Application development environment
From a "Selection" worksheet, the user selects one products and executes the application, in network, hierarchical or geographical mode via an execution button provided in a custom ribbon. The product list is directly imported from SAP database via our Excel Application Development tool.
- In network mode: the result is a network display of the product structure as defined in SAP, according to the Bill of Material (BoM) and transport connections between locations where the product is stored
- In hierarchical mode: the result is a hierarchical display showing the relevant locations and BoM
- In geographical mode: the result is the distribution structure of the product
The above-mentioned results are displayed in a "Result" worksheet. Location Master and BoM data will be read via BAPI (with the support of our development tool) and organized according to the user-requested representation (network, hierarchical, geographical).
From any of the previous result display, the user can drill down a product location to access Stock position of the product by calling another existing Excel application (MD04).