Skip to Content
Technical Articles
Author's profile photo Ziv Markovich

IBIP Tool – upload data from excel to SAP

ABSTRACT

SAP offers the use of IBIP transaction  as data migration platform as alternative to LSMW for the PM module ,initially IBIP was design by SAP to supported PM objects multi-level hierarchies which are too complex for recording technique .

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.

Variant  1 -SAP PM Module –  use IBIP Tool to generates flat files without recording  compatible to IBIP structures  for all the PM objects hierarchy ready to upload using IBIP transaction

Variant  2 – All other SAP  Modules –  Use IBIP for for (Almost) any transaction using IBIP user exit , recording is done by  transaction SHDB and export the recording to the IBIPTool  which generate automatic template and many other functionalities 

ibip%20for%20all%20tcode

Implement user exit IBIP ( transaction CMOD) using  following ABAP Code

*&  Include           ZXPMZU01

CLEAR: i_bdcdata[] , i_bdcdata ,bdcdata[].

IF int_tab-recordname = 'IBIPTOOL'.

  REFRESH tot_assoc_tab.

  PERFORM assoc_ibiptext.

  PERFORM assoc_ibipbdcd.

  PERFORM proc_ibipbdcd USING 0 .

  bdcdata[] = i_bdcdata[].

ENDIF.

FREE int_tab.

Attached video demo  for  material create at transaction MM01

 

Examples 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

 

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 from the Excel custom button

/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

Step 4 – Check the Log –  the log for the IBIP processing is available at transaction IBIPA

 

Regards
Ziv Marcovich

 

Assigned Tags

      40 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo K Jogeswara Rao
      K Jogeswara Rao

      Very useful documentation !

      Thanks for Sharing Ziv

      Regards

      KJogeswaraRao

      Author's profile photo Former Member
      Former Member

      Nice tool ,really simplify using IBIP transaction

      Thanks for sharing

      Author's profile photo Former Member
      Former Member

      Hi nice document,

      but can you please explan how to create excel file for uploading.

      Regards,

      Ganesh

      Author's profile photo Former Member
      Former Member

      Very useful document. Thanks for sharing. 🙂

      Best regards,

      Nitin

      Author's profile photo Caesar H
      Caesar H

      Great document. Do we have similar for QM as well?

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

      Author's profile photo Former Member
      Former Member

      Great effort and useful document.

      Btw, I cannot access the link for that file. Can you please check it again.

      Regards,

      Thien

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      Thanks Thien,

      It look ok , you can download  here

      and also   here using the download button.

      Regards,

      Ziv

      Author's profile photo Mika Yan
      Mika Yan

      Hello Ziv,

      The document is very useful, thank you for your efforts you are the best (y) ,

      Regards,

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      Hi Sine,

      Thanks 🙂 ,I'm Glad the Excel IBIP tool helped you

      Regards,

      Ziv

      Author's profile photo Tajinder Singh
      Tajinder Singh

      Awesome document. Thanks for sharing.

      Regards,

      Tajinder

      Author's profile photo Maria Terence
      Maria Terence

      Hi Ziv,

      Your write up is excellent, this should be useful for all level of SAP Expertise.

      Regards

      Terence

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      Hi Terence,

      Thanks a lot for the feedback I appreciate it 🙂

      Regards,

      Ziv

      Author's profile photo Former Member
      Former Member

      Hi Ziv,

      Super. Step by step explantion with screen shot. Very easy to understand.

      Thanks.

      Regards,

      Balamurugan R

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      Hi,

      No,The Excel IBIP tool is used for the IBIP supported transactions , IW32 is not in this list

      Regards,

      Ziv

      Author's profile photo Belinda Muller
      Belinda Muller

      Hi,

      Excellent tool and thanks for the outstanding service Ziv

      Author's profile photo Siarhei Tsikhanenka
      Siarhei Tsikhanenka

      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

      Author's profile photo Hossam Ghanem
      Hossam Ghanem

      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

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      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

      Author's profile photo Hossam Ghanem
      Hossam Ghanem

      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

      Author's profile photo Seby Mi
      Seby Mi

      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

      Author's profile photo Christian Lindegaard
      Christian Lindegaard

      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

      Author's profile photo Piyush Potey
      Piyush Potey

      Nice documentation with handful of information!!!

      Thanks for sharing 🙂

      Author's profile photo Carlos Eduardo Araujo
      Carlos Eduardo Araujo

      Very useful documentation! Thanks a lot for Sharing.

      Author's profile photo Former Member
      Former Member

      Hi nice document,

      but can you please explain how to create excel file for uploading.

      Regards,

      Ganesh

      Author's profile photo Hossam Ghanem
      Hossam Ghanem

      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 

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      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

      Author's profile photo Hossam Ghanem
      Hossam Ghanem

      Dear Ziv

      Thanks for your valuable help , i sent  a mail for you  please check and feed me back

      Regards

      hussam Ghanem

      Author's profile photo Hossam Ghanem
      Hossam Ghanem

      Dear Ziv

      Thanks in advance am waiting for your valuable  help

      regards

      Hussam Ghanem

      Author's profile photo Former Member
      Former Member

      It appears that the link has once again expired - I am getting a spam ad page.

      Author's profile photo Former Member
      Former Member

      The site is back up now, but the download links within the site show a generic wordpress 'not found' result.

      Author's profile photo Carlos Hernández
      Carlos Hernández

      Really good Job Ziv, It is clear to understand, unfortunely links for download excel program doesn´t work could you help me with that,

      Regards

       

      Author's profile photo Grethe Byrkjedal
      Grethe Byrkjedal

       

      Just what I'm looking for..but the download link is not working

      Author's profile photo Vinicius Carnizello Hayne Brito
      Vinicius Carnizello Hayne Brito

      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!

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      Hello Brito,

      Download link + TestKey was updated

      Regards,

      Ziv

       

      Author's profile photo Alain Kitsa
      Alain Kitsa

      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

      Author's profile photo Jérémy PAPIN
      Jérémy PAPIN

      Hello,

       

      It seems all links are dead to download file templates. Could you reactivate them ?

       

      Thanks a lot.

      JP

      Author's profile photo Ziv Markovich
      Ziv Markovich
      Blog Post Author

      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

       

      Author's profile photo Marc Schreiber
      Marc Schreiber

      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

      Author's profile photo ludovic hamelin
      ludovic hamelin

      Hi Ziv,

      trying to get the demo on Exsait.com but link is dead. I'm very interested so could you please contact me.

       

      thanks