Technical Articles
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
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
-Select IE01 – Create equipment in the transaction combo box
– Select the IBIPEQUI structure in the data structure listbox
Double click to slect the IBIPSTAT structure which holds the user status data
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
Regards
Ziv Marcovich
Very useful documentation !
Thanks for Sharing Ziv
Regards
KJogeswaraRao
Nice tool ,really simplify using IBIP transaction
Thanks for sharing
Hi nice document,
but can you please explan how to create excel file for uploading.
Regards,
Ganesh
Very useful document. Thanks for sharing. 🙂
Best regards,
Nitin
Great document. Do we have similar for QM as well?
Can we use the template and assign this file to LSMW? instead of recording?
Great effort and useful document.
Btw, I cannot access the link for that file. Can you please check it again.
Regards,
Thien
Thanks Thien,
It look ok , you can download here
and also here using the download button.
Regards,
Ziv
Hello Ziv,
The document is very useful, thank you for your efforts you are the best (y) ,
Regards,
Hi Sine,
Thanks 🙂 ,I'm Glad the Excel IBIP tool helped you
Regards,
Ziv
Awesome document. Thanks for sharing.
Regards,
Tajinder
Hi Ziv,
Your write up is excellent, this should be useful for all level of SAP Expertise.
Regards
Terence
Hi Terence,
Thanks a lot for the feedback I appreciate it 🙂
Regards,
Ziv
Hi Ziv,
Super. Step by step explantion with screen shot. Very easy to understand.
Thanks.
Regards,
Balamurugan R
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,
No,The Excel IBIP tool is used for the IBIP supported transactions , IW32 is not in this list
Regards,
Ziv
Hi,
Excellent tool and thanks for the outstanding service Ziv
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
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
Nice documentation with handful of information!!!
Thanks for sharing 🙂
Very useful documentation! Thanks a lot for Sharing.
Hi nice document,
but can you please explain how to create excel file for uploading.
Regards,
Ganesh
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
Dear Ziv
Thanks for your valuable help , i sent a mail for you please check and feed me back
Regards
hussam Ghanem
Dear Ziv
Thanks in advance am waiting for your valuable help
regards
Hussam Ghanem
It appears that the link has once again expired - I am getting a spam ad page.
The site is back up now, but the download links within the site show a generic wordpress 'not found' result.
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
Just what I'm looking for..but the download link is not working
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!
Hello Brito,
Download link + TestKey was updated
Regards,
Ziv
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
Hello,
It seems all links are dead to download file templates. Could you reactivate them ?
Thanks a lot.
JP
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
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