This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4842 IT projects that we have successfully completed with our customers.How can we support you?
Support in the SAP Interactive EXCEL environment
Project duration: 16 days
Brief description
The project involves adding further presentation sheets and functions to an existing Excel file that (with the help of SAP Interactive Excel) calls data from SAP in order to present the annual accounts.
Supplement
SAP Interactive Excel can be used to evaluate data for consolidation with MS Excel's table calculation functions, via an online connection to the R/3 system. This data is called with the help of matrices. The presentation sheets that are created are linked to various matrices via (column) references. The presentation sheets correspond to a specified layout and contain validations with values from other sheets. Furthermore, VBA programming is used to filter and sort the data.
Subject description
In order to present the annual accounts, sheets have to be created according to a specific layout and these sheets have to call data from various sources (SAP R/3, manual input, other Excel files).
IT project data
- Industries automotive industry
- Specialist tasks closing, Controlling, group controlling, Reporting
- DP tasks customised software further development
- System environments Client/Server
- Procedure model PTA project manual
- Programming languages VBA
- Development and test tool Visual Basic Editor
- Standard software and BI SAP Interactive Excel Add-in
Project period11.02.2008 - 27.02.2008
Customers who trust us
