Excel IBIP Tool - Easy Upload PM Master Data

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 directl! with pre made flat files that matches to the IBIP structures and hierarch! "the #xcel IBIP tool can be usesd as an alternati$e to LSMW

The Tool includes %emo templates are a$ailable to %ownload here

Authorizations& if !our re'uirement is pro$ide simple excel based tool for the end user for master data mana(ement and LSMW authori)ation in the P*% s!stem is not an option

Fast and Simple & +se , #xcel source file also for multi structures "in the IBIP Tool there is no need to lin- between the files usin( -e! relations between the structures  +sin( I%#/T, " I%#/T0 etc..1 as re'uired re'uired b! LSMW approach approach " The 2lat file file records are written to the flat file based on the location se'uence se'uence of the structure in the #xcel template.

se$eral flat Schedule runs at ni(ht 3obs & b! splittin( the flat file to se$eral files we can use the IBIP pro(ram to upload the data in a schedule  job which includes includes also the option option to define in ad$ance on which ser$ers the scheduled jobs will be executed for load balancin( purpose and also achie$e parallel processin( functionalit! which speed up data upload upload " This approach is $er! helpful when dealin( with mass master data update " 2or exemple if se$eral millions of records can be completed o$er ni(ht depends on the number of ser$ers in the P*% s!stem 1 usin( this approach .

#xemples for such chan(es for 2unctional locations or e'uipments 4

& Mass update class and characteristic & Mass update of s!stem profile & Mass update of the Address data  usin( structure IBIPB%5%1

Templates examples #xemple , 45reate #'uipment with user status #xemple 0 45reate #'uipment with class and characteristics #xemple 6 47eneral Tas- list with operation and assi(nment to maintenance pac-a(es

•

Microsoft excel 2007- 2013

•

Macro enabled

STEP A - Prepare template structures and re'uired fields

Select the required

•

Selected multi radio button

•

Select structure IBIP#8+I

•

Select the re'uired fields from the IBIP#8+I structure

•

Select structure IBIPSTAT

•

Select all the fields from this structure IBIPSTAT

1. Open the add in file

2 .Select IE01 – Create equipment in the transaction combo box 3. Select the IBIPEQUI structure in the data structure listbox

5. Double click the IBIPSTAT structure which holds the user status data

STEP B - Fill Excel source / template worksheet

STEP C - Generate The Flat File for IBIP

Transaction

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

Step  - !ploa" the Flat File to the IBIP transaction

. Select the created file from the flat file selected folder and press

in the II! transaction

Step E # $ptional % store the &les in the Application ser'er 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 and it is required to schedule the run at night (when system load is low) , in this case : Goto sm51 select the required server

Goto to transaction CG3Z and uload the !lat !ile to the current alication server

3"Select the alication server #hich the !ile #as uloaded into and select the Ph$s" !ile and ress on %E&ecute%

Step F ( Check the )o* "ets #heck and confirm that the e$uipment 1%%%&'() created is created with the *%%%5* status which as displa+ed in the excel row (

'e can see the result ( the equiment 1)))*+,- #as created #ith user status %)))5%

1 ,oto transaction II! – press the information icon to see Structure hierarch+ - So +ou can know which structures are re$uired to +our business scenario

3. ow –with the II! /ool #reate template usin0 structures II!I - II!#"4S II!4/

6nhide row 172 to 8iew selected structures and fields technical names9

(.pload the lat ile to the II! transaction

5. "et:s #heck and see that the e$uipment created 2%%;&% was created with the re$uired class and characteristics per the data in the excel rows ( 7&