AW: Finding the Actual tables for storing the attachment to Busin ess object(BUS2002)

[Rick Sample]

We are in the process of Archiving and cleanup work. 4.6C.
 
Dev class "SO" has a lot of programs that will help you understand 
what and where. 
 
A few things I figured out about Reorganization. At least for 4.6c. 
 
SO30 / SO31
 - These Reorg programs will not remove ANY documents without an Expiry date. 
 - If the document has an Expiry Date and Unread it will not delete. 
   If users for whatever reason don't read their inbox messages they will never get deleted 
   automatically. (We are working with SAP to remedy this issue. Less manual maintenance the better)
 
 - WF-BATCH will not apply an Expiry Date to any message without using the APIs to add one. 
   (Working with SAP to get this working corrected) 
 
We have SO31 (Daily Reorg) running daily and SO30 weekly run. 
SO31 will only delete type RAW. Need to run SO30 with variant for the types 
you want to delete. 
 
Also, at least for 4.6c, there are lots of junk that these normal reorgs will NOT clean up. 
A few programs you will need to run to delete. 
 
Let me know if you want more details about clean up (Reorganization). I have been 
knee deep in this for about a month! 
 
Rick
 
 


>>> heinz.schmidinger at unaxis.com 7/21/2005 1:29:58 >>>
Hi pp,

"generic objects" contains a couple of different "Attachments".

If you are writing from SOOD, ...., you are using "personal" Attachments.
These are at least SAP-Mail Attachments (Type EXT).
Without changed customizing they are stored in the ContentRepository
"SOFDB".
SOFDB is customized in Standard as an R3-DB-Content.
This means, the attachments are stored in Cluster-Tables in die SAP-DB.

There is no special security foreseen for viewing these type of attachments,
but there is an BADI where you can do your own controls.

These type of attachments is handeld like a SAP-Office-Attachment, only the
creating User is abele to do changes on such an "Document".

The livetime in the System depends on the definition of lifetime for
SAP-Office-Obejcts.

You will find a lot of Notes to this.

The main point is, that these Attachments are ready for reorganisation after
the assigned Object is reorganized. But you should be careful with the
Maintainace of SAP-Office with all theire many reports and test all your
settings of reorganisation well viewing to Objects of type "EXT".

Hope this helps.

Regards

Heinz

-----Ursprüngliche Nachricht-----
Von: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] Im Auftrag von
hara parida
Gesendet: Donnerstag, 21. Juli 2005 07:14
An: sap-wug at mit.edu 
Betreff: Finding the Actual tables for storing the attachment to Business
object(BUS2002)

Workflow Gurus,

We are on SAP vers. 4.7 I am working on the development of an Object for 
attaching the request details sheet with business object(bus2002 and network

number as object key).Our customers are interested in being able to add 
attachments to the business object which they can call/view at a later 
date. This request details can be in the form of MS Word or Excel or PDF. 
The business object (BUS2002) is currently setup correctly and Attachments 
can be created and saved with the object. It looks like it is using the 
Whole Generic Services for Objects functionality. I read up on this Generic
Services info and it mainly talked about setting up a content repository, 
where these external documents can be stored. But I did not set any of this

up and it seems that these attachment documents are being stored somewhere 
in SAP. I tried debugging the method where you display current object 
attachments and it almost seems cryptic as to how SAP is storing the 
documents. My customer wants to know where exactly is the attachment being 
stored - will the location of
the attachments get cleaned up which means losing the documents without 
their knowledge in some near future - and how is security administered on 
viewing these documents. Has anyone dealt with this before. I have been 
debugging four a couple of days now trying to determine where the physical 
documents are being stored. So far I have come up with a lot of tables like

SOOD, SOFM, SOFD, SOC3, soffphf, soffloio,soffcont1 and soffphio,but I could

not see the business object(bus2002) and the network number. but one more 
table I found that srgbtbrel,this table contains the object 
type,rel,type,one key,and the object key..but I could not find the proper 
physical document name .where and how the all the attachments for particular

to business objects are stored. Any help would be appreciated on this 
matter.this is very urgent

Thanks and Regards,

PP

_________________________________________________________________
Top-of-the-line jobs!. 
http://creative.mediaturf.net/creatives/timesjobs/hotmail_TOL.htm Log on to 
www.timesjobs.com and apply TODAY!

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu 
http://mailman.mit.edu/mailman/listinfo/sap-wug 


_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu 
http://mailman.mit.edu/mailman/listinfo/sap-wug 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20050725/f3008d10/attachment.htm