vnsolutions (vnsolutions) wrote,

Sample BDC Program to read data from Excel

This ABAP program read data in Excel format file ( or tab text file ) , copy to internal table , validate and call BDC transaction to process T-code FB01.

Step 1:

Create program ZK_FI_BDC_GL.

Download the source code here:


Step2: Create Excel file contain data to upload.

First row of file is header and all columns match with x-file struct in program.

We can also use the text file to upload. Download the sample file here:

Step3: Open program and run.Input file name and session.

Step4: Run SM35 to process session.

I zip all sample file and source into 1 folder for downloading here:

Related Articles:


  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded