about bdc uploading

[Former Member]

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?

[Former Member]

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

[Former Member]

Thank you vivek, it is working

[Former Member]

Hi Priya,

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

Thanks

Tarak

[Former Member]

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.

[Former Member]

This message was moderated.