We shall take simple scenario for SAP with MS Excel connectivity. Analysts who want to combine data from SAP and other enterprise data stores for budgeting purposes.Managers who want to track projects and status automatically as they receive status e-mails.Production and Logistics Managers who want to create Excel reports from latest SAP data.Avoids any data-integrity issues with copying and reduces compliance issues.
#HOW TO WRITE A MACRO IN EXCEL TO QUERY THE WEB UPDATE#
Allows the users to update SAP from within Excel, Outlook and Word. Enables users to query and update SAP transactions from within Outlook screens. Enables users to get real-time data from SAP within Excel with a single-click Refresh. Eliminates cut-and-paste based data collecting mechanism from SAP to Microsoft Excel. SAP-MS Office Connectivity extends data from SAP to Microsoft Excel, Microsoft Outlook and Microsoft Word using a SOA based Information Delivery Server and Microsoft Office Add-ins, and provides the following benefits Manually update data from Excel Spreadsheets to enterprise applications.īenefits of Data from SAP to Microsoft Office Applications. Switch screens from Outlook to gather data and take decisions as they respond to e-mails. Use error-prone cut-copy-paste to populate their Excel spreadsheets. Since Microsoft Office Applications are not connected to SAP, users are forced to In spite of large moneys in SAP, most business users continue to be unsatisfied with it because data from SAP is not easily accessible in their favorite desktop productivity tools - Microsoft Excel, Microsoft Outlook and Microsoft Word. 
Why Data from SAP to MS Office Applications Here we have a simple application to connect SAP with MS-office tool’s Excel. With the SAP-MS Office connectivity, end-users can interact with SAP transactions directly within their Excel spreadsheet, their Outlook e-mail screen, and their Word documents and on their Power point presentations. Using the connection SAP with MS Office, users spreads data from SAP application to right within Microsoft Office desktop applications, including Excel, Outlook, Word and Power point.
0 kommentar(er)
