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:
http://binbox.io/OiCXA#Iw5c2X67
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:http://binbox.io/oXa7X#3J0TvtF7
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:http://bit.ly/15hBs7V
Related Articles: