<div>Hi, </div>
<div> </div>
<div>The custom report is reading directly from the SWW_CONTOB table, and I see that for archived workflows, then entry is missing in this table.</div>
<div>Not sure if the entries are archived as well, or moved to a different table.</div>
<div> </div>
<div>Any input is appreciated.<br></div>
<div>Thank you</div>
<div>Lalitha<br></div>
<div class="gmail_quote">On Wed, Dec 2, 2009 at 5:18 AM, Morris, Eddie <span dir="ltr"><<a href="mailto:eddie.morris@sap.com">eddie.morris@sap.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d">Hi Lalitha,</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d">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).</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d">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.</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d">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.</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d">Regards,</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d">Eddie</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d"> </span></p>
<div>
<div style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<p class="MsoNormal"><b><span style="FONT-SIZE: 10pt">From:</span></b><span style="FONT-SIZE: 10pt"> <a href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a> [mailto:<a href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a>] <b>On Behalf Of </b>Keohan, Susan - 1140 - MITLL<br>
<b>Sent:</b> 01 December 2009 21:44
<div class="im"><br><b>To:</b> SAP Workflow Users' Group<br></div><b>Subject:</b> RE: SWW_CONTOB entries missing</span>
<p></p></p></div></div>
<div>
<div></div>
<div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black">Hi Lalitha,</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black">The first thing I wonder is why would you be doing lookups in SWW_CONTOB? You should </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black">probably be using SAP_WAPI_READ_CONTAINER rather than doing table lookups.</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black">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.</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black">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.</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black">You can read about the affects of archiving on workflow data starting with the SAP Help (<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/8d/3e704c462a11d189000000e8323d3a/content.htm" target="_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/8d/3e704c462a11d189000000e8323d3a/content.htm</a>)</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black"><br>Good luck,<br>Sue</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: black"> </span></p>
<div>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">----</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">Susan R. Keohan</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">SAP Workflow Specialist</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">Enterprise Applications</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">Information Services Department</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">MIT Lincoln Laboratory</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">244 Wood Street, LI-200</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">Lexington, MA. 02420</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black">781-981-3561</span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; COLOR: black"><a href="mailto:keohan@LL.MIT.EDU" target="_blank">keohan@LL.MIT.EDU</a></span><span style="COLOR: black"></span></p>
<p class="MsoNormal"><span style="COLOR: black"> </span></p></div>
<div>
<div class="MsoNormal" style="TEXT-ALIGN: center" align="center">
<hr align="center" width="100%" size="2">
</div>
<p class="MsoNormal"><b><span style="FONT-SIZE: 10pt">From:</span></b><span style="FONT-SIZE: 10pt"> <a href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a> [mailto:<a href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a>] <b>On Behalf Of </b>Lalitha Sankaran<br>
<b>Sent:</b> Tuesday, December 01, 2009 3:55 PM<br><b>To:</b> SAP Workflow Users' Group<br><b>Subject:</b> SWW_CONTOB entries missing</span></p></div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Hi,</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">How do we view an archived workflow log ?</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">We have a document which went thru the approval process and was posted by WFBATCH, but am not able to find an entry</p></div>
<div>
<p class="MsoNormal">in the sww_contob table. The same document in the PS system has an entry in SWW_CONTOB and also am able to</p></div>
<div>
<p class="MsoNormal">view the workflow log.</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">Could the WF be archived, if yes, then is the entry removed from the sww_contob table?</p></div>
<div>
<p class="MsoNormal">Or could the support pack have deleted any entries from the table.</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">How do I track the WF history of this document ?</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">We are using ECC 6.0 , SP SAPKA70103</p></div>
<div>
<p class="MsoNormal">Please advise.</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">Thank you</p></div>
<div>
<p class="MsoNormal">Lalitha</p></div>
<div>
<p class="MsoNormal"> </p></div></div></div></div></div><br>_______________________________________________<br>SAP-WUG mailing list<br><a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
<br></blockquote></div><br>