Any FM or transaction that deletes entry from SAP transparent table

[Former Member]

Hi. Do you know of any transaction or function module that deletes entry from a transparent table specifically table EBAN?

[Former Member]

Hi,

You might consider the BAPI

BAPI_REQUISITION_DELETE

This would delete / close the purchase requistions, which ofcourse updtaes/deletes entries from EBAN and other associated tables.

Rgds,

HR

[former_member660980]

Hello Katchak,

the process for delete an purchase requisition ( EBAN ) must be done by an <b>batch-input</b> or a BAPI. In my work version ( 4.6B ) There aren't the bapi for delete the purchase requisition. You must use the batch-input.

Regards.

[Former Member]

Hi,

Maybe you can use SE16 with debugging to change the records of EBAN. It is a sleazy way, but it works:))

Regards,

Remco Broen

[Former Member]

Use the BAPI "BAPI_REQUISITION_DELETE" to delete purchase requisitions from EBAN Table.

[Former Member]

You can also use SAP Standard program <b>RLORD035</b> to delete purchase requisitions.

[Former Member]

But isn't bapi_requisition_delete only set the deletion flag and close the PR? If possible, we want the entry totally deleted from the table. Is there a way to do it?

[raymond_giuseppi]

You need to use the FM/BAPI BAPI_REQUISITION_DELETE and then call transaction SARA and archive the data object MM_EBAN.

(Look at SARA and press Database, transaction will show the list of DB table related.)

Regards

[Former Member]

Hi,

SE16, fill in EBAN, fill selections to get the record wanted, execute, fill in /H, doubleclick the record to be deleted, then you will be in debugging, hit once F7, change value for variable code to DELE in the debugger, hit F8 and then you will be able to delete the record.

Regards,

Remco Broen

[Former Member]

can we retrieve back the deleted value after deleting in the debugging mode

is there any method by which we can do that ???

please help experts