topic Re: bdc programing-help needed in Application Development and Automation Discussions

bdc programing-help needed

Former Member — Wed, 14 Dec 2005 17:59:51 GMT

Hi friends,

Thank you so much for a lot of replies for my previous thread.

The exercise is this:

. Create a BDC program for the following

- Read a flat file containing Vendor Master details (keep the record structure as simple as possible). The file should contain a list of Vendors to be created in the SAP system.

- Using BDC technique, create the Vendor master using FK01 transaction

- Repeat the steps for creating all Vendors listed in the file. For each transaction, print out if the BDC was successful or not, and if successful print out the Vendor Number that was created.

But i dont know how to start with it .

what should be my first step.

I have created a Excel sheet file with all those data's

what should be my next step?

please help me... i entered in to shdb transaction code.

dint know how to procedd further.

Plz help me to learn this process...

Thanks in advance.

Thanks&Regards

rinky123

Re: bdc programing-help needed

Former Member — Wed, 14 Dec 2005 18:07:52 GMT

Hi rinky,

Well ,to get data from excel sheet use

ALSM_EXCEL_TO_INTERNAL_TABLE. Watch out for the strucutre of the internal table u get from this function module.

Now, in shdb, do a recording of your transaction with actual data which will create a vendor for sure. Convert it to a program by saving the recording and then clicking on "Program" button. study the BDC program it genreates carefully. pass your data whereever the hardcoded values are present.

Printing messages can be done from the messtab you get in call transaction statement.

One more piece of advice : be patient.

Shiv

(Give points depending upon the the clearity of the answer)

Re: bdc programing-help needed

Former Member — Wed, 14 Dec 2005 18:11:39 GMT

You need to upload the file into an internal table where you can analyze it. So first, convert it to a text file that you can easily parse (comma delimited or fixed length fields).

If you are not familiar with the vendor master transactions (FK01 and FK02), have someone walk you through them.

Finally, you'll have to loop through the internal table of vendor data and do a transaction for each.

Rob

Re: bdc programing-help needed

RichHeilman — Wed, 14 Dec 2005 18:13:32 GMT

First you need to get the data from excel into your program. Convert it to a comma delimited text file. Then use this sample to get the data in your internal table.




report zrich_0001.

types: begin of ttab,
       rec(1000) type c,
       end of ttab.

types: begin of tdat,
       fld1(10) type c,
       fld2(10) type c,
       fld3(10) type c,
       end of tdat.

data: itab type table of ttab with header line.
data: idat type table of tdat with header line.

data: file_str type string.

parameters: p_file type localfile.

at selection-screen on value-request for p_file.
  call function 'KD_GET_FILENAME_ON_F4'
       exporting
            static    = 'X'
       changing
            file_name = p_file.

start-of-selection.

  file_str = p_file.

  call function 'GUI_UPLOAD'
       exporting
            filename                = file_str
       tables
            data_tab                = itab
       exceptions
            file_open_error         = 1
            file_read_error         = 2
            no_batch                = 3
            gui_refuse_filetransfer = 4
            invalid_type            = 5
            no_authority            = 6
            unknown_error           = 7
            bad_data_format         = 8
            header_not_allowed      = 9
            separator_not_allowed   = 10
            header_too_long         = 11
            unknown_dp_error        = 12
            access_denied           = 13
            dp_out_of_memory        = 14
            disk_full               = 15
            dp_timeout              = 16
            others                  = 17.


  loop at itab.
    clear idat.
    split itab-rec at ',' into idat-fld1
                               idat-fld2
                               idat-fld3.
    append idat.

  endloop.


  loop at idat.
    write:/ idat-fld1, idat-fld2, idat-fld3.
  endloop.

Notice now that you have an internal table with all the records of the file and split up into different fields.

The next part, you need to record the FK01 transaction using the transaction code SHDB.

Click new recording, enter a name of your recording,(example TEST), then put FK01 in the transaction code box. click start recording. You will now see the transaction FK01, do the transaction as normal and click save. Now you will see, a screen that says EDIT recording TEST, there is some code there, click save, then back. Select your recording in the table, and click program, enter another program name and click transfer from recording. Now you have a program with all of the code in it. This is you BDC code. You will want to copy and past most of that code.

Regards,

Rich Heilman