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:

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

ABAP Download:

3 Modularisation and BDC.pdf__www.sapland.com.zip
ABAP Technical Interview Questions Abap.SapLand.Com
CB_028_Integrating_Microsoft_Office_SharePoint_Server_and_SAP.pdf

Microsoft® Office SharePoint® Server 2007 and SAP

Advertisements

About sapland

Sap's Blog

Posted on July 25, 2013, in Uncategorized and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: