ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

im using fm ALSM_EXCEL_TO_INTERNAL_TABLE but it is still dumping..what can i do with it?

[Former Member]

A short dump can occur for more than 1 reason, so try to provide the details of the dump.What does it specify?

~Eswar

[Former Member]

hii

use this FM like below code..

*Upload data from Excel sheet to internal table.
  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = p_pfile
      i_begin_col             = 1
      i_begin_row             = 2
      i_end_col               = 13
      i_end_row               = 8
    TABLES
      intern                  = it_excel
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.
  IF sy-subrc <> 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.


*Populate data to internal tables and structures

  SORT it_excel BY row col.

  LOOP AT it_excel INTO ls_excel.

    CASE ls_excel-col.
      WHEN 1.
        ls_data-rec_no = ls_excel-value.
      WHEN 2.
        ls_data-doc_type = ls_excel-value.
      WHEN 3.
        ls_data-doc_part = ls_excel-value.
      WHEN 4.
        ls_data-doc_ver = ls_excel-value.
      WHEN 5.
        ls_data-application = ls_excel-value.
      WHEN 6.
        ls_data-data_car = ls_excel-value.
      WHEN 7.
        ls_data-file_path = ls_excel-value.
      WHEN 8.
        ls_data-matnr = ls_excel-value.

    ENDCASE.                             " CASE ls_excel-col.

i hope it helps you.

regards

twinkal

[Former Member]

getwa_not_assigned is the error.

[Former Member]

Hi,

If twinkal's reply doesnot help please paste the code you have used...

[Former Member]

Hi Jem,

You might have missed some parameters in the function you are using.

Please my below code or better you post your code we can find the error that is taking you to dump.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = P_FNAME

i_begin_col = 1

i_begin_row = 1

i_end_col = 44

i_end_row = 60000

TABLES

intern = IT_FILE_UPLOAD

.

Cheers!!

Balu

[Former Member]

i think the problem is my loop structure..it can not read the tables.

[former_member181995]

rather than guessing anything so long ,better if you post DUMP information here!

PS:if your dunp says getwa_not_assigned than i'm sure your problem is with some field cat not with this FM.

[Former Member]

You attemempted to access unassigned field symbol.

This error may occur if

-You address a typed field symbol before it has been set with assign.

-You address a field symbol that pointed to the line of an internal table that was deleted

[former_member181995]

Sorry ignore.

was it dump information?

my apologies to you if you hurt.

please reply to correct person.

Edited by: Amit Gujargoud on Oct 20, 2008 9:51 AM