We are a consulting company specialising in SAP services, IT outsourcing and software development. We support our clients' businesses. That is the reason for our motto to be: IT makes business better

We are part of SNP Group, world leader in transformation of SAP environments

Since 1995 we have successfully accomplished hundreds of IT project in many countries worldwide.

Our experts present the most interesting solutions of IT world.

See the webinar archive, register for upcoming webinars.

Dlaczego uważamy, że SNP jest dobrym pracodawcą? Bo łączymy cechy rzadko spotykane w jednej organizacji - duże możliwości rozwoju, a zarazem dobrą atmosferę i elastyczność środowiska pracy. Dowiedz się więcej, na czym to polega w praktyce!

SNP EasyInput: a faster migration and easier work with SAP

SAP integration with MS Excel and more

Share
Situations where employees spend hours tediously copying data from Excel to SAP systems happen frequently in many companies. Checking for and correcting errors that occurred in this process – it also takes a lot of time. And if we want to import data from SAP systems to MS Excel workbooks or migrate data from other IT systems in the company to SAP? Does it have to mean many hours of work for our employees?
 

Better employee self-service

Working with SAP systems, employees most often use a traditional user interface – the SAP GUI client application. Although this interface was created a few decades ago, it still has many advantages; therefore users are reluctant to switch to newer forms of working with the system, such as the NetWeaver Business Client or SAP Fiori interface based on the HTML5 browser standard.  At the same time, a large amount of data to be entered into the system is stored or delivered in MS Excel files. Some users’ tasks consist in copying data from this tool to the SAP system. To meet users’ expectations, we have prepared a solution at SNP cthat increases employee productivity by enabling data to be entered directly from MS Excel files to SAP.

SNP EasyInput allows the user to “record” transactions executed by him on a mass basis, to easily link a recording with an MS Excel file and then to repeatedly perform the same operation based on the data stored in the workbook. The recording does not need to refer to a single transaction. It may contain a sequence of tasks to be performed in the SAP system for the ...

Better employee self-service

Working with SAP systems, employees most often use a traditional user interface – the SAP GUI client application. Although this interface was created a few decades ago, it still has many advantages; therefore users are reluctant to switch to newer forms of working with the system, such as the NetWeaver Business Client or SAP Fiori interface based on the HTML5 browser standard.  At the same time, a large amount of data to be entered into the system is stored or delivered in MS Excel files. Some users’ tasks consist in copying data from this tool to the SAP system. To meet users’ expectations, we have prepared a solution at SNP cthat increases employee productivity by enabling data to be entered directly from MS Excel files to SAP.

SNP EasyInput allows the user to “record” transactions executed by him on a mass basis, to easily link a recording with an MS Excel file and then to repeatedly perform the same operation based on the data stored in the workbook. The recording does not need to refer to a single transaction. It may contain a sequence of tasks to be performed in the SAP system for the specified data records. Wherever data is entered into the SAP system on a mass basis, SNP EasyInput can reduce the user’s workload, increase his productivity, and minimize the number of errors occurring when data is copied to the standard SAP interface.

Migration

It is often necessary to migrate data to the SAP system from other IT systems. Mostly, the data to be migrated is in the form of files that can be opened with MS Excel. This allows for visual verification of this data, manual corrections of migrated data, if necessary, and the use of SNP EasyInput in the migration process. Instead of the tedious configuration of the standard SAP tool – LSMW, the creation of SNP EasyInput scripts can be quick and easy. You can start recording scripts directly in MS Excel. For more complex processing functions, you can use Excel formulas (no programming required). As a result, it may take a dozen or so minutes instead of several hours to create a migration workbook. A migration test mode makes it easy to verify the data before actual migration, and the clear indication of a data row that needs to be corrected speeds up the process of input data cleaning.

A business user-friendly tool

SNP EasyInput is designed to make data entry via the MS Excel interface as convenient as possible for the user.  It is therefore possible to use the standard SAP help known from the SAP GUI tool. The data entry can be also supported by the standard MS Excel functionality of selecting from the list of available values. The data entered can be validated quickly in terms of data format, length of data entered, or completion of all required fields.

SNP EasyInput integrates with MS Excel, adding its own menu ribbon. The ribbon elements changing depending on the context allow for all key functions of the product to be easily accessed.

SNP EasyInput allows you to execute a script in the test or live run. In this way, the data can be safely checked prior to uploading them to the SAP system. The option of script execution only for records that were previously wrong speeds up the data correction. This is especially important in the preparation of large data volumes for migration.

Technical capabilities of the tool

In version 3.X SNP EasyInput supports three integration technologies:

  • recording of SAP GUI actions (SAP GUI scripting),
  • batch processing of Batch Input/CATS transactions,
  • calling up of SAP function modules (e.g. BAPI modules) remotely.

Depending on the level of technological knowledge, the user can use the first two integration options (dedicated to the business user, involving the recording of SAP transactions) or opt for advanced configuration using the BAPI interface. SNP EasyInput is being continuously developed and we plan to add more Excel-SAP integration techniques in the future.

With the SNP EasyInput application interface (API) you can easily connect macros of the Visual Basic for Applications (VBA) language with the functionality of the product. This facilitates creating complex workbooks processing data between script calls in the SAP system. The installation package contains several scripts illustrating this functionality.

And even backwards

In addition to entering data into the SAP system, SNP EasyInput can retrieve data from SAP transaction screens, read them using function modules, and even retrieve data from any table or view of the SAP database. This can be particularly useful when reading user-specific data. To be able to read data from tables, the user must have the required permissions.

Try and buy

At SNP, we are strongly confident that anyone who uses the SNP EasyInput solution once will want to use it on a daily basis. For this reason, we have prepared a trial version of SNP EasyInput. On our website, in addition to the product description, you can find a variety of informational and training materials in the form of presentations and video recordings. They will enable you to learn on your own about even complex features offered by the product. Try it today.

SNP Customer #1
Faster migration of files and fewer errors

After the period of testing, a Polish media company the Onet.pl Group, part of the German-Swiss Ringier Axel Springer Media AG Group, purchased EasyInput, an original SNP solution that enables SAP systems to be used more efficiently at a low cost.
Paweł Wojciechowski, Deputy Director of Finance at the Onet.pl Group sums up: “The data migration process in the corporate SAP system implementation project was carried out using the EasyInput tool. This allowed us to significantly speed up the preparation of migration files and to reduce the number of errors in these files. Testing of the individual migration stages turned out to be much easier and we could complete the whole process in less time than using standard methods.”

SNP Customer #2
Automation, optimization, savings

One of the leading companies in the meat industry decided to purchase SNP EasyInput to enable it to automate the labor-intensive activities related to transferring data in various forms to SAP systems. The optimization of these processes increased the efficiency of employees and thereby reduced the costs.

SNP Customer #3
Time is money
A Swiss manufacturer of products and systems for the power generation, transmission and distribution uses SNP EasyInput when entering its payroll into the SAP system. This significantly reduced the process of preparing salaries and wages for employees and eliminated human errors.

Get access till Whitepapers

Full version of whitepapers is available after login.

Login Register

Read this whitepaper in other language

The same content is available in other language:

See the whitepapers - Polish

See the whitepapers - German

Share

Would you like to read the full story?

Log in to Better Business!

138
WHITEPAPERS
9197
USERS

Contact form





  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 SNP 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: dpo.pl@snpgroup.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 SNP Poland Sp. z o.o. is part of – also located outside the European Economic Area, for marketing purposes. SNP 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.

Please write an email or call

E-mail office.pl@snpgroup.com
Phone +48 61 827 7000

SNP Poland Sp. z o.o.

Headquarter:
Złotniki, ul. Krzemowa 1
62-002 Suchy Las near Poznań, Poland

How can we help?
Write us
Send email
Call us





  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 SNP 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: dpo.pl@snpgroup.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 SNP Poland Sp. z o.o. is part of – also located outside the European Economic Area, for marketing purposes. SNP 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.

General contact for the company
office.pl@snpgroup.com

Question about products and services
info.pl@snpgroup.com

Question about work and internships
kariera@snpgroup.com

+48 61 827 70 00

The office is open
Monday to Friday
from 8am to 5pm