Skip to Content
Technical Articles

Excel IBIP Tool – Easy upload PM master data

ABSTRACT

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 3 (new) – Transaction module – Using RFC the tool supports recording any
transaction and upload the data to SAP includes : test run before upload ,
Debug ,Template management ,

Exemples for pre made templates can be provided by request to my profile mail.

Pre requirement

  • Microsoft excel 2007 – 2019
  • Macro enabled
  • SAP GUI installed ( for step by step and recording functionalities)
  • Download

 

BENEFITS

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

 

Option 1 –  Flat Files upload  to IBIP transaction

 step 1 –  Create Excel Template   /wp-content/uploads/2015/03/ice_screenshot_20160116_145312_869152.png

  -Select IE01 – Create equipment in the transaction combo box
 Select the IBIPEQUI  structure  in the data structure listbox

/wp-content/uploads/2015/03/ice_screenshot_20160116_145935_869156.png

/wp-content/uploads/2015/03/ice_screenshot_20160116_150213_869157.png

/wp-content/uploads/2015/03/ice_screenshot_20160116_150822_869158.png

  Double click to slect the  IBIPSTAT  structure which holds the user status data
/wp-content/uploads/2015/03/ice_screenshot_20160116_152112_869161.png

Step 2  –  Fill the template with the required data    

Step 3 – Generate Flat file

/wp-content/uploads/2015/03/2015_05_25_000356_710156.jpg

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

/wp-content/uploads/2015/03/ibip_2_668252.png

Option 2 –   IBIP RFC FM integration with Excel

This option allows to stay in the Excel (dose not required SAP gui installed ) including performing test run before upload! ,Exemple task list with multi operations , operation long texts and matrial assigned to operations

Regards
Ziv Marcovich

 

43 Comments
You must be Logged on to comment or reply to a post.
  • Great document. Do we have similar for QM as well?

    Can we use the template and assign this file to LSMW? instead of recording?

  • is this can be used for (Mass Update) update the Work order for example user status. I know that I can do it by IW38 (mass option), but I do not have authorization for that.

    Can this work for recording other than IBIP functions.

  • Hi,

    Thank you! Excellent blog post!

    Small issue, we have tried both links to download XLS tool, but in both cases we’ve gotten HTTP 403 response.

    Could you please check and share whether it is still possible to get XLS downloaded?

    Kind Regards,

    Siarhei

    • Thanks Siarhel and Belinda ,The link issue was resolved.

      You can now downalod the file from the blog link.

      Enjoy it.

      Regards,

      Ziv

  • Dear Ziv

    Thanks Alot for Sharing such a very very very useful Document but if there an available tool like this sheet for creating and changing a Master Recipe T-code ( C201 – C202)

    Regards

    Hussam Ghanem

    • Dear Hussam,

      Thanks , These T-code ( C201 – C202) are not supported by IBIP nor other SAP batch input programs so this Excel solution is not applicaple ,looks like BDC / recording LSMW is the solution here

      Regards,

      Ziv

      • Dear ZiV

        Nice Document and very helpful but is there any way that i can  use tool for uploading master  data  in another module

        like production planning for


        – Material master

        – Bill of Material

        – Routing

        – Work Center

        Regards

        Hussam Ghanem

  • Hi Ziv,

    This looks like a great tool that you have created. It would be a great help to manage most of SAP PM data load requirements. Thanks a lot for sharing this.

    You have also done a great job in explaining the tool in this article.

    EDIT:

    Unfortunately, the links to the tool download does not work anymore. Could you please have a look at this?

    [Sorry, I did not notice the new dropbox link in the article. Thanks again]

    Thanks a lot.

    Best Regards,

    Seby

  • Hi Ziv,

    At my firm we Purchased Ziv’s IBIP tool and it works like a charm. The support has been very helpfull and it has saved me for alot of working hours.

    – Works great

    Regards

    Christian

  • Dear ZiV

    Nice Document and very helpful but is there any way that i can  use tool for uploading master  data  in another module

    like production planning for


    – Material master

    – Bill of Material

    – Routing

    – Work Center

    Regards

    Hussam Ghanem 

    • Dear Hussam ,

      Thanks for the compliment.

      I have Excel flat file solution for these objects you have mentioned , which is not related to the IBIP transaction ,you can contact me at my profile for additional information.

      Regards,

      Ziv

  • Hello, Ziv!

    Great documentation on the most valuable tool for mass loading PM data! Could you please upload the excel spreadsheet again? Or anyone who has a copy share it through google drive, or any server?

    If someone could send it to my email, I would share it on google drive with the world! 😀

    vbrito at gmail

    Thank you very much!

  • Dear Ziv,

    I have had a great experience using the IBIT Tool for PM data uploads.

    I have used other good Excel/Access data toolkits in the past, with very strict licensing conditions. What I like about the IBIP Tool is its accessibility and ease of use. With basic technical knowledge of both SAP PM data structures and Excel, one is able to navigate through and use the IBIP Tool with ease.

    The support I constantly received from you was wonderful and very useful. It also made such a difference.

     

    Thank you for all,

     

    Alain MT Kitsa

    • Hi JP ,

      The IBIPTool is again available for download ,the new version included the folowing new functions :
      – RFC direct connection using the CCo Connector 
      – Test Run for RFC option
      – Debug (Step by Step option) for RFC option
      – Auto template builder for multi structure
      – Display IBIPTool created object is SAP GUI in one click

       

      Regards,

      Ziv

       

  • Hi Zak

     

    I just download the new version. But when I  try to activate it, although it says it is activated, it keep asking for the licence key. I cannot go further.

     

    Any idea ?

     

    Marc