BDC program

[Former Member]

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.

[former_member585060]

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

[Former Member]

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.

[Former Member]

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

SL

[Former Member]

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

[Former Member]

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.

[Former Member]

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