Connect Microsoft Excel to SAP Using ODATA Service Created for Fiori App

828 results

  1. Reconsidering RISE with SAP

    Since RISE with SAP was originally released in 2021 much has changed. What was then seen as an essentially unknown business-transformation-as-a-service offering that was based around SAP S/4HANA Cloud is now the center of SAP’s plans for cloud ERP. RISE with SAP is also at the center of SAP’s newly announced Joule embedded AI and…

  2. Use and Explore a Microsoft Excel Spreadsheet File Directly in SAP BusinessObjects Explorer 4.1

    Learn how to use a feature of SAP BusinessObjects Explorer 4.1 by following step-by-step instructions for uploading a Microsoft Excel spreadsheet file into SAP BusinessObjects Explorer and then exploring the data included in the file. Discover how to make data residing within an Excel file available so that it can be explored with the creation…...…

  3. Report Design from Start to Finish with the SAP APO Demand Planning Add-In for Microsoft Excel

    Learn how to create reports in the new SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel from scratch. Follow a use case to help you understand the prerequisites for using this functionality. Key Concept The SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel provides a…...…

  4. Report Design with the SAP APO Demand Planning Add-In for Microsoft Excel (Part II)

    Learn how to format a report created using the SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel using the SAP Enterprise Performance Management (SAP EPM) formatting functionality. Key Concept The SAP Advanced Planning and Optimization (SAP APO) demand planning add-in for Microsoft Excel is partially based on SAP Enterprise Performance…...…

  5. SAP BusinessObjects Planning and Consolidation for SAP NetWeaver or Microsoft: How They Differ

    Compare the SAP BusinessObjects Planning and Consolidation, version for Microsoft and the SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver environments, and examine the strategies associated with this technology. Review the concept of the platform as the main issue behind a company’s reason for implementing one of these versions because of data integration issues,…...…

  6. The Office Document Toolbox for Creating RTF Documents and Spreadsheet Files Using ABAP: Part 2 — Reading and Writing Excel Documents

    As an alternative to using the COM interface (which can be cumbersome) for creating Microsoft Word and Excel files in ABAP, you can use the Office Document Toolbox, an open-source solution, to create word processing documents in Rich Text Format (RTF) and spreadsheets in Excel XLS format. Learn how to read and write Excel files…...…

  7. Connect Microsoft Excel to SAP Using ODATA Service Created for Fiori App

    Reading time: 1 mins

    Excel is an easy-to-use reporting tool often used by companies to present their key performance indicators. This blog will help you reduce number of clicks per report by at least 20 by demonstrating step-by-step how to connect Microsoft Excel to SAP using operational data service created for SAP Fiori. This content is for SAPinsider Monthly…

  8. 10 Ways Microsoft Excel® Can Speed Up Your SAP® Processes & Improve Data Quality

    While many companies currently use Microsoft Excel in their data processes, it is often done in a time-consuming and manual manner. Companies are continuously looking for ways to get work done faster, improve data quality and make an impact within their organization. In this eBook, learn how companies have leveraged a tool they’re already using…...…

  9. Link SAP Payslips to Your Excel Payroll Reports

    When you are viewing SAP payroll reports, they often make more sense when viewed side-by-side with employees’ payslips. This adds context and makes payroll reports much easier to understand. Learn a simple way to link payroll reports to employee payslips with short macros in Excel using Visual Basic for Applications (VBA). No ABAP code is…...…

  10. Experience the Next Level of Forecasting the Future Using Xcelsius Dashboard Applications

    Xcelsius dashboard applications present facts graphically, providing insight that helps in making business decisions. However, the future is uncertain and decisions should take that into account. Learn how Xcelsius can transform business facts into statistically valid probability models that give a more accurate view of the future using Monte Carlo simulation techniques. Sample code is…...…