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).