Flat File Tool

  • 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

    Example  : Create Material using direct input method