Customer master BDC program

[Former Member]

Hello,

I made a Customer Master BDC program but i don't know to maintain an exel file according to my BDC internal table.

Thanks & Regards:-

Prashant Sharma.

[Former Member]

hi Prashant,

Check the BDC Internal table and take all those fields which are required .

Make one excel with those fields and fill data and than process ur Program.

Thanks

Tarak

[Former Member]

Hi ,

You can do two things:

1) If you have an excel with a predefined format as per requirement, upload the data from excel into an internal table and pass data from this table to your BDC table as required.

2) create an excel as per your bdc table as suggested by Tarak.

[Former Member]

Dear Prashant,

First of all, please see the all required field which have filled by user or you,then Create a Internal table as Excel Sheet. After that call the Upload Program.

Thanks.

Ram Shanker

[Former Member]

Like this

[Former Member]

In addition to your query, you need to adjust your program internal table or mapping fields of internal table (Depending upon the FM you are using) according to the excel instead of your Program.

The templates should be created in some Specific order as mention below :-

1. It should be in accordance to screen flow sequence and should also have the same Field sequence so that it will be easy for the user to check the same in customer master.

2. Template should be mentioned and also specified (In excel also) with the Mandatory fields in the customer master, so that while filling the template the user should not leave this field blank. e.g.Like for partner function "Sold to party" Account assignment should be made mandatory.

3. Better note that the customer master data screens and mandatory fields can be changed with partner function e.g "Sold to party" or "Ship to Party". Either make a separate program with respect to partner function otherwise you need to handle the  screen flows pragmatically.

I hope this is enough to resolve your issue.

Regards,

Rahul

[Former Member]

Dear all,

I made an exel file according to the sequence which i've mentioned in my internal table.After that i converted it into Tab Delimited format.If I'm trying to upload them it isn't uploading and the cursor is going on a file path.What should i do?

Regards:-

Prashant Sharma.

[Former Member]

Are you doing this for the first time ???

If you have this file in excel then why you need this in TAB delimited instead you could have used TEXT_CONVERT_XLS_TO_SAP.

I think you need tutorial for the same

<< Link to restricted site removed >>

You can find lot of blogs and tutorial on web for the same.

Message was edited by: Kesavadas Thekkillath

[Former Member]

Hi Prashant,

First check your program code and analyse it. Identify whether that program written for Tab delimited file or Excel file. Once you identified the file type then check that internal table structure, prepare the respective file to upload the customer master data.

Note : After calling UPLOAD function module maintain the below code. It will display the error messages if any wrong file format is there. 

  IF sy-subrc NE  0.
     MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
             WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.

Regards,

Shaiksha Vali.

[Former Member]

This message was moderated.