sapdev logo background
sapdev logo sapdev logo
Comments

ABAP DELETE DBTAB OBSOLETE Statement syntax, information and example SAP source code



Return to Statement index



DELETE dbtab - VERSION

ABAP Syntax(Obsolete) DELETE { dbtab | *dbtab } VERSION vers.

What does it do? 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.
Latest 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 .
Example ABAP Coding
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:
NEXT EXAMPLE
DATA: wa TYPE t100,
dbtab TYPE c LENGTH 5.
...
dbtab = 'T100'.
...
wa-sprsl = 'E'.
wa-arbgb = 'BC'.
wa-msgnr = '100'.
DELETE (dbtab) FROM wa.
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved




DELETE_DBTAB
DELETE_DUPLICATES




comments powered by Disqus