ABAPINSERT_DBTAB - INSERT DBTAB

rdisp/max_wprun_time - Maximum work process run time   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

INSERT dbtab

Short Reference

Syntax

INSERT { {INTO target VALUESwa }
      | {     target FROM  wa|{TABLE itab} } }.

Effect

The INSERT statement inserts one or more rows specified in sourcein the database table specified in target.The two variants with INTO and VALUES or without INTO with FROM behave identically,with the exception that you cannot specify any internal tables in source after VALUES.

System Fields

The INSERT statement sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc	Meaning
0	In the declaration of a work area in source, the declared row was inserted.In the declaration of an internal table in source, all declared rows were inserted, or the internal table is empty.
2	In the declaration of an LOB handle structure with a component forwriterstreams, the non-LOB handle components were not yet written to the database, but instead are transmitted when closing the stream, at latest. The occurrence of this situation depends on the database. Refer toLOB handles.
4	In the declaration of a work area in source, the declared row was not inserted,or, in the declaration of an internal table in source, not all declared rows were inserted, as a row in the database table has the sameprimary key or a uniquesecondary index.

• The INSERT statement sets sy-dbcnt to the number of rows inserted. If sy-subrc is 2, then sy-dbcnt is set to the value 1 (for undefined).
  
  
  

Note

• The inserted rows are finally included in the table in the nextdatabase commit. Up until this point, they can still be removed by adatabase rollback.
  
• The statement INSERT sets a database lock until the next database commit or rollback. If used incorrectly, this can lead to adeadlock.
  
  
• The number of rows that can be inserted in the tables of a database within adatabaseLUW is limited, since a database system can only manage a limited amount of locks and data in the rollback area.
  
  

PERFORM Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.


Length: 4750 Date: 20120522 Time: 232834     triton ( 123 ms )