topic Re: delete entries from database table in Application Development and Automation Discussions

delete entries from database table

Former Member — Mon, 28 May 2007 14:07:09 GMT

Hi,

I wanted to delete on entry for database table VBAP where sales order no is 5441.

The sales order having two line items i.e. 10 & 20.

any body will suggest me how to write the code to delete the above mentioned entries from DBtable VBAP.

I think that I need to write

delete VBAP where vbeln = '5441'.

Is it remove the two line item.

Pls reply me asap.

Re: delete entries from database table

Former Member — Mon, 28 May 2007 14:08:52 GMT

delte vbak where vbeln = '0000005441'.

it delete in vbak and vba also.

Reward Points if it is useful

Thanks

Seshu

Re: delete entries from database table

Former Member — Mon, 28 May 2007 14:10:04 GMT

delete from VBAP where vbeln = '0000005441'.

else

use conversion routine before delete statement to convert the value to database format.

Regards,

Santosh

Message was edited by:

Santosh Kumar Patha

Re: delete entries from database table

Former Member — Mon, 28 May 2007 14:10:11 GMT

Hi Neha

It wont remove items. because items are stored in another table. So u should find the item table and try to delete. Or else u can delete directly from VA01 or va02 transaction. U can also delete using BDC.

need ur reward points if its helpful.

Regards

Ravi

Re: delete entries from database table

Former Member — Mon, 28 May 2007 14:11:20 GMT

DELETE VBAK WHERE VBELN = '0000005441'.

COMMIT WORK.

Re: delete entries from database table

ferry_lianto — Mon, 28 May 2007 14:11:25 GMT

Hi,

Please check this FM.

BAPI_SALESORDER_CHANGE

BAPI_SALESDOCUMENT_CHANGE

Regards,

Ferry Lianto

Re: delete entries from database table

Former Member — Mon, 28 May 2007 14:22:27 GMT

Hi neha,

delete from vbap where vbeln = '0000005441'.

commit work.

This deletes item level data only.but header level data still remains.

But when we display the sales order using VA03 we can't get it.

To delete the sale order,goto VA03 and delete it.

reward points if useful

rami

Re: delete entries from database table

Former Member — Mon, 28 May 2007 14:30:52 GMT

This table is logically connected to a number of other tables, so you should not update it directly. Use a BAPI or BDC.

Rob