Skip to Content
Author's profile photo Ziv Markovich

Data migration Flat File Tool

ABSTRACT

Previosly 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
as directed by SAP  help :”You can use the recording function to create a new  object (or a new “import method”) if neither a standard batch input program nor a standard direct  input program nor the BAPI/IDoc method is available for  a data object.”

Download here excel VBA based spreadsheet (developed by Ziv Marcovich) which generates flat files ready to be uploaded to SAP Standard Direct/Batch Input programs ,The main advantage is the Usage in 1 Excel source file also for multi structures is can save development of designated ABAP programs which writes data to a sequential file in the format required by the ABAP programs.

EXEMPLE :Test case Exemple – BOM create

STEP 1 - Maintain  Logical File settings 
Lets look at the BOM data migration exemple  - the fflat file should be placed in the Application server , therefore Goto Transaction FILE ( This step is required just for create BOM )

screenshot_Tue_Jun_16_20.29.48.png

 

   Maintain in the Physical name : BOM_CREATE

screenshot_Tue_Jun_16_20.30.54.png

STEP 2 - Create  template - BOM Exemple   

 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 to the application servere  

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

STEP 5 – Run the SAP data migration program via SE38 

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

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

 

Enjoy

Best Regards

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?