topic Re: update table vbkd in Application Development and Automation Discussions

update table vbkd

Former Member — Thu, 26 Oct 2006 06:26:08 GMT

hi everybody

i wanted to know if i can delete a row in a standard table (im using table vbkd) in a program?

thanks

anjali

Re: update table vbkd

gopi_narendra — Thu, 26 Oct 2006 06:27:39 GMT

No u can not delete it in a program directly by using Delete statement.

using a BAPI is better.

Regards

- Gopi

Re: update table vbkd

Former Member — Thu, 26 Oct 2006 06:28:01 GMT

you can do it via program(delete statement). The client should be open !. also using se16n transaction, you can do it.

But it is against the sap code of conduct. I wouldnt recommend things.

regards,

Sandeep Josyula

Re: update table vbkd

Former Member — Thu, 26 Oct 2006 06:30:15 GMT

Yes u can do that in program but u should not do it.

Selecting Lines Using Conditions

To select the lines that you want to delete using a condition, use the following:

DELETE FROM target WHERE cond.

All of the lines in the database table that satisfy the conditions in the WHERE clause are deleted. The FROM expression must occur between the keyword and the database table.

You should take particular care when programming the WHERE clause to ensure that you do not delete the wrong lines. For example, if you specify an empty internal table in a dynamic WHERE clause, all of the lines in the table are deleted.

If at least one line has been deleted, sy-subrc is set to 0 – otherwise to 4. sy-dbcnt is set to the number of deleted lines.

Selecting Single Lines Using Work Areas

Instead of using a WHERE clause, you can select lines for deletion using the contents of a work area. In this case, you would write:

DELETE target FROM wa.

This deletes the line with the same primary key as the work area wa. The FROMexpression must not occur between the keyword and the database table. The work area wa must be a data object with at least the same length and alignment as the line structure of the database table. The key is read according to the structure of the table line, and not that of the work area. It is a good idea to define the work area with reference to the structure of the database table.

If the database table contains a line with the same primary key as specified in the work area, the operation is completed successfully and sy-subrc is set to 0. Otherwise, the line is not deleted, and sy-subrc is set to 4.

A shortened form of the above statement is:

DELETE dbtab.

In this case, the contents of the table work area dbtab are used to delete from the database table with the same name. You must declare this table work area using the TABLESstatement. In this case, it is not possible to specify the name of the database table dynamically. Table work areas with the same name as the database table (necessary before Release 4.0) should no longer be used for the sake of clarity.

Selecting Several Lines Using an Internal Table

You can also use an internal table to delete several lines:

DELETE target FROM TABLE itab wa.

This deletes all lines from the database that have the same primary key as a line in the internal table itab. The same rules apply to the line type of itab as to the work area wa described above.

If the system cannot delete a line because no line with the specified key exists, it does not terminate the entire operation, but continues processing the next line of the internal table.

If all lines from the internal table are used, sy-subrc is set to 0. Otherwise, it is set to 4. If not all lines are used, you can calculate the number of unused lines by subtracting the number of deleted lines in sy-dbcnt from the total number of lines in the internal table. If the internal table is empty, sy-subrc and sy-dbcnt are set to 0.

Whenever you want to delete more than one line from a database table, it is more efficient to work with an internal table than to insert the lines one by one.

Have a look at below link.

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3aef358411d1829f0000e829fbfe/content.htm

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: update table vbkd

Former Member — Thu, 26 Oct 2006 06:34:39 GMT

thanks for the replies

do you know any BAPI or fm which would delete a row in the table VBFA(sorry, it was not table vbkd)

thanks

anjali

Re: update table vbkd

gopi_narendra — Thu, 26 Oct 2006 07:09:55 GMT

Am not sure of a BAPI, but this shud be related something to functional, or might there be a tcode for such thing. you just can not delete alone the entry in table VBFA, because it is related to many more table, ask ur functional consultant. he shud be helping u in this regard.

http://www.erpgenie.com/sap/abap/tables_sd.htm

Regards

- Gopi

Re: update table vbkd

Former Member — Thu, 26 Oct 2006 07:18:08 GMT

Hi sia,

yes you can do, but be careful. a lot of sap-function

use this table.!!

Can you tell us why do you whant to delete, perhaphs

there are other possibitities.

regards, Dieter

Re: update table vbkd

Former Member — Thu, 26 Oct 2006 09:37:46 GMT

well, when im creating a retrun order for a document, a line is being created in the table vbfa with posnr '000000', i dnt know why, thats why I wanted to delete that line from the table

Re: update table vbkd

Former Member — Thu, 26 Oct 2006 10:10:34 GMT

Sia,

VBFA is the document flow table so to delete the record in the table you can simply delete the corresponding document.

Example...if you have sales order and create the subsequent doc ie delivery note you would find an entry in the table with sales order as prev doc and delivery note as the next doc.

Regards

Anurag