EKBE table entries to be deleted

[Former Member]

Please let know how to delete the entries in EKBE table.

I tried using two FMs MAP2E_EKBE_TO_BAPIEKBE and BAPI_PO_DELETE_HISTORY but there is an error.

We have a production situation and this has to be done by anz business workaround.

[Former Member]

This message was moderated.

[JL23]

This BAPI is designed for a very special use, which is explained in wiki: Purchase Order History - ERP SCM - SCN Wiki

The regular way is aggregation of PO history via ME87 if you still want to keep the PO in your system

[Former Member]

I have a situation in which EKBE table entries for service entry doesnöt have
LFGJA field empty because of which there is a routine error

MRM_FRSEG_CHECK FRSEG_BELNR while receiving a invoice file through interface and try to park invoice document using a custom workflow

[JL23]

Can you post your Routine error? Why are looking for a workaround? First you should try to solve this error.

[Prasoon]

Hi,

   You can very well cancel the posted documents (MIGO or MIRO docs) which will nullify the existing postings. May I know why you want to delete the entries.

Regards,

AKPT

[Former Member]

Hi Priyank,

Leave the table alone, as Dev states it can only lead to inconsistencies. The best way to delete the PO history is to do an actual archive. Goto transaction SARA, define MM_EKKO and write.

If you have an actual issue with the archiving then please post that error here.

Regards, Ineke

[former_member183424]

MM_EKKO will delete the entire PO number from your system (EKKO and EKPO table also).

[former_member183424]

Why don't you search in SCN. I've found a wiki content regarding this. Please search in SCN before posting any query.

Let me google that for you

[former_member219313]

Hi,

Please follow below steps

1.SE16N

2.Enter Table name

3.Provide inputs

4.in command window run the Tcode: &sap_edit

5.press enter

6.Execute

BR

Deepak Mankeshwar

[former_member183424]

No No No... Are you trying to suggest to delete the data direct from SE16N ? Direct table deleted will create a lots of inconsistent.

[former_member219313]

Dev is correct.....please consider all inconsistancies, its very dangerous to delete like this.