Was this page helpful?

Move data between your SAP and Excel with ease – use the application you already know and stay productive.

Liquid UI connects the hole between your SAP and Excel by enabling you to work from familiar interfaces to handle data in and out of SAP. Liquid UI for Excel allows you to record data in Excel, utilize Excel´s formulas/macros to perform the computations as needed and then upload the data to a given SAP transaction with a single button click. It enables you to extract data from a given SAP transaction and modify/analyze it in Excel while providing error handling and data validations.


Liquid UI for Excel - SAP MM
Liquid UI for Excel - SAP MM

Features

  • Enter, change, and extract bulk data from SAP using Excel
  • Create Excel, Word, Access, and PDF files
  • Check spelling via Microsoft Word
  • Accept POSTed forms from PDF files
  • Identify/flag all user mistakes during data entry process
  • Record, edit and construct SAP transactions

LEARN MORE THROUGH SGM SUCCESS STORY >


Liquid UI for Excel in Action

Sales & Distribution Module

Liquid UI for Excel allows customers to record data in Excel and then do a mass upload to a given SAP transaction. Liquid UI for Excel also enables customers to extract data from a given record or transaction and modify it in the familiar interface of Excel, while providing error handling for the subsequent upload back to SAP.

Example: A user might want to create a promotion where the top one hundred customers will receive a promotion containing the same materials, the same pricing and the same shipping information. The customer could use Excel to enter the data for each customer, and then click a single button in SAP as shown below to perform a mass upload of the data to SAP.

Benefits: A SAP user is enabled to create the same kind of data for all customers in SAP. For example, in the scenario described above, the SAP user can use Excel to quickly and easily copy in the data for the customers´ materials, quantities, shipping information and sales organizations using Excel´s copy functionality since this data will be the same for all customers. Then once all the data is input into Excel, the single click of a button in SAP initiates the mass upload of data to SAP. Any errors will be caught by Liquid UI for Excel´s built-in error handling mechanisms, prompting the user to correct the data before errors are introduced in the data stored in SAP.

Liquid UI for Excel - SAP MM

Finance Module

Liquid UI Office enables customers to input multiple financial transactions into SAP, or who wish to extract data and modify it outside of SAP in the familiar environment of an Excel spreadsheet. Like the previous example utilizing the SD module, this is also convenient for finance users to input or extract data to and from SAP.

Example: A user might have a spreadsheet that contains data related to a financial transaction which needs to be reconciled to the data contained in SAP. In the spreadsheet, the user can modify any values necessary, using Excel´s macro capabilities. Then the user would need to simply navigate to the correct screen in SAP and once again, a single button click would upload the data from Excel to SAP. As in the SD example, any errors would be caught by Liquid UI Office´s error-handling mechanisms.

Benefits: A SAP user is enabled to create the same kind of data for all customers in SAP. For example, in the scenario described above, the SAP user can use Excel to quickly and easily copy in the data for the customers´ materials, quantities, shipping information and sales organizations using Excel´s copy functionality since this data will be the same for all customers. Then once all the data is input into Excel, the single click of a button in SAP initiates the mass upload of data to SAP. Any errors will be caught by Liquid UI for Excel´s built-in error handling mechanisms, prompting the user to correct the data before errors are introduced in the data stored in SAP.

Liquid UI for Excel - SAP MM

Try free for 30 days.

Get started with Liquid UI for SAP GUI (SDK) today. When you sign up for SDK, you get Liquid UI Server and Designer so you can start customizing your SAP in minutes. With customized SAP, you can improve your performance, usability and productivity right away.

QUESTIONS? OUR REPS HAVE ANSWERS. 1-650-341-3310


Send us a request to get your Liquid UI for SAP GUI (SDK) free trial: