ALSM_EXCEL_TO_INTERNAL_TABLE

 *  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
*    EXPORTING
*      filename                = p_file
*      i_begin_col             = '1'
*      i_begin_row             = '3'
*      i_end_col               = '22'
*      i_end_row               = '99999'
*    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.
*  ELSE.
*    IF it_excel IS NOT INITIAL.
*      LOOP AT it_excel INTO is_excel.
*        ASSIGN COMPONENT is_excel-col OF STRUCTURE ls_final TO <fs>.
*        IF sy-subrc = 0.
*          <fs> = is_excel-value.
*          AT END OF row.
*            APPEND ls_final TO lt_final.
*            CLEAR ls_final.
*          ENDAT.
*        ENDIF.
*      ENDLOOP.
*    ELSE.
*      MESSAGE 'No data found'(004) TYPE 'I'.
*      LEAVE TO TRANSACTION sy-tcode.
*    ENDIF.
*  ENDIF.

Comments

Post a Comment

Popular posts from this blog

ABAP Open/ Fetch Cursor

  The Open SQL statement OPEN CURSOR opens a database cursor for the result set of the main query defined after FOR and links a cursor variable dbcur with this database cursor. The results set of the main query can be read with the statement FETCH. If the addition WITH HOLD is specified, the database cursor is not closed by a database commit executed using Native SQL. Syntax OPEN CURSOR  [ WITH HOLD ]  @dbcur | @DATA(dbcur) FOR    [ WITH     +cte1 AS ( SELECT  subquery_clauses  ) [ ,     +cte2 AS ( SELECT  subquery_clauses  )     ... ] ]   SELECT  mainquery_clauses    [ UNION ... ]    [ UP TO ... ]   [ OFFSET ... ]    [ abap_options ] . Fetch cursor The  Open SQL  statement  FETCH  extracts the requested rows (using the addition  INTO  or  APPENDING ) from the results set of the  database cursor ...
Read more

FP_JOB_CLOSE throws an exception. (sy-subrc 2: system error)

Hi, We have a report which generates PDF documents. During the process the FM FP_JOB_CLOSE throws an exception. (sy-subrc 2: system error). Interesting part is that, it works fine in development and integration system. But throws this exception only in Q. Here is the error message i can see in debug mode: Reference :  https://community.sap.com/t5/application-development-and-automation-discussions/the-fm-fp-job-close-throws-error/td-p/12719075 Refer:   Usage and System Error in SAP Adobe Refer:  ADS: SOAP Runtime Exception: CSoapExceptionTransport :(100101) CX_FP_RUNTIME_SYSTEM ADS_NO_RESULT F23D9BD05B30754F85AE6E206713113B SPOOL_NO_XDC 74D76E3FEABD6C61E10000000A1550A8 ADS_ERROR 594E4D42A52F4778E10000000A1551FF RFC_ERROR C621084226C43C11E10000000A1551FF SOAP_ERROR B84D4D42A52F4778E10000000A1551FF CX_ROOT TEXTID B84D4D42A52F4778E10000000A1551FF PREVIOUS {O:INITIAL} KERNEL_ERRID IS_RESUMABLE CX_ROOT 16AA9A3937A9BB56E10000000A11447B INTERNAL_SOURCE_PO...
Read more

rough notes

Image
 BAL_DB_SEARCH      AIN -Asset Intelligence Network      /n/GRCPI/GRIA_EAM   https://community.sap.com/t5/technology-blogs-by-sap/benefit-from-sap-master-data-governance-on-sap-s-4hana-2023-feature-pack/ba-p/13808294 https://codesap.wordpress.com/2015/01/21/debug-smartforms-in-production-environment/   https://community.sap.com/t5/application-development-and-automation-blog-posts/debugging-smart-forms-in-production-environment/ba-p/13245694 https://sapcodes.com/2015/11/19/debugging-a-smartform/ https://codesap.wordpress.com/tag/debug-smartform/ https://www.indexit.org/how-to-debug-smartforms-in-sap-abap/ https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-data-from-dynamic-internal-table/m-p/5345410 https://www.sapnet.ru/abap_docu/ABAPMODIFY_ITAB.htm#&ABAP_VARIANT_3@3@ ========================== Profile for Maintaining Task Lists   Relationships ==>The chronological order and time-based de...
Read more