Skip to Content

SAP CRM: Reorganization of attachments/documents in Content Repository

Jan 12 at 06:50 AM


avatar image

Hi all,

I have the requirement to implement a reorganization report or some more a garbage collection of the attachments/documents in the Content Repository.

Due to the fact that you can upload an attachment e.g. to a 1Order process which will never be saved on the database, it is possible to have abandoned documents in the Content Repository. The content e.g. in databases CRMORDERLOIO, CRMORDERPHIO, etc. and the document itself as well will still remain in the system.

As I know for now the LOIOs and PHIOs are stored in header tables like CRMORDER… or CRMCASE… (… = LOIO or PHIO) even if there is no connection to any BOR Object in table SKWG_BREL. With method CL_CRM_DOCUMENTS=>DELETE you can delete documents belonging to a business object. But in this case method CL_CRM_DOCUMENTS=>WHERE_USED won’t find a usage in any CRM object.

Well, I’m thankful for any hint… Is there any archiving possibility for attachments within CRM (I haven’t found any in SARA yet)? Is there any reorganization function provided from SAP to get rid of abandoned documents? Is there a utility or helper class with a method to delete all content of an attachment with just an LOIO or PHIO as input?

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Benjamin Wadsack Jan 24 at 11:39 AM

I found archiving object BC_LOIO which seems to be some kind of a demo scenario. Unfortunately the archiving object is not ILM enabled, so there won't be a data destruction provided. :( Does anyone know how SAP handles the deletion of attachments/documents?

(By the way, function module SKWF_IOS_DELETE deletes all data for a given LOIO.)


10 |10000 characters needed characters left characters exceeded