엑셀 데이터를 SAP로 업로드하기 - 두 가지 함수 모듈 비교#

1TYPES: BEGIN OF t_matnr_char,
2         matnr TYPE matnr,
3         atnam TYPE atnam,
4         atwrt TYPE atwrt,
5       END OF t_matnr_char.
6
7DATA: gt_matnr_char TYPE STANDARD TABLE OF t_matnr_char,
8      lt_raw        TYPE truxs_t_text_data,
9      pa_file       TYPE rlgrap-filename.
10
11pa_file = 'C:\Users\example\upload.xlsx'.   " (예시) 경로
12
13CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
14  EXPORTING
15    i_line_header        = 'X'              " 첫 행을 헤더로 처리
16    i_tab_raw_data       = lt_raw
17    i_filename           = pa_file
18  TABLES
19    i_tab_converted_data = gt_matnr_char
20  EXCEPTIONS
21    conversion_failed    = 1
22    OTHERS               = 2.
23
24IF sy-subrc <> 0.
25  " 변환 실패 처리
26ENDIF.

1DATA: lt_xls     TYPE STANDARD TABLE OF alsmex_tabline,
2      i_begin_row TYPE i,
3      i_end_row   TYPE i.
4
5i_begin_row = 1.
6i_end_row   = 5000.
7
8CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
9  EXPORTING
10    filename                = pa_file
11    i_begin_col             = 1
12    i_begin_row             = i_begin_row
13    i_end_col               = 100
14    i_end_row               = i_end_row
15  TABLES
16    intern                  = lt_xls
17  EXCEPTIONS
18    inconsistent_parameters = 1
19    upload_ole              = 2
20    OTHERS                  = 3.