Skip to content

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 addition VERSION, to the number of obsolete access statements, for which for dbtab, the name of a database table or a classic view must be specified, beginning with "T" and comprising no more than five characters.

The use of addition VERSION means that the database table or view dbtab is not processed. Instead the table whose name is made up of "T" and the content of vers 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 or view does not exist or if it does not meet the name conventions specified above.


Notes

  • The VERSION addition is not allowed in classes. Instead, specify the database table or view dynamically in its operand position in Open SQL.
  • None of the additions possible in Open SQL must be specified together with VERSION.
  • Obsolete access statements do not support automatic client handling. The client ID of a database table must be specified explicitly. Note that application programs should only use data from the current client.


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.


This translation does not reflect the current version of the documentation.