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 4813 IT projects that we have successfully completed with our customers.How can we support you?
SAP R/3 – Office integration (Excel)
Project duration: 4 months
Brief description
New development of a general interface, which can create individually formatted tables from SAP R/3 in Excel. New Excel tables can be generated or existing templates can be used. The motivation for this component is the desire to generate individually designed (fonts, company logo, graphics etc.) reports in SAP R/3. Furthermore, this inside-out variant allows the data from SAP to be further processed and evaluated independently of SAP.
Supplement
The data is selected in SAP R/3 and transferred via an OCX file (OLE2 component) to an external tool (e.g. MS Excel) for further processing. This "inside-out variant", which uses OCX controls, allows methods and properties to be called in ABAP objects. The following data types can be exchanged between SAP R/3 and the OCX: string (up to 65,000 Byte); number (long, integer); date (date and time).
IT project data
- Industries services
- Specialist tasks Reporting, system integration
- DP tasks standard software development
- System environments component technology, standard software: ERP systems
- Procedure model Rapid Prototyping
- Programming languages ABAP Objects, VBA
- Operating systems Windows 2000, Windows XP
- Standard software and BI SAP R/3
Project period01.05.2004 - 31.08.2004
Customers who trust us
