All for One EasyInput | SAP integration with MS Excel

All for One EasyInput

SAP integration with MS Excel

A more effective user work due to integration of SAP and MS Excel

All for One EasyInput enables to run business transactions in SAP system (S/4HANA, ERP, CRM, SRM, BW,…) based on the data gathered in MS Excel workbook. It accelerates the user’s work and increases productivity.

The data are processed with a user-friendly MS Excel interface, which significantly improves work and reduces the possibility of errors when transferring information.

All for One EasyInput can be used for:

  • data migration to SAP system
  • uploading the cost distribution lists for costs settlement
  • execution of mass transactions based on the data gathered in MS Excel sheets
  • mass creation or change of master data
  • downloading the data from SAP system

All for One EasyInput provides both a simple (one-step) possibility of export of even the most complex data from MS Excel files to SAP systems as well as the possibility of importing data from SAP to MS Excel workbooks.

What makes the product unique is the comprehensiveness of the support of SAP – Excel integration process. All for One EasyInput provides ready, empty forms for entering and reading the data; generates descriptions and control information for a user as well as prompts concerning possible values that are manually entered in the fields. All for One EasyInput also includes possibility to run in a test mode, user-friendly handling of error messages or protection against the loss of processed data. All of this functions within an intuitive interface that is integrated with MS Excel, with the multi-language support and with the user’s manual available.

All for One EasyInput configuration for a specific application can be done by business users themselves without the support of consultants.

The solution is an out of the box product. It can be used immediately after its installation on a user computer.

To see more presentations and courses dedicated to All for One EasyInput, go to the forum.

Learn more

See the recordings from our webinars

Order free trial

User friendly interface for business users

All for One EasyInput provides both a simple (one-step) possibility of exporting even most complex data from MS Excel files to SAP systems, as well as the possibility of importing data from SAP into MS Excel workbooks. What makes the product unique is the comprehensiveness of the support of SAP – Excel integration process.

EasyInput ribbon menu

All for One EasyInput integrates with MS Excel and adds additional ribbon menu. This contextual menu provides the user with easy access to all product functions.

Migrating data and error handling

The distinction between running EasyInput in test or actual modes allows the user to well check the data, before actually changing anything in the SAP system. As opposed to SAP LSMW, error/success messages in EasyInput are well linked to transfered data. Thus, finding wrong data line and processing only erroneus records is really streightforward.

SAP F4 search help functionality within MS Excel

The SAP search help (F4) functionality is embedded in All for One EasyInput Excel workbooks. This facilitates data entry and limits the number of user errors when preparing data for migration in MS Excel.

Custom formatting of EasyInput documents

All for One EasyInput workbooks can be formatted in order to be more user friendly. This is especially usefull when one uses All for One EasyInput instead of SAP GUI to process transactions. Several custom formatted EasyInput example documents are part of All for One EasyInput installation package. The layout for posting an FI document is a good example here. An example allowing posting FI documents larger than 999 lines is also provided.

Several scripts in one EasyInput workbook and data reading

All for One EasyInput workbooks can contain more than one EasyInput script. This can make using All for One EasyInput even more comfortable. Both uploading data to SAP as well as reading data from the SAP system is possible. Below one can see example of All for One EasyInput workbook hosting three scripts. One of them allows to display financial documents within Excel.

Mixing EasyInput scripts with VBA macros

Thanks to All for One EasyInput API it is easy to mix All for One EasyInput scripts with Visual Basic for Applications (VBA) macros. This can help in building complex scripts that should process data between sending to/ retrieving from the SAP system. Together with the installation pack the user receives examples of such scripts.

Reading data from any SAP table or view

All for One EasyInput can read data from virtually any SAP table or database view. This can be usefull when one needs to retrieve especially custom data from the SAP system. Of course the user retrieving SAP data has to have sufficient authorizations in the SAP system.

Extending EasyInput functions via extensions

By creating custom function modules one can extend standard All for One EasyInput functionality. An example here is an extension developed by All for One Poland to report financial statement in MS Excel.

Order free trial

Whitepapers

News about All for One EasyInput

Recommended offer

Write us Call us Send email






    1. Personal data is processed pursuant to Article 6 (1) (a) of the Regulation of the European Parliament and of the Council (EU) 2016/679 of April 27, 2016 – the General Data Protection Regulation
    2. The data controller is All for One Poland sp. z o.o. with its registered office in Złotniki, ul. Krzemowa 1 62-002 Suchy Las. Contact data of the Data Protection Supervisor: iod@all-for-one.com.
    3. Consent to data processing is voluntary, but necessary for contact. Consent may be withdrawn at any time without prejudice to the lawfulness of the processing carried out on the basis of consent prior to its withdrawal.
    4. The data will be processed for the purposes stated above and until this consent is withdrawn, and access to the data will be granted only to selected persons who are duly authorised to process it.
    5. Any person providing personal data shall have the right of access to and rectification, erasure, restriction of processing, the right to object to the processing and to the transfer of data, the right to restriction of processing and the right to object to the processing, the right to data transfer.
    6. Every person whose data is processed has the right to lodge a complaint with the supervisory authority, which is the President of the Personal Data Protection Office (ul. Stawki 2, 00-193 Warsaw).
    7. Personal data may be made available to other entities from the group that All for One Poland sp. z o.o. is part of – also located outside the European Economic Area, for marketing purposes. All for One Poland ensures that the data provided to these entities is properly secured, and the person whose data is processed has the right to obtain a copy of the data provided and information on the location of the data provision.

    +48 61 827 70 00

    The office is open
    Monday to Friday
    from 8am to 4pm (CET)

    General contact for the company
    office.pl@all-for-one.com

    Question about products and services
    info.pl@all-for-one.com

    Question about work and internships
    kariera@all-for-one.com

    This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.