This is one of 4620 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).
Overview
- Industries automotive industry
- Specialist tasks closing, Controlling, group controlling, Reporting
- DV tasks customised software further development
- System environment Client/Server
- Procedure model PTA project manual
- Development/ test tools Visual Basic Editor
- Standard software SAP Interactive Excel Add-in
Project period11.02.2008 - 27.02.2008
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
