ABAP Keyword Documentation →  ABAP - Reference →  Obsolete Language Elements →  Obsolete Processing of External Data →  Obsolete Database Access →  Obsolete Access Statements 

DELETE dbtab - VERSION

Other versions: 7.31 | 7.40 | 7.54

Obsolete Syntax

DELETE { dbtab | *dbtab } VERSION vers.

Effect

This variant of the statement DELETE works essentially like the short form of the Open SQL Statement, but belongs, along with the VERSION addition, to the number of obsolete access statements, for which for dbtab, the name of a database table must be specified, beginning with "T" and comprising no more than five characters.

The addition VERSION has the effect that it is not the dbtab database table, but instead the table whose name is made up of "T" and the content of vers that is processed. vers expects a data object with a maximum of four characters, of type c. The contents of the key fields will continue to be obtained from the table work area dbtab or dbtab*. The statement is not executed if the database table does not exist or if it does not meet the name conventions given above.

Notes

• The VERSION addition is not allowed in classes. Instead, specify the database table dynamically in its operand position in Open SQL.
• None of the additions possible in Open SQL must be specified together with VERSION.
• The obsolete access statements do not support automatic client handling. The client identifier of a database table must be specified explicitly. The application programs are only to work with data for the current client. In systems with multitenancy, this is checked by the ABAP runtime environment.
  

Example

TABLES t100.
DATA vers TYPE c LENGTH 4.
...
vers = '100'.
...
t100-sprsl = 'E'.
t100-arbgb = 'BC'.
t100-msgnr = '100'.
DELETE t100 VERSION vers.

The Open SQL syntax to be used instead reads:

DATA: wa TYPE t100, 
      dbtab TYPE c LENGTH 5. 
... 
dbtab = 'T100'. 
... 
wa-sprsl = 'E'. 
wa-arbgb = 'BC'. 
wa-msgnr = '100'. 
DELETE (dbtab) FROM wa.