topic Re: Customer master BDC program in Application Development and Automation Discussions

Customer master BDC program

Former Member — Tue, 07 May 2013 16:04:47 GMT

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.

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 05:56:07 GMT

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

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 05:59:48 GMT

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.

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 06:03:40 GMT

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

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 06:09:46 GMT

Like this

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 06:48:48 GMT

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

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 07:35:20 GMT

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.

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 09:58:49 GMT

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

Re: Customer master BDC program

Former Member — Wed, 08 May 2013 13:09:59 GMT

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.

Re: Customer master BDC program

Former Member — Fri, 10 May 2013 17:02:32 GMT

This message was moderated.