Skip to Content

ABSTRACT

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

BENEFITS

 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

SimpleUse 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)

 Templates examples
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 

Pre requirement

  • Microsoft excel 2007- 2013
  • Macro enabled
  • internet connection – use for product validation

Step 1 – Create template using IBIP Tool excel macro 

  1. Open the IBIP Tool file  /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 created template


Step 3 – Generate the Flat File using
IBIP Tool excel macro
  

 

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

 

The flat file will Automatically created ( stored in the temp folder )

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

 

Step 4 – Upload the Flat File in IBIP Transaction

 Select  the created file from the flat file selected folder and press   in the IBIP transaction  /wp-content/uploads/2015/03/ibip_1_668251.png

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

 

 

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:

SM51.png

– Goto to transaction CG3Z and upload the flat file to the current application server
CG3Z.png

 

–  Select the application server which the file was uploaded                        into  and select the Phys. file  and press on “Execute”

IBIP_SERVER.png

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         

  ibip_1_CHK.png

 We can see the result : the equipment 10006947 was created with user status “0005”

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

Exemple 2
IBIP Flat file : Equipment creation with class and characteristics

/wp-content/uploads/2015/03/13_668255.jpg

Goto transaction IBIP – press the information icon to see Structure hierarchy , So you can know which structures are required to your business scenario
/wp-content/uploads/2015/03/12_668256.jpg    Using IBIP Tool Create  template using structures IBIPEQUI , IBIPCLAS  ,  IBIPFEAT /wp-content/uploads/2015/03/exm_2_668258.png

 -Upload the Flat File to the IBIP transaction
 -Let’s Check and see that the equipment created 200860 was created with   the required class and characteristics  per the data  in
  the excel rows 4 -6     
/wp-content/uploads/2015/03/exm_2_fin_668259.jpg

Regards
Ziv Marcovich


To report this post you need to login first.

34 Comments

You must be Logged on to comment or reply to a post.

  1. Chandra 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?

    (0) 
  2. Duraisamy Dhanaraj

    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.

    (0) 
  3. 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

    (0) 
    1. Ziv Markovich Post author

      Thanks Siarhel and Belinda ,The link issue was resolved.

      You can now downalod the file from the blog link.

      Enjoy it.

      Regards,

      Ziv

      (0) 
  4. 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

    (0) 
    1. Ziv Markovich 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

      (0) 
      1. 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

        (0) 
  5. 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

    (0) 
  6. 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

    (0) 
  7. 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 

    (0) 
    1. Ziv Markovich 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

      (0) 

Leave a Reply