Internal Table

[Former Member]

Hi ABAP Guns,

Here is the code.

even though i declared the internal table in the follwing code it is giveing an error that <b>GT_INPUTFILE</b> is not an internal table.

Please help out in this.

TYPES: BEGIN OF TYPE_INPUTFILE,

ACTION TYPE CHAR1,

ZZPERIOD TYPE ZPROFILE-ZZPERIOD,

ZZGRP_CATY TYPE ZIMBASE-ZZGRP_CATY,

ZZNAV_FR TYPE ZIMBASE-ZZNAV_FR,

ZZNAV_TO TYPE ZIMBASE-ZZNAV_TO,

ZZBASE TYPE ZIMBASE-ZZBASE,

ERR_MSG TYPE CHAR128,

END OF TYPE_INPUTFILE.

DATA: GT_INPUTFILE TYPE STANDARD TABLE OF TYPE_INPUTFILE,

PERFORM SUB_UPLOAD_INPUTFILE USING p_file CHANGING GT_INPUTFILE. " Upload input file.

FORM SUB_UPLOAD_INPUTFILE using p_file changing GT_INPUTFILE.

data it_raw(4096) TYPE c.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_LINE_HEADER = 'X'

I_FILENAME = P_FILE

TABLES

I_TAB_CONVERTED_DATA = <b>GT_INPUTFILE</b>

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

ENDFORM.

Thanks N Regards,

Sudhir.

[amit_khare]

Use WITH HEADER LINE.

DATA: GT_INPUTFILE TYPE STANDARD TABLE OF TYPE_INPUTFILE with header line.

Regards,

Amit

Reward all helpful replies.

[Former Member]

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_LINE_HEADER = 'X'

I_FILENAME = P_FILE

TABLES

I_TAB_CONVERTED_DATA = GT_INPUTFILE<b>[]</b>

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

[Former Member]

Hi

You declared the Internal table wrongly

declare it either

DATA: GT_INPUTFILE TYPE STANDARD TABLE OF TYPE_INPUTFILE <b>with header line.</b> or

DATA: BEGIN OF <b>GT_INPUTFILE OCCURS 0</b>,

ACTION TYPE CHAR1,

ZZPERIOD TYPE ZPROFILE-ZZPERIOD,

ZZGRP_CATY TYPE ZIMBASE-ZZGRP_CATY,

ZZNAV_FR TYPE ZIMBASE-ZZNAV_FR,

ZZNAV_TO TYPE ZIMBASE-ZZNAV_TO,

ZZBASE TYPE ZIMBASE-ZZBASE,

ERR_MSG TYPE CHAR128,

END OF <b>Gt_INPUTFILE</b>.

Reward points if useful

Regards

Anji

[Former Member]

Hi,

Its giving the same error.

I tried with all options.

Regards,

Sudhir.

[Former Member]

TYPES: BEGIN OF TYPE_INPUTFILE<i><b> With Header Line</b>,</i>

ACTION TYPE CHAR1,

ZZPERIOD TYPE ZPROFILE-ZZPERIOD,

ZZGRP_CATY TYPE ZIMBASE-ZZGRP_CATY,

ZZNAV_FR TYPE ZIMBASE-ZZNAV_FR,

ZZNAV_TO TYPE ZIMBASE-ZZNAV_TO,

ZZBASE TYPE ZIMBASE-ZZBASE,

ERR_MSG TYPE CHAR128,

END OF TYPE_INPUTFILE.

DATA: GT_INPUTFILE TYPE STANDARD TABLE OF TYPE_INPUTFILE,

PERFORM SUB_UPLOAD_INPUTFILE USING p_file CHANGING GT_INPUTFILE. " Upload input file.

FORM SUB_UPLOAD_INPUTFILE using p_file changing GT_INPUTFILE.

data it_raw(4096) TYPE c.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_LINE_HEADER = 'X'

I_FILENAME = P_FILE

TABLES

I_TAB_CONVERTED_DATA = GT_INPUTFILE

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

ENDFORM.

[Former Member]

Hi Showri,

Please make the following changes

PERFORM SUB_UPLOAD_INPUTFILE TABLES GT_INPUTFILE USING p_file .

FORM SUB_UPLOAD_INPUTFILE tables T_INPUTFILE using u_file.

data it_raw(4096) TYPE c.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_LINE_HEADER = 'X'

I_FILENAME = U_FILE

TABLES

I_TAB_CONVERTED_DATA = T_INPUTFILE[]

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

ENDFORM.

Regards,

George

• Reward points if answered

[Former Member]

use :

PERFORM SUB_UPLOAD_INPUTFILE tables GT_INPUTFILE USING p_file.

FORM SUB_UPLOAD_INPUTFILE tables GT_INPUTFILE using p_file .

or declare a header line to your table.

Cdlt, O.Leroux

[Former Member]

PERFORM SUB_UPLOAD_INPUTFILE tables gt_inputfile USING p_file.

FORM SUB_UPLOAD_INPUTFILE tables it_file

using p_file.

data it_raw(4096) TYPE c.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_LINE_HEADER = 'X'

I_FILENAME = P_FILE

TABLES

I_TAB_CONVERTED_DATA = it_FILE

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

ENDFORM.