背景:在SAP ERP中需要读取外围系统的数据库表数据,进行使用处理。
解决办法:先配置远程RFC系统,再调用远程读取函数RFC_READ_TABLE.
REPORT y_test_0002.
DATA:lt_options TYPE TABLE OF rfc_db_opt,
wa_options TYPE rfc_db_opt,
lt_fields TYPE TABLE OF rfc_db_fld,
wa_fields TYPE rfc_db_fld,
lt_data TYPE TABLE OF tab512.
wa_fields-fieldname = 'VKORG'.
wa_fields-offset = ' '.
wa_fields-length = '4'.
wa_fields-type = 'c'.
wa_fields-fieldtext = 'VKORG'.
append wa_fields to LT_fields. "输出的字段
CONCATENATE 'MATERIAL = '0000000017''' INTO wa_options-text. "SELECT后面的条件
APPEND wa_options TO lt_options.
CALL FUNCTION 'RFC_READ_TABLE' DESTINATION 'XXXQ800' "XXXQ800为远程RFC
EXPORTING
query_table = 'ZDB_018'
* DELIMITER = ' '
*