topic Re: what is Version in DEELETE statement?? in Application Development and Automation Discussions

what is Version in DEELETE statement??

former_member181959 — Thu, 17 Aug 2006 11:33:08 GMT

can on please tell me what is 'vers' in the below statemet?

DELETE dbtab VERSION vers.

thanks,

Prasad Babu.

Re: what is Version in DEELETE statement??

dani_mn — Thu, 17 Aug 2006 11:36:21 GMT

HI,

This variant is now obsolete, since other variants allow you to specify the database table name dynamically.

<b>

Effect</b>

Deletes a line in a database table, the name of which is taken from the field vers at runtime. The database table must be known to the ABAP Dictionary and its name must conform to the following naming convention: It must begin with 'T' and can consist of four additional characters. The field vers must contain the table name without a leading 'T'. Only lines in the current client are deleted. The line to be deleted is taken from the statically specified table work area dbtab or *dbtab.

The return code is set as follows:

SY-SUBRC = 0:

The line was deleted.

SY-SUBRC = 4:

No lines could be deleted because no line existed with the specified primary key.

Regards,

HRA

Re: what is Version in DEELETE statement??

Former Member — Thu, 17 Aug 2006 11:49:25 GMT

Hi Prasad,

DELETE dbtab VERSION vers.

DELETE *dbtab VERSION vers.

This variant is not allowed in an ABAP Objects context. See VERSION addition not allowed.

Note

This variant is now obsolete, since variants 1 - 3 allow you to specify the database table name dynamically.

Effect

The return code is set as follows:

SY-SUBRC = 0:

The line was deleted.

SY-SUBRC = 4:

No lines could be deleted because no line existed with the specified primary key.

If useful reward.

Vasanth