【SAP】ABAP ——读取外围系统数据库表

背景：在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                  = ' '
*