将每行记录的数据拆分为多行直接塞入到DATA表而不分到DATA1~DATA4中并将每行记录占用的行数通过字段返回客户端根据每行记录占用的data行数重新拼接data使用。 RFC_READ_TABLE源码中,在SELECT. ENDSELECT.语句中拼接处理字段,遇到大表效率非常低 代码语言:javascript 复制 SELECT * FROM (QUERY_TABLE) INTO <WA>...
利用关键字读取数据 READ TABLE itab FROM wa1 INTO wa2.READ TABLE itab WITH TABLE KEY k1 = f1 k2 = f2 ... kn = fn INTO wa. 案例代码演示(不使用TABLE KEY) DATA:GT_SFLIGHT TYPE TABLE OF SFLIGHT WITH NON-UNIQUE KEY CARRID,GS_SFLIGHT TYPE SFLIGHT,GS_SFLIGHT1 TYPE SFLIGHT,GS_SFL...
READTABLEitabFROMwa1INTOwa2.READTABLEitabWITHTABLEKEYk1=f1 k2=f2...kn=fnINTOwa. - 案例代码演示(不使用TABLE KEY) 代码语言:javascript 复制 DATA:GT_SFLIGHTTYPETABLEOFSFLIGHTWITHNON-UNIQUEKEYCARRID,GS_SFLIGHTTYPESFLIGHT,GS_SFLIGHT1TYPESFLIGHT,GS_SFLIGHT2TYPESFLIGHT.GS_SFLIGHT-CARRID='AC'.GS...
#SELECT*FROM(QUERY_TABLE)INTO<WA>WHERE(OPTIONS).SELECT*FROM(QUERY_TABLE)INTO<WA>WHERE(OPTIONS)ORDERBYPRIMARYKEY. 2. DATA数据长度限制 此函数一次性查询的字段不可过多,总长度超过DATA字段类型长度512时将抛出异常DATA_BUFFER_EXCEEDED 解决办法 将返回结果按512长度拆分到多个data table返回 FUNCTIONZRFC_REA...
SELECT SINGLE f1 AS my_f1, f2 AS abc FROM dbtab INTO DATA(ls_struct) WHERE ... WRITE: / ls_struct-my_f1, ls_struct-abc. 2. Table Expressions If a table line is not found, the exception CX_SY_ITAB_LINE_NOT_FOUND is raised. No sy-subrc. Before 7.40 With 7.40 Read Table inde...
READ TABLE c_edidd[] INTO idoc_data INDEX 1. CHECK idoc_data-segnam EQ 'E1EDK01'. MOVE idoc_data-sdata TO ls_e1edk01. lv_ebeln = ls_e1edk01-belnr. IF lv_ebeln IS NOT INITIAL. *Field lv_message is the output type message where the form is configured ...
and there is no syntactical error when I execute the program pls help me get data into "wa_it_ekpo".. LOOP AT it_lips into wa_it_lips. MOVE-CORRESPONDING wa_it_lips TO wa_asnmain_ref. SORT it_ekpo DESCENDING by ebeln ebelp . READ TABLE it_ekpo INTO wa_it_ekpo WITH KEY ebeln ...
READ TABLE simplified_range INTO DATA(range_line_gt_excluding) WITH KEY sign = 'E' option = 'GT'. IF sy-subrc EQ 0. IF range_line_gt_excluding-low GT range_line_gt-low. max_date = range_line_gt_excluding-low - 1. RETURN. ENDIF. ELSE. max_date = '99991231'. RETURN. ENDIF. ...
Sharepoint CSV-File integration in Datasphere's Data Flow leads to an error Hello everyone,we are currently trying to establish a connection between SAP Datasphere and a customer's SharePoint.To do this, we followed the instructions described in the following blog entry...https://community.sap...
FORM read_data . ***CALL FUNCTION*** CALL FUNCTION'DDIF_FIELDINFO_GET'EXPORTING tabname = table "自己输的表名 fieldname = field "字段 langu = sy-langu "语言码 TABLES dfies_tab = itab " like table dfies. EXCEPTIONS not_found = 1 internal...