DATA ITAB_SORTED TYPE SORTED TABLE OF MARA WITH NON-UNIQUE KEY TABLE_LINE. *HASHED TABLE:只能为WITH UNIQUE KEY。 DATA ITAB_HASHED TYPE HASHED TABLE OF MARA WITH UNIQUE DEFAULT KEY. [ WITH [UNIQUE | NON-UNIQUE] {{KE
1, 必须指定KEY(作为排序参考字段),可以指定UNIQUE KEY或者是NON-UNIQUE KEY 2, 可以使用INDEX和KEY来查询 3, 已经按照KEY排序,不可以再排序 举例:DATA IT_YM TYPE SORTED TABLE OF VBAP WITH NON-UNIQUE KEY VBELN. 在记录条数多时,SORTED TABLE查询效率明显比STANDARD TABLE高,因为对已经排序的表可以进行二...
END OF ty. DATA it2 TYPE TABLE OF ty WITH KEY a. DATA wa like LINE OF it. DATA aa TYPE SORTED TABLE OF ty WITH UNIQUE KEY a WITH NON-UNIQUE SORTED KEY second_key COMPONENTS b c. aa = VALUE #( ( a = 11 b = 32 c = 13 ) ( a = 21 b = 22 c = 23 ) ( a = 31 ...
也具有一个逻辑索引,不同的是排序表总是按照其表关键字升序排序后再进行存储,其访问方式与标准表相同 DATA:ITAB TYPE SORTED TABLE OF LINE_type with unique non-unique key keyname. 1. 2. 3. 1.3.哈希表(hashed table) 没有索引,只能通过关键字来访问,系统用哈希算法来管理表中的数据 data:itab type ...
DATA:itabTYPE[STANDARD|SORTED|HASHED]TABLEOF<t_str>WITH{UNIQUE|NON-UNIQUE}KEY<keys>[INTIALSIZE<n>]. - 示例代码 代码语言:javascript 代码运行次数:0 运行 AI代码解释 TYPES:BEGINOFS_SFLIGHT,Z_CARRIDTYPESFLIGHT-CARRID,Z_CONNIDTYPESFLIGHT-CONNID,Z_FLDATETYPESFLIGHT-FLDATE,Z_PRICETYPESFLIGHT-PRI...
WITH NON-UNIQUE SORTED KEY occupied_seats COMPONENTS seatsocc, sflight_wa LIKE LINE OF sflight_tab. ... SELECT * FROM sflight WHERE carrid = 'LH' AND connid = '400' INTO TABLE @sflight_tab. ... DO 10 TIMES. READ TABLE sflight_tab ...
WITH UNIQUE KEY col1 col2 ... WITH NON-UNIQUE SORTED KEY second_key COMPONENTS col3 col4 ... "fill itab with a large amount of data ... ASSIGN itab[ KEY second_key COMPONENTS col3 = ... col4 = ... ] TO ... ...
WITHNON-UNIQUESORTEDKEYcarr_cityCOMPONENTScarrid,lt_lhTYPETABLEOFspfli.SELECT*INTOTABLElt_spfliFROMspfli."data(lt) = FILTER #( lt_spfli using key carrid where carrid = '1' ).lt_lh=FILTER#(lt_spfliusingkeycarr_citywherecarrid=conv#('LH')).BREAK-POINT.filter 之前：filter 之后：第二个...
TYPES:t_itab TYPE [STANDARD|SORTED|HASHED] TABLE OF <t_str> WITH {UNIQUE|NON-UNIQUE} KEY <keys>[INTIAL SIZE <n>]. [STANDARD|SORTED|HASHED]为可选参数,从左到右分别对应标准表,排序表和哈希表;若不指定该参数则默认为标准表 [INTIAL SIZE ]为可选参数,可以指定定义的内表的大小 ...
–排序表SORTED TABLE 具有逻辑索引 寻址操作通过关键字或者索引 按表关键字升序后存储 –哈希表HASHEDTABLE 没有逻辑索引 寻址操作只通过关键字 •行类型 基本类型结构体内表 •表关键字 –行结构为结构体 WITH [UNIQUE|NON-UNIQUE] KEY comp1 … compn ...