SWW_CONTOB entries missing

[Morris, Eddie]

Hi Lalitha,

Tables SWW_CONTOB & SWW_CONT are used in Basis 640 onwards, but only if you choose the 'old' container persistence. When using XML persistence in your workflow no entries will be written to these tables.  You can change the settings for the persistence profile of a workflow via the builder => Basic Data => Version Dependent => Control tab. Look in the 'Persistence profile' tab and you can change the settings (But I would not recommend changing it).

Entries with XML persistence are stored in table SWWCNTP0. The only issue will be if you have some custom code that reads directly from tables SWW_CONTOB & SWW_CONT.

As Sue has detailed below there are several standard reports to find work items related to an object or if doing it via custom code please use the WAPI's.

Regards,
Eddie

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Keohan, Susan - 1140 - MITLL
Sent: 01 December 2009 21:44
To: SAP Workflow Users' Group
Subject: RE: SWW_CONTOB entries missing

Hi Lalitha,
The first thing I wonder is why would you be doing lookups in SWW_CONTOB?  You should
probably be using SAP_WAPI_READ_CONTAINER rather than doing table lookups.

You said you want to track the history of this document thru workflow; don't the standard reports provide enough information? Swi2_freq, or, from the object, you can use Generic Object Services.
As for archiving, if you archived the data for the workflow - then you would not find the same data related to the PS object in SWW_CONTOB.
You can read about the affects of archiving on workflow data starting with the SAP Help (http://help.sap.com/saphelp_nw2004s/helpdata/en/8d/3e704c462a11d189000000e8323d3a/content.htm)

Good luck,
Sue


----
Susan R. Keohan
SAP Workflow Specialist
Enterprise Applications
Information Services Department
MIT Lincoln Laboratory
244 Wood Street, LI-200
Lexington, MA. 02420
781-981-3561
keohan at LL.MIT.EDU

________________________________
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Lalitha Sankaran
Sent: Tuesday, December 01, 2009 3:55 PM
To: SAP Workflow Users' Group
Subject: SWW_CONTOB entries missing

Hi,

How do we view an archived workflow log ?

We have a document which went thru the approval process and was posted by WFBATCH, but am not able to find an entry
in the sww_contob table. The same document in the PS system has an entry in SWW_CONTOB and also am able to
view the workflow log.

Could the WF be archived, if yes, then is the entry removed from the sww_contob table?
Or could the support pack have deleted any entries from the table.

How do I track the WF history of this document ?

We are using ECC 6.0 , SP SAPKA70103
Please advise.

Thank you
Lalitha

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