查询多条数据是使用内表,须使用APPENDING,不能使用INTO,INTO是删除内表数据后插入时使用的。 SELECT...INTO|APPEND[CORRESPONDINGFIELDSOF]<wa>TABLE<itab>[PACKAGE SIZE<n>].. PACKAGE SIZE:表示每次追加到内表的条数,此时须使用ENDSELECT. SELECTINTOCORRESPONDINGFIELDSOFTABLEitab PACKAGE SIZE5FROMSPFLI.ENDSELEC...
... INTO CORRESPONDING FIELDS OF <work area> ''匹配赋值 ... INTO (f1, ..., fn) 变量组. ... INTO TABLE <internal table> ... INTO CORRESPONDING FIELDS OF TABLE <internal table> ... APPENDING TABLE <internal table> ... APPENDING CORRESPONDING FIELDS OF TABLE <internal table> 举例一:...
LT_TABLE=VALUE #( ( MATNR = 'Material-001' MTART='FOOD' ) (MATNR = 'Material-002' MTART='WATR') ). CALLMETHOD CL_DEMO_OUTPUT=>WRITE( LT_TABLE ). LT_TABLE=CORRESPONDING #( BASE ( LT_TABLE ) LT_DATA EXCEPT MATKL ). CALLMETHOD CL_DEMO_OUTPUT=>WRITE( LT_TABLE ). CALLMETHOD C...
例如:取内表某一列的最大值,就可以直接MAX,无需排序后,读第一行, 需要append a表 to B表时,但A表字段与B表字段数量不一致时,可以使用 代码语言:javascript 代码运行次数:0 运行 AI代码解释 SELECTFROM@a表ASaFIELDSfield1APPENDINGCORRESPONDINGFIELDSOFTABLE@b表. 前导0处理 代码语言:javascript 代码运行次数:...
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,第二索引 ...
DATA:t_comp TYPE TABLE OF string. APPEND 'carrid' TO t_comp. APPEND 'connid' TO t_comp. SELECT (t_comp) FROM sflight INTO CORRESPONDING FIELDS OF TABLE lt_sflight. ENDFORM. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11.
例2:直接声明一个work area,注意复制语句move-corresponding的用法 内表Internal Table 存储多行多列的结构型数据类型,相当于一个数据库table Internal table数据类型(types)的声明 Internal table对象(data)的声明 根据已声明的internal table数据类型来声明table对象 ...
"下拉列表 APPEND gs_fieldcat TO gt_fieldcat. END-OF-DEFINITION. INITIALIZATION. START-OF-SELECTION. PERFORM frm_get_data. PERFORM frm_dis_data. FORM frm_get_data. SELECT * INTO CORRESPONDING FIELDS OF TABLE gt_tab FROM sflight . ENDFORM. FORM frm_dis_data. CLEAR:gs_layout. gs_layout...
33、a1 PACKAGE SIZE n1 INTO CORRESPONDING FIELDS OF TABLE tabla1 PACKAGE SIZE n1 APPENDING TABLE tabla1 PACKAGE SIZE n1 APPENDING CORRESPONDING FIELDS OF TABLE tabla1 PACKAGE SIZE n1LEAVE: LEAVE LEAVE PROGRAM LEAVE TO TRANSACTION tac1 AND SKIP FIRST SCREEN LEAVE TO SCREEN dynp1 LEAVE SCREEN LEAV...
UP TO 18000 ROWS "数据条目18000 INTO CORRESPONDING FIELDS OF TABLE it_marc FROM marc WHERE matnr IN s_matnr AND werks IN s_werks. LOOP AT it_marc INTO wa_marc. * 生成任务名称 = 'Task' + sy-tabix Start--* WRITE sy-tabix TO g_taskname. CONDENSE g_taskname. CONCATENATE 'Task' ...