OPEN SQL
• 目的:避免不同的数据库表直接的不兼容性,使
ABAP/4 程序能在应用中独立于数据库系统。
数据库操作
- SELECT 语句
SELECT <result>
INTO <target>
FROM <source>
[WHERE <condition>]
[GROUP BY <fields>]
[HAVING <cond>]
[ORDER BY <fields>].
WHERE 语句
• BETWEEN <g1> AND <g2>
• LIKE <g> _
表示一个字符
%
表示一个字符串
• IN (<g1>….<g2>)
多表结合查询
< INNOR JOIN
SELECT … FROM table [INNER] JOIN jointable1 [AS aliasA] ON <cond>
SELECT p~carrid p~connid f~fldate
INTO CORRESPONDING FIELDS OF TABLE itab
FROM (spfli AS p
INNER JOIN sflight AS f ON p~carrid = f~carrid AND
p~connid = f~connid )
WHERE p~cityfrom = 'FRANKFURT' AND
p~cityto = 'NEW YORK' .
数据库操作
INSERT 语句
• INSERT <database> FROM <wa> .
• INSERT <database> FROM TABLE <itab> [ACCEPTING DUPLICATE KEY]
UPDATE
• UPDATE <database> FROM <wa>
• UPDATE <database> FROM TABLE <itab>
• UPDATE <database> SET < f1>=<values>… WHERE <condition>
• MODIFY <database> FROM <wa>
• MODIFY <database> FROM TABLE <itab>
DELETE
• DELETE <database> FROM <wa>
• DELETE <database> FROM TABLE <itab>
• DELETE FROM <database> WHERE <condition>
几个TCODE
• SE11/SE12/SE13/SE14/SE15
数据字典维护相关
• SE16/SE17
查看表数据
• SE30
ABAP运行分析
• SE32
文本维护
• SE37
维护函数
• SE38
ABAP编辑器
• SE39
程序比较
• SE80
ABAP对象编辑器
• SE91
维护消息类和消息
• SE93
给程序维护TCODE
• SM36
定义后台job
• SM37
查看后台job