Using BDC how to transfer EQ BOM , Mat BOM excel data to SAP .. CS01,IB01

Hi ,

I am new to BDC programming. my requirement is using BDC ABAP program to load MAT BOM and EQ BOM data in excel spread sheet to SAP master data.

transactions are CS01 – Create Material BOM

IB01 – Create Equipement BOM

Input file layout is

EQUNR 18

WERKS 4

STLAN 1

AENNR 12

DATUV 8

ZTEXT 40

BMENG 13

STLST 2

IDNRK 18

MENGE 13

MEINS 3

POSTP 1

KTEXT 40

PREIS 11

EKGRP 3

MATKL 9

And I have sample data in excel for both mat BOM and EQ BOM.

plz some one can help me out using ABAP BDC programing.

Vamsi.

Edited by: Vamsi on Jan 8, 2008 10:38 PM