topic Re: about bdc uploading in Application Development and Automation Discussions

about bdc uploading

Former Member — Mon, 11 Mar 2013 07:44:03 GMT

Iam new to sap, i done the program for uploading excel file in bdc format, but that flat file having headings.. my requirements is that flat file with headings also we want to upload ....In bdc uploading the excel file, in this excel file having headings then how to upload?

Re: about bdc uploading

Former Member — Tue, 12 Mar 2013 05:51:29 GMT

Hi Priya,

U can try like the following pseudo code :

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

* I_FIELD_SEPERATOR =

I_LINE_HEADER = 'X'

I_TAB_RAW_DATA = IT_RAW " WORK TABLE

I_FILENAME = P_FILE

TABLES

I_TAB_CONVERTED_DATA = IT_DATATAB[] "ACTUAL DATA

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

Thanks

Vivek

Re: about bdc uploading

Former Member — Tue, 12 Mar 2013 06:07:52 GMT

Hi Priya,

Could u pls give me the Excel format , So I can give u the code for tha EXCEL.

Thanks

Tarak

Re: about bdc uploading

Former Member — Tue, 12 Mar 2013 06:28:09 GMT

Hi Priya,

When you are uploading the flat file you should not upload the heading to the database.that heading are for understanding purpose. remove the heading and move the flat file data to the internal table and upload the data to the database.

Thanks.

Pavan.

Re: about bdc uploading

Former Member — Tue, 19 Mar 2013 05:47:03 GMT

This message was moderated.

Re: about bdc uploading

Former Member — Tue, 19 Mar 2013 05:47:31 GMT

Thank you vivek, it is working