READ TABLE TAB1 INDEX 1. 只查找设置的字段: READ TABLE TAB1 COMPARING <f1> <f2> . . . . 查找内表所有字段 READ TABLE TAB1 COMPARING ALL FIELDS. 只输出设置字段 READ TABLE TAB1 TRANSPORTING <f1> <f2> . . . . 不输出任何字段: READ TABLE TAB1 TRANSPORTING NO FIELDS.
APPEND/INSERT…INDEX用于排序表时条件:附加/插入时一定要按照Key的升序来附加;如果是Unique排序表,则不能附加/插入重附的数据,这与INSERT…INTO TABLE是不一样的 READ TABLE<itab>INDEX<idx> INTO<wa> [COMPARING<f1><f2> ...|ALL FIELDS] [TRANSPORTING<f1><f2> ...|ALL FIELDS|NO FIELDS] |ASSIGNING<...
一般是把对应的数据获取到内表中,然后对内表进行正序排序,然后在去重,之后再LOOP 循环中通过read 的方式读到工作区在赋值. 代码语言:javascript 代码运行次数:0 select 数据1,数据2from 透明表 into table 内表.sort 内表 by 数据1数据2.DELETEADJACENTDUPLICATESFROMitab(内表名)COMPARING针对的字段.loop 内表 ...
READ statement uses a WHILE loop to read all lines of the table sflight_tab one after the other using the primary table index in the work area sflight_wa. Only fields that are also in the output are transported. The COMPARING addition is used to select all flights in which no se...
DATA ITAB_HASHED TYPE HASHED TABLE OF MARA WITH UNIQUE DEFAULT KEY. [ WITH [UNIQUE | NON-UNIQUE] {{KEY [primary_key [ALIAS key_name] COMPONENTS] comp1 comp2 ...} | {DEFAULT KEY} } ]"主键索引 [ WITH {UNIQUE HASHED}|{UNIQUE SORTED}|{NON-UNIQUE SORTED}"secondary_key1,第二索引 ...
一般是把对应的数据获取到内表中,然后对内表进行正序排序,然后在去重,之后再LOOP 循环中通过read 的方式读到工作区在赋值. select 数据1, 数据2 from 透明表 into table 内表 . sort 内表 by 数据1 数据2 . DELETE ADJACENT DUPLICATES FROM itab(内表名) COMPARING针对的字段. ...
delete adjacent duplicates from ta1 comparing uname. write: / ‘ソート後の結果’. loop at ta1 into wk1. write: / wk1-uname,wk1-age. endloop. endform. part5:内部テーブルの更新(modify、where、transporting、指针field-symbols可以边读边改) form changedata. wk1-uname = ‘田中’. wk1-unam...
INTO <wa> [COMPARING <f1><f2> ...|ALL FIELDS][TRANSPORTING <f1><f2> ...|ALL FIELDS|NO FIELDS]READ TABLE <itab> FROM <wa>…以表关键字为查找条件，条件值来⾃<wa> COMPARING：系统根据<k1>...<kn>（关键字段）读取指定的单⾏与⼯作区<wa>中的相应组件进⾏⽐较。如果系统找根据...
DELETE ADJACENT DUPLICATES FROM itab COMPARING <字段名>. 2.将内表中的部分或全部的数据行整体插入另一个内表,如果需要放入末尾使用APPEND INSERT LINES OF itab1 (FROM 2 TO 4) INTO itab2 (INDEX 4). INSERT LINES OF itab1 (FROM 2) INTO itab2 (INDEX 4). ...
0Row is found.sy-tabixis set to the row number of the entry in the primary or secondary table index used. If ahash keyis used, it is set to 0. 2Likesy-subrcequals 0. Distinguishes cases that use the additionCOMPARINGinresult.