SAP offers the use of IBIP supported objects from within the LSMW to support data transfer.
This abstract explore the “old” option to run transaction IBIP directly with pre made flat files that matches to the IBIP structures and hierarchy, the Excel IBIP tool can be used as an alternative to LSMW.
The IBIP tool generate flat file from Excel in the IBIP required structures ready to be upload to the IBIP transaction.
The IBIP Tool file alternative is to develop ABAP programs that writes from Excel source file to flat file.
The log result in kept in transaction IBIPA.
For large data volumne data migration (S/4 Hana data migration for exemple) it is recomended to upload the flat files to the application server so it will be possible to use parallel processing or/and schedule might jobs
The Tool demo file includes Demo worksheets for several IBIP transaction
can be provide by request by my profile mail
Authorizations– if your requirement is provide simple excel based tool for the end user for master data management and LSMW authorization in the PRD system is not an option
Simple – Use 1 Excel source file also for multi structures ,in the IBIP Tool there is no need to link between the files using key relations between the structures ( Using IDENT1 , IDENT2 etc..) as required by LSMW approach , The Flat file records are written to the flat file based on the location sequence of the structure in the Excel template.
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 which includes also the option to define in advance on which servers the scheduled jobs will be executed for load balancing purpose and also achieve “parallel processing” functionality which speed up data upload , This approach is very helpful when dealing with mass master data update , For exemple if several millions of records can be completed over night (depends on the number of servers in the PRD system ) using this approach .
Exemples for such changes for Functional locations or equipments :
– Mass update class and characteristic
– Mass update of system profile
– Mass update of the Address data ( using structure IBIPBDCD)
Exemple 1 :Create Equipment with user status
Exemple 2 :Create Equipment with class and characteristics
Exemple 3 :General Task list with operation and assignment to maintenance packages
- Microsoft excel 2007- 2013
- Macro enabled
- internet connection – use for product validation
Step 1 – Create template using IBIP Tool excel macro
-Select IE01 – Create equipment in the transaction combo box
– Select the IBIPEQUI structure in the data structure listbox
Step 2 – Fill the created template
Step 3 – Generate the Flat File using
IBIP Tool excel macro
The flat file will Automatically created ( stored in the temp folder )
Step 4 – Upload the Flat File in IBIP Transaction
Appendix – High Volume Data Upload ( Optional ) store the files in the Application server
Another alternative is to store the flat files at the application server which is mostly required when the data migration duration takes
more then several hours (can be used for exemple S/4 HANA data migration is some cases) and it is required to schedule the run at night (when system load is low) , in this case :
-Select the required server in transaction SM51:
– Goto to transaction CG3Z and upload the flat file to the current application server
– Select the application server which the file was uploaded into and select the Phys. file and press on “Execute”
Step 5 – Log Check Transaction IBIPA
For Exemple Lets Check and confirm that the equipment 10006947 created is created with the “0005” status which as displayed in the excel row 4
We can see the result : the equipment 10006947 was created with user status “0005”
IBIP Flat file : Equipment creation with class and characteristics
Goto transaction IBIP – press the information icon to see Structure hierarchy , So you can know which structures are required to your business scenario
Using IBIP Tool Create template using structures IBIPEQUI , IBIPCLAS , IBIPFEAT