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 (needs RFC Authorization) Connect to SAP IBIP from directly from Excel with any manual action required in the SAP system , SAP GUI installation is not required with the following additional functionally:
– Test Run before upload ( Required SAP GUI installed in the Client )
– Debug Test (Step by Step option)
Option 3 (New) – IBIP tool recorder and runner supports recording any
transaction and upload the data to SAP includes : test run before upload ,
Debug ,Template management and more.
Examples for pre made templates can be provided by request to my profile mail.
- Microsoft excel 2007 – 2019
- Macro enabled
- SAP GUI installed ( for step by step and recording functionalities)
Test Run– Identify error before upload improve the data quality in the system , this option is available at option 2 and option 3 .
Save time – Auto template builder support easy multi structures data entry, using the IBIP Tool there is it is easy to create link between structures ( Using IDENT1 , IDENT2 etc..) ,
Schedule runs at night Jobs – by splitting the flat file to several flat files we can use the IBIP program to upload the data in a schedule job
All in One – Record and Run and transaction from the Excel IBIP Tool to support transaction which are not supported by IBIP like : IP02 , IA06 etc
Out of the Box solution – No need in ABAP developments , based on the IBIP long proven transaction
Flat Files upload to IBIP transaction
-Select IE01 – Create equipment in the transaction combo box
– Select the IBIPEQUI structure in the data structure listbox
Step 2 – Fill the template with the required data
Step 3 – Generate Flat file from the Excel custom button
Step 3 – Upload the Flat file from step 3 to IBIP Transaction
Select the created file from the flat file selected folder and press in the IBIP transaction
Step 4 – Check the Log – the log for the IBIP processing is available at transaction IBIPA