For a BDC upload you need to write a program which created BDC sessions.

Steps:

   1.Work out the transaction you would use to create the data manually.

   2.Use transaction SHDB to record the creation of one material master data.

   3. Save the recording,and then go back a screen and go to the overview.

   4.Select the recording and click on Edit - Create Program.Give the program a Z name and select transfer from recording.

   5.Edit the program. You will see that all the data you entered is hard -coded into the program. You need to make the following changes.

      a. After the start-of-selection,call ws_upload to upload the file (the excel file needs to be saved as TAB separated)

      b.After the open-group,Loop on the uploaded data. For each line,perform validation checks on the data,then modify the perform bdc_field

        commands to use the file data.

     c.After perform bdc_transaction,add the endloop.

 Execute the program.It will have options to create a batch session or to process directly.

These are all my finds. Might be it will be useful to you.

Batch Data Communication or BDC is a batch interfacing technique that SAP developed.

It is mainly used for uploading data into the SAP R/3 system.

BDC works by simulating the user input from transactional screen via an ABAP program.

The data input data file will come in the form of a flat file which the user save as file type or prn file

from the Microsoft Excel program .

An Abaper will create a program to read the text file and upload into the SAP system.

Normally the tcode SHDB will be used to record the transaction code the user used.

After, the simulation. the Abaper can generate a sample program and modify from here.

It makes the programming easier and faster.

Program : A series of ABAP statements.

Report : An ABAP program whose output is a list.

Module Pool : A dialog program which is a collection of screens.

List : The output generated by an ABAP report program.

Reporting and ABAP Development

The ABAP editor is used to create maintain and execute ABAP programs.

Some methods for executing ABAP programs include:

• The ABAP editor Tools - ABAP Workbench - Development - ABAP editor(SE38)
• The Reporting function: System - Services - Reporting (SA38)