Data in BBP_DOCUMENT_TAB are not getting deleted

[Former Member]

Hi All,

We are in SRM 4.0.

Since today morning whenever a user trying to create / change shopping cart, PO, GR it got updated in the BBP_DOCUMENT_TAB. But it is not getting deleted automatically. Earlier it used to get deleted automatically once the documents have been ordered.

But I could see the POs and GRs have been transfered to the back end system.

Job CLEAN_REQREQ_UP is running every 2 mts.

Please advise.

[former_member583013 · Accepted solution]

Hi Arun,

note 338985 describes in detail how the the status of the document(s), CLEAN_REQREQ_UP and the IDOCs interact.

If the documents are posted without any error i.e. there´s everything perfect but the 'obsolete' entries in BBP_DOCUMENT_TAB, then this sounds like a malfunction.

Maybe you should debug the the cleaner with one document and see whats happening starting at the following spot:

CLEAN_REQREQ_UP

• process selected entries: check existence of follow on documents,

• update if necessary local documents etc. (depends on entry type)

LOOP AT selarea.

IF still_to_proc = c_proc_block_size.

SET UPDATE TASK LOCAL.

ENDIF.

lateron the entries are deleted in function module BBP_DELETE_FROM_DOCUMENT_TAB

Note 535765 describes how to delete entries via a Z* report but I would NOT RECOMMEND to do that without having checked the situation by SAP before.

see note 535765:

Please note!:

Deleting relevant entries from the BBP_DOCUMENT_TAB may cause severe

problems, as the system needs the entries to set the right status to

shopping carts, invoices and confirmations. So please be careful with

the deletion of entries.

Kind Regards

Michael

[Former Member · Accepted solution]

Problem was due to the job CLEAN_REQREQ_UP which was running for three days. Today only I noticed that job. Once the job has been cancelled, every thing is fine now.

Thanks for all your help.

[Former Member]

Hello,

"Note 644963 - Regenerating BBP_DOCUMENT_TAB entries " will be helpful.

Thanks

Ashutosh