SAP ABAP 学习总结（14）：Database table Update_Insert_Delete_Modify（数据库增删改查）

UPDATE

• 第一种：查询一条数据后更新数据
  UPDATE 表名 FROM 结构体.

"声明一个表
DATA:gt_demos TYPE TABLE OF zcurry_table_2.
"声明一个结构体
DATA:gs_demo TYPE zcurry_table_2.

"查询一条数据后更新数据
SELECT SINGLE vbeln posnr matnr arktx FROM zcurry_table_2
  INTO CORRESPONDING FIELDS OF gs_demo
  WHERE vbeln = '0000000001' AND posnr = '000030'.
IF sy-subrc = 0.
  gs_demo-matnr = 'DHA_DEMO_2'.
  gs_demo-arktx = 'TEST'.
  UPDATE zcurry_table_2 FROM gs_demo.
  IF sy-subrc = 0.
    WRITE:'Update Success!'.
    WRITE:gs_demo-vbeln,gs_demo-posnr,gs_demo-matnr,gs_demo-arktx.
  ENDIF.
ENDIF.

• 第二种：查询数据后更新：UPDATE 表名 SET 字段名=值 WHERE 条件.

"UPDATE 表名 SET 字段名=值 WHERE 条件.
UPDATE zcurry_table_2 SET WAERK = 'RMB'
  WHERE vbeln = '0000000001'.
IF sy-subrc = 0.
  WRITE:'Update Success!'.
ENDIF.