Flat File Tool

  • Download link

    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 )



    Maintain in the Physical name : BOM_CREATE


    STEP 2 - Create  template - BOM Exemple   

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




    STEP 3 - Generate Flat File   



    STEP 4 – Upload the flat file to the application servere  


    STEP 5 – Run the SAP data migration program via SE38



    Example  : Create Material using direct input method