topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Tue, 22 May 2007 16:37:26 GMT

Hi ABAP Guns,

Here is the code.

even though i declared the internal table in the follwing code it is giveing an error that GT_INPUTFILE 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 = GT_INPUTFILE

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

ENDFORM.

Thanks N Regards,

Sudhir.

Re: Internal Table

amit_khare — Tue, 22 May 2007 16:40:12 GMT

Use WITH HEADER LINE.

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

Regards,

Amit

Reward all helpful replies.

Re: Internal Table

Former Member — Tue, 22 May 2007 16:41:18 GMT

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.

Re: Internal Table

Former Member — Tue, 22 May 2007 16:43:38 GMT

You declared the Internal table wrongly

declare it either

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

DATA: BEGIN OF GT_INPUTFILE OCCURS 0,

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 Gt_INPUTFILE.

Reward points if useful

Regards

Anji

Re: Internal Table

Former Member — Tue, 22 May 2007 16:43:56 GMT

TYPES: BEGIN OF TYPE_INPUTFILE With Header Line,

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.

Re: Internal Table

Former Member — Tue, 22 May 2007 16:47:56 GMT

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

Re: Internal Table

Former Member — Tue, 22 May 2007 16:50:14 GMT

Hi,

Its giving the same error.

I tried with all options.

Regards,

Sudhir.

Re: Internal Table

Former Member — Tue, 22 May 2007 16:50:47 GMT

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

Re: Internal Table

Former Member — Tue, 22 May 2007 16:52:28 GMT

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.