RKSE16N_CD_DISPLAY 查看表删除日志
INSERT |
INSERT [DB] FROM [STRU] INSERT ZLESSON3RW_ZX FROM US_STRUCTURE.插入单行 |
INSERT [DB] FROM TABLE [ITAB] |
INSERT [DB] FROM TABLE [ITAB] ACCEPTING DUPLICATE KEYS 根据表插入多条INSERT ZLESSON3RW_ZX FROM TABLE CT_LESSON11 ACCEPTING DUPLICATE KEYS. |
UPDATE |
UPDATE [DB] FROM [STRU] UPDATE ZLESSON3RW_ZX FROM CS_STRUCTURE. "更新一行数据 |
UPDATE [DB] SET FIELD = 'XXX' WHERE … UPDATE ZLESSON3RW_ZX SET TZ = CT_LESSON11-TZ "只更新体重字段 WHERE GH = CT_LESSON11-GH. " 条件根据需求变化 |
UPDATE [DB] FROM TABLE [ITAB] UPDATE ZLESSON3RW_ZX SET TZ = CT_LESSON11-TZ "只更新体重字段 WHERE GH = CT_LESSON11-GH. " 条件根据需求变化 |
DELETE |
DELETE [DB] FROM [STRU] DELETE ZLESSON3RW_ZX FROM CS_STRUCTURE. |
DELETE FROM [DB] WHERE … DELETE FROM ZLESSON3RW_ZX WHERE XB = CS_STRUCTURE-XB."条件可以加入多个 AND 或者OR BETWEEN |
DELETE [DB] FROM TABLE [ITAB] DELETE ZLESSON3RW_ZX FROM TABLE CT_LESSON11. |
MODIFY |
MODIFY [DB] FROM [STRU] MODIFY ZLESSON3RW_ZX FROM CS_STRUCTURE. |
MODIFY [DB] FROM TABLE [ITAB] MODIFY ZLESSON3RW_ZX FROM TABLE CT_LESSON11. |
SELECT |
SELECT SINGLE...INTO [CORRESPONDING FIELDS OF] wa WHERE… SELECT EBELN EBELP BWART BUDAT INTO CORRESPONDING FIELDS OF TABLE LT_EKBE FROM EKBE FOR ALL ENTRIES IN LT_DATA WHERE EBELN = LT_DATA-EBELN AND EBELP = LT_DATA-EBELP.
|
SELECT ... FROM <tables> UP TO <n> ROWS … |
SELECT SINGLE <cols> ... INTO ( dobj1 , dobj2 , ... ) WHERE … |
SELECT ... INTO | APPENDING CORRESPONDING FIELDS OF TABLE <itab> … 字符串拼接 必须都是CHAR类型 SELECT ( belnr && '/' && BLART ) AS tdname 取最大值 SELECT MAX( adrnr ) FROM t001w INTO @DATA(lv_adrnr) UP TO 1 ROWS. WRITE lv_adrnr. 取最小值 SELECT MIN( adrnr ) FROM t001w INTO @DATA(lv_adrnr) UP TO 1 ROWS. WRITE lv_adrnr. 不取重复条目 SELECT DISTINCT 取单挑 内表中key值全部存在于WHERE条件的情况下,才可以使用select single 否则查不到值 如果存在表关联要用 up to 1 rows DATA: lv_rebate TYPE p DECIMALS 2 VALUE '0.10'. SELECT 'hello' && 'XLevon' AS char, " 字符串拼接 100 AS i_num, " 整型 @sy-langu AS sys_lan, " 系统语言 @lv_rebate AS p_num, " 定点小数 price, ( price * @lv_rebate ) AS rebate, " 折扣 round( ( price * @lv_rebate ), 1 ) AS round_col," 折扣保留一位小数 ceil( ( price * @lv_rebate ) ) AS ceil_col, 向上取整 floor( ( price * @lv_rebate ) ) AS floor_col 向下取整 FROM sflight WHERE carrid = @p_carrid INTO TABLE @DATA(gt_data_expression). 内表样式 |