MODIFY – Change a database table Variants 1. MODIFY dbtab.
You encounter an expensive ABAP statement in SAP ST12. SAP ABAP programming performance tips and tricks; SAP ABAP. Program of a SAP update work process Next. ABAP Performance Standards. Update/Insert statement is used instead of Modify. SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI.
Or MODIFY *dbtab. Or MODIFY (dbtabname).. MODIFY dbtab FROM TABLE itab.
Or MODIFY (dbtabname) FROM TABLE itab. MODIFY dbtab VERSION vers. Or MODIFY *dbtab VERSION vers. Effect Inserts new lines or updates existing lines in a database table.
If a line with the specified primary key already exists, an INSERT is executed. Otherwise, an UPDATE is performed. You can specify the name of the database table either in the program itself in the form MODIFY dbtab or at runtime as the contents of the field dbtabname in the form MODIFY (dbtabname). In both cases, the database table must be defined in the ABAP/4 Dictionary. If the program contains the name of the database table, it must also have a corresponding TABLES statement. Normally, records are inserted or updated only in the current client. Data can only be inserted or updated using a view, if the view refers to a single table and was created in the ABAP/4 Dictionary with the maintenance status “No restriction”.
Startup Repair For Windows Vista. MODIFY belongs to the Open SQL command set. When the statement has been executed, the system field SY-DBCNT contains the number of edited lines.
The return code value is set as follows: SY-SUBRC = 0 All lines were successfully inserted or updated. Any other result causes a runtime error. Notes Automatic definition of INSERT and UPDATE is expensive. You should therefore use MODIFY only if you cannot define the INSERT and UPDATE cases yourself in the program. Since the MODIFY statement does not perform authority checks, you have to program them yourself. Variant 1 MODIFY dbtab. Or MODIFY *dbtab.