REPORT zsmw0010.
*&---------------------------------------------------------------------*
*& Include
*&---------------------------------------------------------------------*
INCLUDE officeintegrationinclude.
*">> Data Define
DATA: i TYPE i VALUE 2.
CONSTANTS: l_object_id(250) TYPE c VALUE 'ZTEST',
l_dest TYPE rlgrap-filename VALUE 'C:TEST.XLS'.
*">> Internal table
DATA: lt_data_table LIKE w3mime OCCURS 0 WITH HEADER LINE.
DATA: BEGIN OF it_tab OCCURS 0.
DATA: kunnr LIKE kna1-kunnr,
lifnr LIKE lfa1-lifnr,
bukrs LIKE bkpf-bukrs,
telno(20) TYPE c.
DATA: END OF it_tab.
*">> STRUCTURES
DATA : ls_key LIKE wwwdatatab.
*&---------------------------------------------------------------------*
*& Object
*&---------------------------------------------------------------------*
DATA : excel TYPE ole2_object,
books TYPE ole2_object,
book TYPE ole2_object,
sheet TYPE ole2_object,
cell TYPE ole2_object.
*&---------------------------------------------------------------------*
*& Start-of-selection
*&---------------------------------------------------------------------*
START-OF-SELECTION.
*">> 임의 데이터
it_tab-kunnr = '00000A1000'.
it_tab-lifnr = '00000B1000'.
it_tab-bukrs = 'A000'.
it_tab-telno = '010-3333-3333'.
APPEND it_tab.
it_tab-kunnr = '00000C1000'.
it_tab-lifnr = '00000D1000'.
it_tab-bukrs = 'B000'.
it_tab-telno = '011-3333-3333'.
APPEND it_tab.
*">> Data Check
CALL FUNCTION 'SAP_OI_LOAD_MIME_DATA'
EXPORTING
object_id = l_object_id
TABLES
data_table = lt_data_table
EXCEPTIONS
object_not_found = 1
internal_error = 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.
ls_key-relid = 'MI'. "// IMPORT
ls_key-objid = l_object_id.
CALL FUNCTION 'DOWNLOAD_WEB_OBJECT'
EXPORTING
key = ls_key
destination = l_dest. " 저장위치
CREATE OBJECT EXCEL 'EXCEL.APPLICATION'.
SET PROPERTY OF EXCEL 'VISIBLE' = 1.
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
669 | REPORT Z06_01. | sapjoy | 2024.04.20 | 18 |
668 | REPORT z05_36 | sapjoy | 2023.02.07 | 245 |
667 | z15_21_drag | sapjoy | 2022.02.24 | 269 |
666 | Z18_06_DRAGCLASS | sapjoy | 2022.02.22 | 296 |
665 | API | sapjoy | 2022.11.02 | 317 |
664 | REPORT z10_02. | sapjoy | 2012.07.30 | 779 |
663 | REPORT Z11_09. | sapjoy | 2012.07.30 | 780 |
662 | REPORT Z11_04 . | sapjoy | 2012.07.30 | 786 |
661 | REPORT Z11_03. | sapjoy | 2012.07.30 | 795 |
660 | REPORT z11_05. | sapjoy | 2012.07.30 | 797 |
659 | REPORT z14_13. | sapjoy | 2012.08.01 | 798 |
658 | REPORT z14_09. | sapjoy | 2012.08.01 | 800 |
657 | REPORT Z11_08. | sapjoy | 2012.07.30 | 805 |
656 | REPORT z08_05. | sapjoy | 2012.07.30 | 809 |
655 | REPORT z10_06. | sapjoy | 2012.07.30 | 813 |
654 | REPORT z05_14. | sapjoy | 2012.07.30 | 814 |
653 | REPORT Z05_32. | sapjoy | 2012.07.30 | 816 |
652 | REPORT z08_03. | sapjoy | 2012.07.30 | 817 |
651 | REPORT z10_11. | sapjoy | 2012.07.30 | 817 |
650 | REPORT Z12_03 | sapjoy | 2012.07.30 | 818 |