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.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
104 | report painter 설명 자료 [20] | 조재경 | 2012.06.09 | 15539 |
103 | CO CCA Process Overview 자료 입니다. [20] | yaho | 2012.06.28 | 6662 |
102 | abap 교재 요약 워드 파일입니다... [45] | 준맘 | 2012.08.07 | 17194 |
101 | class-based exceptions 예제. | 철죽1 | 2012.09.02 | 12263 |
100 | shared objects 예제 | 철죽1 | 2012.09.02 | 5419 |
99 | create object 예. [1] | 철죽1 | 2012.09.02 | 12900 |
98 | casting 예 [1] | 철죽1 | 2012.09.02 | 11472 |
97 | constructor multiple instantiation 예 | 철죽1 | 2012.09.02 | 11687 |
96 | instance vs static 예 [1] | 철죽1 | 2012.09.02 | 12617 |
95 | method create 예 | 철죽1 | 2012.09.02 | 11643 |
94 | selection screen program [1] | 철죽1 | 2012.09.02 | 5571 |
93 | tabstrip [5] | 철죽1 | 2012.09.02 | 12134 |
92 | lock 예 [5] | 철죽1 | 2012.09.02 | 13216 |
91 | POC 예 [9] | 철죽1 | 2012.09.02 | 11105 |
90 | sap 튜닝 자료입니다. [44] | iop890mm | 2012.10.09 | 12663 |
89 | gdb형식의 abap 강좌입니다. [6] | tobypapa | 2012.10.19 | 10981 |
88 | 파일 첨부 - 한개씩 말고 다중으로 가능? [1] | 연오랑 | 2012.10.23 | 12696 |
87 | ABAP Troubleshooting [4] | paran | 2012.11.13 | 14591 |
86 | ABAP Tunning Guide [2] | 민상애비 | 2012.11.14 | 15682 |
85 | Technical Guide-ABAP Tuning 기초 [5] | 민상애비 | 2012.11.14 | 13078 |
좋은 자료 감사합니다!