Skip to Content
avatar image
Former Member

ALSM_EXCEL_TO_INTERNAL_TABLE

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 06:57 AM

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

    ~Eswar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 06:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 07:05 AM

    getwa_not_assigned is the error.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 07:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 07:17 AM

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

    Add comment
    10|10000 characters needed characters exceeded

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

  • avatar image
    Former Member
    Oct 20, 2008 at 07:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded