1、找最大年月的某物料的销售数量 SELECT*INTOTABLE@DATA(LT_ZTSD119_PIE)FROMZTSD119_PIEWHEREMATNRIN@S_MATNRANDGJAHR = (SELECTMAX( GJAHR )FROMZTSD119_PIE )ANDMONAT = (SELECTMAX( MONAT )FROMZTSD119_PIEWHEREGJAHR = (SELECTMAX( GJAHR )FROMZTSD119_PIE ) )."取最大年月的PIE导入数据 相当于月份...
DATA: carrid TYPE scarr-carrid, carrname TYPE scarr-carrname. CARRNAME LIKE SCARR-CARRNAME, SELECT carrid carrname INTO (carrid, carrname) FROM scarr. WRITE: / carrid, carrname. ENDSELECT. 3.* INTO TABLE itab 4.* INTO CORRESPONDING FIELDS OF TABLE itab 这两个语句的区别同into w...
@DATA 按取数指定的字段定义内表结 定义工作区: SELECT SINGLE * FROM lfbk INTO @DATA(is_lfbk) WHERE lifnr EQ @gs_zmmtd049-lifnr. CONCATENATE is_lfbk-bankn is_lfbk-bkref INTO gs_zmmtd049-bankn. CONDENSE gs_zmmtd049-bankn. SELECT * INTO TABLE @DATA(lt_plaf) FROM plaf WHERE plwrk ...
SELECT*FROMspfliINTOTABLE@DATA(lt_table) UPTO3ROWS. DATA(lv_lines) =lines( lt_table ). DATA(lv_exist) = xsdbool( line_exists( lt_table[ carrid ='AZ'] ) ). DATA(lv_index) = line_index( lt_table[ carrid ='AZ'] ). *将日期转换为系统格式 *这里date= environment是用来格式化日期...
SELECTDISTINCT<fields>INTO<internal table>FROM<data source>[WHERE<condition>][GROUPBY<fields>][HAVING<condition>]. 其中, 指定要查询的字段列表,可以使用通配符 * 查询所有字段,也可以指定具体的字段名; 指定查询结果存储的内表; 指定要查询的数据源,可以是一个表、一个视图或者一个函数; 指定查询条件,可以...
select vbeln,POSNR,MATNR,MATWAfrom vbapASAinto table @data(lt_vbap).#通过inner join 将要两个内表相互关联 select a~vbeln,a~ERDAT,A~ERZET,A~ERNAM,B~POSNR,B~MATNR,B~MATWAFROM@LT_VBAPASAINNERJOIN@LT_VBAPASBONA~VBELN=B~VBELNINTOTABLE@DATA(LT_GATA). ...
data :gs_DAta TYPE ty_Data . data :gt_Data TYPE TABLE of ty_Data . 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 数据操作 select * from ZWDEMOTABLE1 into CORRESPONDING FIELDS OF TABLE gt_Data . sort gt_Data by doccode zrowid. ...
5. ... INTO TABLE @DATA(itab) [PACKAGE SIZE n] Effect The information after INTO or APPENDING specifies to which data objects the results set of a SELECT statement or a FETCH statement is assigned. The following: a single work area wa after INTO, a list (in parentheses) of data obj...
CREATE DATA dref1 TYPE (p_tname). ASSIGN dref1->* TO <fs1>. CREATE DATA dref2 LIKE TABLE OF <fs1>. ASSIGN dref2->* TO <fs2>. SELECT * FROM (p_tname) INTO TABLE <fs2> UP TO 5 ROWS. LOOP AT <fs2> INTO <fs1>.
Select into table DATA itab TYPE TABLE OF dbtab. SELECT * FROM dbtab INTO TABLE itab WHERE fld1 = lv_fld1. SELECT * FROM dbtab INTO TABLE @DATA(itab) WHERE fld1 = @lv_fld1. Select single into SELECT SINGLE f1 f2 FROM dbtab INTO (lv_f1, lv_f2) WHERE ... WRITE: / lv_...