Skip to Content

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

To report this post you need to login first.

7 Comments

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

Leave a Reply