topic Re: BDC program in Application Development and Automation Discussions

BDC program

Former Member — Fri, 29 Aug 2008 12:09:06 GMT

Dear Guru's,

I would like to know BDC program takes fields in which order ,

My requirement is as a functional consultant i have to preapare one excel sheet which will be used to upload data ( we have allready prepared BDC program ) now i have to prepare fields in order in a excel sheet .

Please some body give some input.

Thanks,

Srini.

Re: BDC program

former_member585060 — Fri, 29 Aug 2008 12:21:58 GMT

Hi,

Prepare the data in excel sheet in the order, in which u have entered in the corresponding fields of screens while Recording of that Transaction.

Regards

B Krishna

Re: BDC program

Former Member — Fri, 29 Aug 2008 12:26:16 GMT

Hi Sri,

The order is not importent during BDC upload, as a technical consultant I can say this. What is expected out of you is give all the required fields to be uploaded in the transaction( Which includes mandatory fields of the corresponding transaction code.

Hope this explanation of mine helps you,

Cheers,

Rama.

Re: BDC program

Former Member — Fri, 29 Aug 2008 17:19:10 GMT

Hi sri tata,

The layout of the excel file is not important, because you will load all your excel file data into an internal table (using ALSM_EXCEL_TO_INTERNAL_TABLE or something similar) and insert that data into the appropriate screen fields during the BDC process.

Logically, if the Excel file needs to be created by an individual, you should check with that person to determine the most user-friendly way for him/her to enter the necessary data into the Excel sheet.

Good luck

Re: BDC program

Former Member — Fri, 29 Aug 2008 17:39:30 GMT

Order of the fields is not a mandatory in the Excel sheet for BDC upload, .

Re: BDC program

Former Member — Mon, 01 Sep 2008 07:36:19 GMT

Dear All,

Right now what i am doing for some BDC programs is

copying the excel file to note pad and attaching it to in se38 by selecting arespective BDC.

I think i am not following the right procedure please direct me .

Thanks,

Srini.

Re: BDC program

Former Member — Tue, 02 Sep 2008 05:39:45 GMT

Hi Srini,

I'll suggest to maintain the order of your data declaration with the excel sheet this may solve your problem, the unnecessary data declaration i.e. which you have maintained as constants should be commented in your data declaration and also skipped in the excel sheet.

Regards

Amol