Excel IBIPTool Brings an Easy and comfortable Way to use SAP directly from Excel
allowing non-IT people to create Excel workbooks for data migration to an SAP system.
You can execute PM master data ,Journal entries, create QM notification, maintain HR records, download data from SAP transactions,
upload long text, classifications, and thousands of other SAP processes.
It is freely used for 30 days, which is usually enough time for trying its functionality.
• Record transaction from SAP directly from Excel without having to use any other applications.
• Run SAP directly from Excel without having to use any other applications.
- ✓ The Transaction add-in enables users to:
- ✓ Record any desired transaction from within the Excel
- ✓ Manage recording template libraries from Excel on order to save time
- ✓ Edit recording, as well as define loop for tabular fields
- ✓ Fill error-free master data to the created table, with the help of embed SAP search help
- ✓ Validate the data before uploading it to SAP
• Can load two transactions from a single Excel row
• Pre-checks before load data to SAP
• Supports long texts in a more effective way than other recordings approach
Recording any transaction right from ExcelIBIPTool Recorder provides unique functionality comparing other software of recording any desired transaction right from Excel .
Manage recording template libraries (CSV files) from Excel on order to save time and reduce errors.
Automatic Template generationColumn Headers are generated automatically and filled with the fields labels which was filled during recording
With the mapper it is possible to edit recording, as well as define loop for tabular fields ,remove unnecessary script lines
Fill from the mapper the record transaction values to first line to the excel template
Error HandlingThe distinction between running IBIPTool Recorder 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 IBIPTool Recorder are well linked to transferred data.
Thus, finding wrong data line and processing only erroneous records is really straightforward.
Result logIn the first column the running result is returned including the loading timestamp and system which used Intuitive colors to identify the errors and reprocess them as required .
The log file can be save at customer directory as required
SAP to ExcelIBIPTool Recorder can read data from virtually any SAP transaction .
This can be useful when one needs to retrieve especially custom data from any the SAP transaction without requiring technical knowledge of the SAP database tables or requiring developer assistance to pull data from the SAP system
Excel IBIP Tool – Easy upload PM master data
SAP offers the use of IBIP supported PM objects from within LSMW to support data transfer or ABAP development to create the IBIP required formats for data migration projects or massive data update
This abstract demonstrate excel based tool which utilize IBIP Functionality from office excel comfortable user interface and support massive data include pre load test and step by step functionalities.
Option 1 – Flat files – IBIP Tool flat generates from excel flat files(*.txt) that matches to the IBIP structures and hierarchy ready to upload using IBIP transaction
Option 2 – RFC: Connect to SAP (using CCo Connector) using IBIP Function Module and contain at the following functionalities
– Test Run before upload
– Debug Test (Step by Step option)
Option 1 – Flat Files upload to IBIP transaction
step 1 – Create Excel Template
Double click to slect the IBIPSTAT structure which holds the user status data
Download now for 30 days free trial
KO01 Create Internal Order
Less training, fewer mistakes and greater user acceptance of SAP. Interactive demo
Business hoursMonday through Friday
9:00 a.m. to 6:00 p.m.
Simplified and efficient integration of SAP and MS Excel
SY-BRIGHT LTD in-house developed house IBIP Tool enables to run business transaction in SAP.
it accelerates the users 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