Skip to Content
User Experience Insights
Author's profile photo Ziv Markovich

BOM Data migration using Flat File Tool

ABSTRACT

Previously I have demonstrated the IBIP tool  to support data migration using flat file in the EAM area

I this Blog I will show simple way to Utilized cross application  SAP standard direct/batch programs for by export data from within Microsoft Excel to Flat text files in the required format by SAP programs

Test case Example – BOM update using transaction – OS43  – Demo video 

STEP 1 - Create BOM header using IBIPTool - LSMW  
STEP 2 - Create  template - BOM Example   

 Create  template using structures (BGR00,BICSK,BICSP..)  – choose just the relevant fields .

 /wp-content/uploads/2015/04/2015_04_17_100035_686551.jpg

/wp-content/uploads/2015/04/2015_04_17_100132_686552.jpg

/wp-content/uploads/2015/04/2015_04_17_100227_686562.jpg


STEP 3 - Generate Flat File   

/wp-content/uploads/2015/04/2015_04_17_100307_686563.jpg

/wp-content/uploads/2015/04/2015_04_17_100343_686564.jpg

STEP 4 – Upload the flat file created  at transaction OS43 ( change BOM )  

 Thanks

Ziv Marcovich

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashu Aggarwal
      Ashu Aggarwal

      Hi ,

      How can we Download this tool and what is the cost of this tool ?

          "Download and open excel IBIPTool spreadsheet"

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

      The tool was  enhanced to most of the SAP standart direct/batch programs

       

      Author's profile photo Christian Wallner
      Christian Wallner

      @Ziv Unfortunately none of the links work, is your tool still free of charge?

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

      The links works -please re-check ,The Tool is for free for non commercial user

      .

      Author's profile photo Jörg Kamp-Hubert
      Jörg Kamp-Hubert

       

      @Ziv: The link works but the download functionality throws an error.

      'Error! Failed to log the download request in the database table'

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

      Hello Jörg Kamp-Hubert

      Thanks for the feedback, the website is now updated , here is direct link to the download

      Regards,

      Ziv

       

      Author's profile photo PAMPANA BHANU TEJA
      PAMPANA BHANU TEJA

      Dear Sir,

      I have went on to your website clicked on the tool but the file is not downloaded.

      Author's profile photo Maheshkumar gattu
      Maheshkumar gattu

      How do we import BOM/Source List and Routings data into excel/flat file from SAP?