<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1505" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>We are in the process of Archiving and cleanup work. 4.6C.</DIV>
<DIV> </DIV>
<DIV>Dev class "SO" has a lot of programs that will help you understand </DIV>
<DIV>what and where. </DIV>
<DIV> </DIV>
<DIV>A few things I figured out about Reorganization. At least for 4.6c. </DIV>
<DIV> </DIV>
<DIV>SO30 / SO31</DIV>
<DIV> - These Reorg programs will not remove ANY documents without an Expiry date. </DIV>
<DIV> - If the document has an Expiry Date and Unread it will not delete. </DIV>
<DIV> If users for whatever reason don't read their inbox messages they will never get deleted </DIV>
<DIV> automatically. (We are working with SAP to remedy this issue. Less manual maintenance the better)</DIV>
<DIV> </DIV>
<DIV> - WF-BATCH will not apply an Expiry Date to any message without using the APIs to add one. </DIV>
<DIV> (Working with SAP to get this working corrected) </DIV>
<DIV> </DIV>
<DIV>We have SO31 (Daily Reorg) running daily and SO30 weekly run. </DIV>
<DIV>SO31 will only delete type RAW. Need to run SO30 with variant for the types </DIV>
<DIV>you want to delete. </DIV>
<DIV> </DIV>
<DIV>Also, at least for 4.6c, there are lots of junk that these normal reorgs will NOT clean up. </DIV>
<DIV>A few programs you will need to run to delete. </DIV>
<DIV> </DIV>
<DIV>Let me know if you want more details about clean up (Reorganization). I have been </DIV>
<DIV>knee deep in this for about a month! </DIV>
<DIV> </DIV>
<DIV>Rick</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><BR>>>> heinz.schmidinger@unaxis.com 7/21/2005 1:29:58 >>><BR>Hi pp,<BR><BR>"generic objects" contains a couple of different "Attachments".<BR><BR>If you are writing from SOOD, ...., you are using "personal" Attachments.<BR>These are at least SAP-Mail Attachments (Type EXT).<BR>Without changed customizing they are stored in the ContentRepository<BR>"SOFDB".<BR>SOFDB is customized in Standard as an R3-DB-Content.<BR>This means, the attachments are stored in Cluster-Tables in die SAP-DB.<BR><BR>There is no special security foreseen for viewing these type of attachments,<BR>but there is an BADI where you can do your own controls.<BR><BR>These type of attachments is handeld like a SAP-Office-Attachment, only the<BR>creating User is abele to do changes on such an "Document".<BR><BR>The livetime in the System depends on the definition of lifetime for<BR>SAP-Office-Obejcts.<BR><BR>You will find a lot of Notes to this.<BR><BR>The main point is, that these Attachments are ready for reorganisation after<BR>the assigned Object is reorganized. But you should be careful with the<BR>Maintainace of SAP-Office with all theire many reports and test all your<BR>settings of reorganisation well viewing to Objects of type "EXT".<BR><BR>Hope this helps.<BR><BR>Regards<BR><BR>Heinz<BR><BR>-----Ursprüngliche Nachricht-----<BR>Von: <U><A href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</A></U> <U><A href="mailto:[mailto:sap-wug-bounces@mit.edu]">[mailto:sap-wug-bounces@mit.edu]</A></U> Im Auftrag von<BR>hara parida<BR>Gesendet: Donnerstag, 21. Juli 2005 07:14<BR>An: <U><A href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</A></U> <BR>Betreff: Finding the Actual tables for storing the attachment to Business<BR>object(BUS2002)<BR><BR>Workflow Gurus,<BR><BR>We are on SAP vers. 4.7 I am working on the development of an Object for <BR>attaching the request details sheet with business object(bus2002 and network<BR><BR>number as object key).Our customers are interested in being able to add <BR>attachments to the business object which they can call/view at a later <BR>date. This request details can be in the form of MS Word or Excel or PDF. <BR>The business object (BUS2002) is currently setup correctly and Attachments <BR>can be created and saved with the object. It looks like it is using the <BR>Whole Generic Services for Objects functionality. I read up on this Generic<BR>Services info and it mainly talked about setting up a content repository, <BR>where these external documents can be stored. But I did not set any of this<BR><BR>up and it seems that these attachment documents are being stored somewhere <BR>in SAP. I tried debugging the method where you display current object <BR>attachments and it almost seems cryptic as to how SAP is storing the <BR>documents. My customer wants to know where exactly is the attachment being <BR>stored - will the location of<BR>the attachments get cleaned up which means losing the documents without <BR>their knowledge in some near future - and how is security administered on <BR>viewing these documents. Has anyone dealt with this before. I have been <BR>debugging four a couple of days now trying to determine where the physical <BR>documents are being stored. So far I have come up with a lot of tables like<BR><BR>SOOD, SOFM, SOFD, SOC3, soffphf, soffloio,soffcont1 and soffphio,but I could<BR><BR>not see the business object(bus2002) and the network number. but one more <BR>table I found that srgbtbrel,this table contains the object <BR>type,rel,type,one key,and the object key..but I could not find the proper <BR>physical document name .where and how the all the attachments for particular<BR><BR>to business objects are stored. Any help would be appreciated on this <BR>matter.this is very urgent<BR><BR>Thanks and Regards,<BR><BR>PP<BR><BR>_________________________________________________________________<BR>Top-of-the-line jobs!. <BR><U><A href="http://creative.mediaturf.net/creatives/timesjobs/hotmail_TOL.htm">http://creative.mediaturf.net/creatives/timesjobs/hotmail_TOL.htm</A></U> Log on to <BR><U><A href="http://www.timesjobs.com/">www.timesjobs.com</A></U> and apply TODAY!<BR><BR>_______________________________________________<BR>SAP-WUG mailing list<BR><U><A href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</A></U> <BR><U><A href="http://mailman.mit.edu/mailman/listinfo/sap-wug">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></U> <BR><BR><BR>_______________________________________________<BR>SAP-WUG mailing list<BR><U><A href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</A></U> <BR><U><A href="http://mailman.mit.edu/mailman/listinfo/sap-wug">http://mailman.mit.edu/mailman/listinfo/sap-wug</A></U> <BR><BR></DIV></BODY></HTML>