Changing Data 

Open SQL contains a set of statements that allow you to change data in the database. You can insert, change and delete entries in database tables. However, you must remember that Open SQL statements do not check authorization or the consistency of data in the database. The following statements are purely technical means of programming database updates. They are to be used with care, and, outside the SAP transaction concept, only to be used in exceptional cases. The SAP transaction concept addresses the question of database update programming in the R/3 System. It discusses the difference between a database LUW and an SAP LUW, and explains about SAP transactions and the R/3 locking concept.

 

Inserting Lines

Changing Lines

Deleting Lines

Inserting or Changing Lines

COMMIT WORK and ROLLBACK WORK