ABAP之SQL操作（select、update、delete）

SELECT <lines>[DISTINCT]<columns>[AS<alias>]
          INTO|APPEND [CORRESPONDING FIELDS OF]<wa> TABLE<itab>[PACKAGE SIZE<n>]..
          FROM <dbtab>[AS <alias>]<options>  UP TO <n> ROWS...
            [INNER]JOIN <dbtab> [AS <alias>] ON <cond><options>...
          WHERE <s> <opertor> <f> ...
          GROUP BY <f1> <f2>..
          HIVING <condition>.
          ORDER BY PRIMARY KEY.

SELECT SINGLE <cols> ... WHERE

SELECT [DISTINCT]<cols>...WHERE   

SELECT  <cols> [AS <cols>]..

SELECT  ...INTO [CORRESPONDING FIELDS OF]<wa> .

 SELECT ...INTO|APPEND [CORRESPONDING FIELDS OF]<wa> TABLE<itab>[PACKAGE SIZE<n>]..

  SELECT INTO CORRESPONDING FIELDS OF TABLE itab 
    PACKAGE SIZE 5
    FROM SPFLI.
  ENDSELECT.

 SELECT ...FROM <dbtab>[AS <alias>]<options>

SELECT ...FROM <tab>[INNER] JOIN <dbtab> [AS <alias>] ON <cond><options>...

SELECT ...FROM <tab> UP TO <n> ROWS...

SELECT ...WHERE <s> <opertor> <f> ...

  SELECT ...WHERE <s> [NOT]BETWEEN <f1> AND <F2>.
  SELECT ...WHERE COL2 LIKE ‘_ABC%‘.
  SELECT ...WHERE <s> [NOT]IN (<f1>,..,<fn>)...
  SELECT ...WHERE <s> [NOT]IN <seltab>... 查询存在selection table，Range变量里的数据。

SELECT ... FOR ALL ENTRIES IN <itab> WHERE <cond>    

SELECT <f1> <f2> <agg>...
    GROUP BY <f1> <f2> ...
    HIVING <condition>.

SELECT ...
  ORDER BY <f1> [ASCENDING|DESCENDING] 
           <f2> [ASCENDING|DESCENDING] 

INSERT INTO <target> VALUES <wa>.
INSERT <target> FROM <wa>.

INSERT <target> FROM TABLE <itab> [ACCEPTING DUPLICATE KEYS]

UPDATE <target> FROM <wa>.  "表结构相同

UPDATE <target> FROM TABLE <itab>. 
UPDATE <target> SET <set1> <set2> WHERE <cond>.

DELETE <target> FROM <wa>.  "表结构相同

DELETE  FROM <target> WHERE <cond>. 

MODIFY <target> FROM <wa>.  "表结构相同

MODIFY   <target> FROM TABLE <itab>.