Menu
This is one of 4546 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
- Branchen automotive industry
- Fachaufgaben closing, Controlling, group controlling, Reporting
- DV-Aufgaben customised software further development
- Systemumgebungen Client/Server
- Vorgehensmodell PTA project manual
- Entwicklungs- und Testtool Visual Basic Editor
- Standardsoftware und BI SAP Interactive Excel Add-in
Project periodProjektzeitraum11.02.2008 - 27.02.2008
Have we sparked your interest?
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
