REPORT zmaster_upload.
TYPE-POOLS truxs.
SELECTION-SCREEN: BEGIN OF BLOCK a WITH FRAME TITLE text-001.
PARAMETER: p_table LIKE dd02l-tabname,
p_file LIKE rlgrap-filename. " DEFAULT 'c:tempzcvaa.csv'.
SELECTION-SCREEN: END OF BLOCK a.
DATA: it_tab TYPE REF TO data.
DATA: gt_table TYPE REF TO cl_salv_table.
CREATE DATA it_tab TYPE TABLE OF (p_table).
FIELD-SYMBOLS: <fs_tab> TYPE STANDARD TABLE.
ASSIGN it_tab->* TO <fs_tab>.
DATA: it_type TYPE truxs_t_text_data.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
CALL FUNCTION 'F4_FILENAME'
EXPORTING
field_name = 'P_FILE'
IMPORTING
file_name = p_file.
START-OF-SELECTION.
* uploading the data in the file into internal table
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
* I_FIELD_SEPERATOR =
* I_LINE_HEADER = 'X'
i_tab_raw_data = it_type
i_filename = p_file
TABLES
i_tab_converted_data = <fs_tab>
EXCEPTIONS
conversion_failed = 1
OTHERS = 2.
IF sy-subrc NE 0.
MESSAGE ID sy-msgid
TYPE sy-msgty
NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.
END-OF-SELECTION.
MODIFY (p_table) FROM TABLE <fs_tab>.
DESCRIBE TABLE <fs_tab> LINES DATA(dcr).
WRITE: dcr, 'lines got updated in table', p_table.
TYPE-POOLS truxs.
SELECTION-SCREEN: BEGIN OF BLOCK a WITH FRAME TITLE text-001.
PARAMETER: p_table LIKE dd02l-tabname,
p_file LIKE rlgrap-filename. " DEFAULT 'c:tempzcvaa.csv'.
SELECTION-SCREEN: END OF BLOCK a.
DATA: it_tab TYPE REF TO data.
DATA: gt_table TYPE REF TO cl_salv_table.
CREATE DATA it_tab TYPE TABLE OF (p_table).
FIELD-SYMBOLS: <fs_tab> TYPE STANDARD TABLE.
ASSIGN it_tab->* TO <fs_tab>.
DATA: it_type TYPE truxs_t_text_data.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
CALL FUNCTION 'F4_FILENAME'
EXPORTING
field_name = 'P_FILE'
IMPORTING
file_name = p_file.
START-OF-SELECTION.
* uploading the data in the file into internal table
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
* I_FIELD_SEPERATOR =
* I_LINE_HEADER = 'X'
i_tab_raw_data = it_type
i_filename = p_file
TABLES
i_tab_converted_data = <fs_tab>
EXCEPTIONS
conversion_failed = 1
OTHERS = 2.
IF sy-subrc NE 0.
MESSAGE ID sy-msgid
TYPE sy-msgty
NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.
END-OF-SELECTION.
MODIFY (p_table) FROM TABLE <fs_tab>.
DESCRIBE TABLE <fs_tab> LINES DATA(dcr).
WRITE: dcr, 'lines got updated in table', p_table.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
164 | FAQ ABOUT SQL [1] | sapjoy | 2007.03.30 | 3233 |
163 | ABAP TIP 모음 [4] | sapjoy | 2007.03.30 | 4673 |
162 | 함수를 이용한 ALV 따라하기 [11] | sapjoy | 2007.03.30 | 3304 |
161 | ABAP data type에 관한 자료입니다. [10] | SARA | 2007.03.29 | 7349 |
160 | 코딩 스탠다드-변수 네이밍 룰등.. [3] | SARA | 2007.03.29 | 5224 |
159 | SAP UNICODE란? [7] | SARA | 2007.03.29 | 6170 |
158 | Report Painter 설명 [10] | 나침반친구 | 2007.03.29 | 7572 |
157 | CTS OVERVIEW [1] | sapjoy | 2007.03.29 | 4760 |
156 | BSP 참고 자료 [4] | 안진명 | 2007.03.28 | 3378 |
155 | BADI for CMOD [4] | 마달수 | 2007.03.28 | 5525 |
154 | sap search help [14] | 쿠도스 | 2007.03.28 | 5209 |
153 | ALV 영문 자료 입니다. 다른 것과 비슷한 내용이네요. [1] | SARA | 2007.03.28 | 3569 |
152 | ABAP 소개 [1] | SARA | 2007.03.28 | 5213 |
151 | 인터널 테이블 자료 입니다. [8] | SARA | 2007.03.28 | 5135 |
150 | 14장 Enhancement-Exits [9] | sapjoy | 2007.03.28 | 6052 |
149 | The basics for SALV [17] | 펠릭스 | 2007.03.27 | 3986 |
148 | event handling for SALV [14] | 펠릭스 | 2007.03.27 | 4436 |
147 | SAP 오라클비교_검토자료 | SARA | 2007.03.27 | 6390 |
146 | Customer Order Creation Using BAPI [1] | 펠릭스 | 2007.03.27 | 3840 |
145 | 중요한 시스템 변수 [8] | 김성수 | 2007.03.27 | 4175 |
좋은 자료 감사합니다!