最新ABAP初级培训.ppt

8.内表处理-删除内表 删除选定行 DELETE itab [FROM n1] [TO n2] [WHERE condition]. DATA: BEGIN OF LINE, COL1 TYPE I, COL2 TYPE I, END OF LINE. DATA ITAB LIKE LINE OCCURS 10. DO 40 TIMES. LINE-COL1 = SY-INDEX. LINE-COL2 = SY-INDEX ** 2. APPEND LINE TO ITAB. ENDDO. DELETE ITAB FROM 3 TO 38 WHERE COL2 20. LOOP AT ITAB INTO LINE. WRITE: / LINE-COL1, LINE-COL2. ENDLOOP. 其输出为： 1 1 2 4 3 9 4 16 39 1.521 40 1.600 9.SQL语句 为了避免不同的数据库表之间的不兼容性，并使ABAP/4 程序能在应 用中独立于数据库系统，SAP 创建了一套叫作开放式SQL的独立SQL语 句。开放式SQL包含了一套标准的SQL 语句以及一些专用于SAP 的增 强语句。使用开放式SQL，可以访问对SAP 系统有效的任何数据库表， 而不用考虑它的创建者。 返回码： SY-SUBRC，0为成功，其他的则否 SY-DBCNT，返回经操作的行数 9.SQL语句-读取数据 SELECT resultINTO targetFROM source[WHERE condition] [GROUP BY fields][HAVING cond][ORDER BY fields]. SELECT result The SELECT clause defines the structure of the data you want to read, that is, whether one line or several, which columns you want to read, and whether identical entries are acceptable or not. INTO target The INTO clause determines the target area target into which the selected data is to be read. FROM source The FROM clause specifies the database table or view source from which the data is to be selected. It can also be placed before the INTO clause. WHERE cond The WHERE clause specifies which lines are to be read by specifying conditions for the selection. GROUP BY fields The GROUP-BY clause produces a single line of results from groups of several lines. A group is a set of lines with identical values for each column listed in fields. HAVING cond The HAVING clause sets logical conditions for the lines combined using GROUP BY. ORDER BY cond The ORDER-BY clause defines a sequence fields for the lines resulting from the selection. 9.SQL语句-读取数据 SELECT 1.读取单行：SELECT SINGLE cols ... WHERE ... 2.读取多行：SELECT [DISTINCT] cols ... WHERE ...。这里的INTO后面的目标区域是内表，如果INTO后面的是工作区，则用： SELECT [DISTINCT] cols ... WHERE ...