delete entries from database table

[Former Member]

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.

[Former Member]

delte vbak where vbeln = '0000005441'.

it delete in vbak and vba also.

Reward Points if it is useful

Thanks

Seshu

[Former Member]

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

[Former Member]

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

[Former Member]

DELETE VBAK WHERE VBELN = '0000005441'.

COMMIT WORK.

[ferry_lianto]

Hi,

Please check this FM.

BAPI_SALESORDER_CHANGE

BAPI_SALESDOCUMENT_CHANGE

Regards,

Ferry Lianto

[Former Member]

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

[Former Member]

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

Rob