READ TABLE TBA1 INTO INTO LS_TAB1 WITH KEY ID = '01' NAME = 'ZS' BINARY SEARCH. 如果TAB1内表是根据ZFIT001自建表定义的,而ZFIT001-ID字段长度定义为了字符串三位,那么可能由于数据导入的过程中存在‘01’后面多了一个空格,从而导致获取不到数据的情况。 补充READ TABLE的使用方式: 通过主键查找(WI...
READ命令使用顺序查找数据表,这会降低处理速度。取而代之,使用binary search的附加命令,可以使用二分查找算法,可以帮助加快内表查找速度。 在使用binary search之前必须首先将内表排序,否则有可能找不到记录,因为二分查找反复将查找区间对半划分,如果要查找的值小于查找区间的中间位置的数据项值,则查找区间将缩小到前半...
READ TABLE TAB2 WITH KEY COLUMN1 = '0800113864' COLUMN2 = '2012' COLUMN3 = '3018054318' BINARY SEARCH. 返回SY-SUBRC = 8. 即查询没有相关数据! 这就是问题的情况所在!! 我发现问题的过程可以理解为如下步骤: 1. 首先定位到5条记录的中间那条记录,即第3条记录,然后对比COLUMN3。 2. 第3条记录...
按具体值读取:READ TABLE itab WITH [TABLE] KEY k1=v1...kn=vn [BINARY SEARCH]. 读取具体行数据: READ TABLE itab INDEX i. LOOP循环常用于实现内表数据的循环读取和操作 注意: 1、 使用 READ 操作的表必须得 HEADER LINE 作为查找出的数据存储窗口 2、 BINARY SEARCH 可以提高内表数据查找的速度,但...
READ TABLE lt_b TRANSPORTING NO FIELDS WITH KEY f1 = lw_a-f1 BINARY SEARCH. IF sy-subrc = 0. LOOP AT lt_b INTO lw_b FROM sy-tabix. IF lw_b-f1 <> lw_a-f1. EXIT. ENDIF. CLEAR lw_c. lw_c-f1 = lw_a-f1. lw_c-f2 = lw_a-f2. ...
select * into table lt_mardh from mardh where matnr in s_matnr and werks in s_werks and lgort in s_lgort. sort lt_mardh by matnr werks lgort lfgja lfmon. "先根据二分查找,查找到大于等于当前条目且最接近当前条目的索引 read table lt_mardh with key …… binary search transporting no ...
Now, I am sorting the above internal table as follows: sort itab by A B C descnding. Now, I am writing the read stmt as follows: read table itab into wa_itab with key A = var1 B = var2 C = car3 Binary Search. But, the read fails in most of the cases even though the...
不推荐Readtable int_fligh with key airln=‘LF’.推荐Readtable int_fligh with key airln=‘LF’ binary search. 7、两个内表添加使用批量增加代替逐行 不推荐 Loop at int_fligh1. Append int_fligh1 to int_fligh2. Endloop. 推荐 Append lines of int_fligh1 to int_fligh2. ...
READ TABLE lt_marc INTO lw_marc WITH KEY taskname = g_taskname BINARYSEARCH. MOVE-CORRESPONDING wa_md TO wa_output. wa_output-matnr = lw_marc-matnr. wa_output-werks = lw_marc-werks. APPEND wa_output TO it_output. CLEAR:wa_output,wa_md,lw_marc. ...
* READ TABLE it_fcat_b INTO DATA(lw_fcat_b) WITH KEY fieldname = lw_fieldname_temp-fieldname BINARY SEARCH. * IF sy-subrc = 0. * APPEND lw_fcat_b TO lt_fieldcat. * ELSE. CLEAR:lw_fcat_b. CASE lw_fieldname_temp-fieldname. ...