在工作中我们常常会需要将一些信息用EXCEL格式的附件发送给用户,本文就简单讲讲如何使用SO_NEW_DOCUMENT_ATT_SEND_API1发送EXCEL附件。
1、提取数据;
根据应用需求决定,本文以发送订单信息为例,代码略)
2、生成EXCEL格式的发送内表;
FORM Create_EXCELBody.
Data:
ls_tvbdpa LIKE vbdpa,
ls_text(18),
ls_line type string,
ls_size type so_obj_len,
ls_bezei type BEZEI60,
ls_remark TYPE tline,
ls_audat(10),
ls_bstdk(10),
ls_first(1).
DATA: ls_CONV_MAT LIKE VBDPR-MATNR.
DATA: ls_string type string.
DATA: lt_binxls type solix_tab.
DATA: wa_binxls type SOLIX.
ls_first = 'X'.
CLEAR: lt_texts, lt_texts[].
CALL FUNCTION 'READ_TEXT'
EXPORTING
client = sy-mandt
id = 'ST'
language = 'E'
name = 'Y0213SD_COO_NORMAL_NART_CHANGE'
object = 'TEXT'
TABLES
lines = lt_texts
EXCEPTIONS
id = 1
language = 2
name = 3
not_found = 4
object = 5
reference_check = 6
wrong_access_to_archive = 7
&