topic Re: Problem in uplaoding a file in Application Development and Automation Discussions

Problem in uplaoding a file

Former Member — Wed, 23 May 2007 03:56:49 GMT

What data should I pass to the field I_TAB_RAW_DATA while using the function module TEXT_CONVERT_CSV_TO_SAP.

Re: Problem in uplaoding a file

Former Member — Wed, 23 May 2007 04:06:24 GMT

I hope its optional parameter, still you want to pass....check the below code

TYPE-POOLS: TRUXS.

PARAMETERS: P_FILE TYPE RLGRAP-FILENAME.

TYPES: BEGIN OF T_DATATAB,

COL1(30) TYPE C,

COL2(30) TYPE C,

COL3(30) TYPE C,

END OF T_DATATAB.

DATA: IT_DATATAB TYPE STANDARD TABLE OF T_DATATAB,

WA_DATATAB TYPE T_DATATAB.

DATA: IT_RAW TYPE TRUXS_T_TEXT_DATA.

At selection screen

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

FIELD_NAME = 'P_FILE'

IMPORTING

FILE_NAME = P_FILE.

***********************************************************************

*START-OF-SELECTION.

START-OF-SELECTION.

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.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

***********************************************************************

END-OF-SELECTION.

END-OF-SELECTION.

LOOP AT IT_DATATAB INTO WA_DATATAB.

WRITE:/ WA_DATATAB-COL1,

WA_DATATAB-COL2,

WA_DATATAB-COL3.

ENDLOOP.

Re: Problem in uplaoding a file

Former Member — Mon, 07 Apr 2008 09:42:53 GMT

I have one more question. How could I import table with header line.

For example I have table in excel :

date cost

1.1.2008 200

2.1.2008 300

3.1.2008 250

When I use the program http://www.sapdev.co.uk/file/file_upexcel.htm the resault is without header line.

The result is:

1.1.2008 200

2.1.2008 300

3.1.2008 250

How could I become whole table.

And how could I modify this program that there will be dinamic structure of internal table.