Deleting entries from EBAN table

[Former Member]

Hi Experts,

I am asked to find a way(preferably function module) to delete entries from EBAN table based on some selection critaria. I found this BAPI, BAPI_REQUISITION_DELETE, but this will only mark the entry for deletion. I want something which will erase the entries from EBAN table. Please let me if there is a way to achieve this.

Thanks in advance!

[Former Member]

Hi Manjunatha,

I would not suggest you to delete entries from table-EBAN because it may cause inconsistency.

You can use given FM to mark as deletion and also use commit BAPI at the end.

Regards,

Sudeesh Soni

[Former Member]

Hello

Try using methods of class : CB_MEREQ_PER_EBAN_TECH

1) Method DELETE_PERSISTENT             public ( with key )

2) Method PM_DELETE_PERSISTENT     instance method

Regards                         

[matt]

No. Really. Don't do this.

[Former Member]

Hi Hicham,

Could you please explain how to use this method and what are the parameters to be passed inorder to delete the entry from EBAN.

Thanks

[Former Member]

Hi Matthew,

The entries I am going to delete are the ones which are flagged for deletion and left out in table since they could not go through the cycle of PO creation because of some error in them. These entries are of absolutely no use but killing the performance of other objects.

Thanks

[raymond_giuseppi]

First call FM BAPI_REQUISITION_DELETE, then call transaction SARA to actually delete reports. (Look for documentation on Archiving at help.sap.com)

Regards,

Raymond

[Former Member]

Raymond,

Thanks for your reply!

Requirement is to delete entries from EBAN, not to archive. We don't want those entries anymore. Let me know if you have any suggession.

Thanks!

[matt]

The correct procedure is to archive, then delete the archive.

[Former Member]

This message was moderated.

[nabheetscn]

Manju

Please search for archiving and deletion you will see so many doc

Nabheet

[former_member221194]

This message was moderated.

[Former Member]

Hello Nabheet,

Please give unique answer. Already answer was given by Matthew.

[matt]

Nabheet was replying to a rejected post, asking for documents. His reply is correct.

[Former Member]

Thanks all for your replys. I got the documents.