Tables SWW_CONT, SWW_CONTOB & SWWCNTPO...

[Toledo, Joe]

Hi all,
 
Update:  (Thanks to Jocelyn Dart)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
>From 4.6 SAP has provided WAPIs (workflow APIs) that bring back workflow
data in a safe way.=20
One of the reasons, among many, was because the technical underside of
workflow is changing quite significantly as we move into WAS territory.=20
 
The WAPIs are a series of function modules prefixed with SAP_WAPI.=20
 
What function modules are available depends on your release, however to
find the information you need I would suggest the best routines are the
following:
 
SAP_WAPI_READ_CONTAINER - given a work item id this returns the
container in simple format SAP_WAPI_GET_OBJECTS - given a work item id
this returns the objects from the work item container
SAP_WAPI_WORKITEMS_TO_OBJECT - given an object type and key this returns
all the related work items SAP_WAPI_WORKITEMS_BY_TASK - find all work
items for a particular task/workflow
 
SWI6 also works that way in any system with basis release > 4.6D, e.g.
R3Enterprise (R/3 4.7).
 
Prior to 4.6C you would need to access the tables directly, but you
would also need to revisit this code on upgrade.=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
 
It took me less than 1 hour to "upgrade" the code in one of the reports
I developed to use the FMs you recommended and, of course, it works
GREAT!
 
Thanks again for your help!
 
Joe Toledo
The Walt Disney Company
Project Tomorrowland
 
-----Original Message-----
From: Dart, Jocelyn [mailto:jocelyn.dart at sap.com]=20
Sent: Monday, February 09, 2004 3:43 PM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: Tables SWW_CONT, SWW_CONTOB & SWWCNTPO...
 
 
Joe,
Well for starters, NEVER read container data directly from the tables.
Container data is actually held in a number of different formats,
including XML format, depending on the release and application involved
so if you access tables directly you are at high risk of failure and
very high risk of your solutions not working after upgrades.  What
worked for 4.6C cannot be guaranteed to work in a WAS system if you
access tables directly as container handling is one of the areas that
has changed very significantly in WAS.
 
Instead please use the WAPIs and BAPIs and similar function modules
provided by SAP for customers.
 
Perhaps you could describe the situation you are trying to solve from a
business viewpoint.
 
It would also be helpful to specify what release of CRM you are working
on.  If you go to menu System > Status you should also be able to see
what Basis release you are on (6.10, 6.20?). Regards, Jocelyn
 
 
-----Original Message-----
From: SAP Workflow [mailto:Owner-SAP-WUG at MITVMA.MIT.EDU] On Behalf Of
Toledo, Joe
Sent: Tuesday,10 February 2004 9:27 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Tables SWW_CONT, SWW_CONTOB & SWWCNTPO...
 
 
Hi there WF experts.
 
I have a question.  We are currently up and running in WF using 4.6C and
we also have a couple of other boxes with CRM, EBP, etc...
 
I noticed that in the CRM system (Basis kernel 620) that the container
data is not always stored in the SWW_CONTOB and SWW_CONT tables, as it
was in 4.6C  There seems to be a new table  called SWWCNTP0 that appears
to have container elements, but the data appears to be in GUID key
format, so I'm unable to determine what the data represents.  According
the ST05, the new SWWCNTP0 table is all that WF needs to display the WF
log including the container data, whereas in 4.6C it used SWW_CONT &
SWW_CONTOB tables.
 
Can anyone tell how to decipher or get the container data using the
SWWCNTP0 table, so that I can get to the data the same was as SWW_CONT &
SWW_CONTOB?
 
Thanks in advance for your help.
 
Joe Toledo
The Walt Disney Company
Project Tomorrowland