The SAP transaction concept illustrates how database changes can be programmed.
See also the descriptions in the ABAP Editor under Utilities → Keyword documentation → ABAP Overview → Description of Syntax and Concepts → Transaction processing.
The statements that carry out the actual database changes are a part of Open SQL.
Transactions and Logical Units of Work
Creating Update Function Modules
Error Handling for Bundled Updates