Ansicht
Dokumentation

ABENABAP_SQL_WRITING - ABAP SQL WRITING

Fill RESBD Structure from EBP Component Structure   PERFORM Short Reference  
This documentation is copyright by SAP AG.

- Write Access

Write accesses include inserting, modifying, and deleting content in DDIC database tables. All write accesses can be made as individual accesses or as bulk access. If multiple rows of a DDIC database table are to be changed, bulk access using internal tables generally gives better performance than individual accesses.

• INSERT

• UPDATE

• MODIFY

• DELETE

Notes

• In the case of writes, data consistency must always be ensured. The LUW concept is designed for this purpose. In application programs of an AS ABAP, the implicit database LUWs are normally not sufficient for consistent data storage. Instead, explicit SAP LUWs must be programmed, which normally contain multiple database LUWs.

• When making writes to a DDIC database table for which a database cursor is opened in a SELECT loop or using OPEN CURSOR, the result set is database-dependent and undefined. This kind of parallel access should therefore be avoided.

• Write access to DDIC database tables or DDIC table views in the ABAP Dictionary with replacement objects is still performed on the DDIC database table or the DDIC view and produce a syntax warning.

• Once a global temporary table is filled using , this table must be emptied again explicitly before the next implicit database commit using the statement DELETE FROM without WHERE or using an explicit database commit or database rollback, otherwise the runtime error COMMIT_GTT_ERROR is produced.

BAL Application Log Documentation   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 2894 Date: 20240427 Time: 041258     sap01-206 ( 42 ms )