案例说明 RFC读取表中数据. Import 参数名称 Type spec. 参考打印 FIELDS_NAME1 TYPE CHAR25 TABLE_NAME1 TYPE CHAR25 WHERE_NAME1 TYPE CHAR256 FIELDS_NAME2 TYPE CHAR25 TABLE_NAME2 TYPE CHAR25 WHERE_NAME2 TYPE CHAR256 Tables 参数名称 Type spec. 参考打印 ITAB LIKE ZTABDATA ZTABDAT
DATA: EXCEL TYPE OLE2_OBJECT, SHEET TYPE OLE2_OBJECT, CELL TYPE OLE2_OBJECT, WORKBOOK TYPE OLE2_OBJECT, XLSNAME TYPE STRING VALUE 'C:\sap_usr02.xls', LINE TYPE I VALUE 0. "行号 CREATE OBJECT EXCEL 'EXCEL.APPLICATION'.
1.include data: begin of gth_qamr. include structure qamr. data: kurztext like qamv-kurztext, ztext like qamv-kurztext, verwmerkm like qamv-verwmerkm, steuerkz like qamv-steuerkz. data: end of gth_qamr. data: gtd_qamr like
在SQL SERVER中获取表中的第二条数据, 思路:先根据时间逆排序取出前2条数据作为一个临时表,再按顺时排序在临时表中取出第一条数据 sql语句如下: select top 1 * from(select top 2 * from NumberLog where UserName = '管理员' order by dateTime desc ) [table] order by dateTime asc