database table for Workflow Container values

[bhakti2]

hi,

I am on SAP ECC 6.0

I am trying to find workflow id number starting from document number

I try to find database table which has containe values of the workflow instances so that I can get workflow/workitem instance numbers for the document

this is custom workflow and it is not based on business object type. so checking container values is the onlyway I can get the workflows

but I am not able to find any table for it

I have checked following

SWW_CONT

SWW_CONTOB

SWWVCONTWI

SWXML_CONT

SWJ_CONT

SWJPCONT

SWJSCONT

SWPCMPCONT

SWU_CONT1

SWUOCONT1

almost all the SWCONT tables

Morever I put St05 trace to see all the tables in database operations while triggering the workflow

but the only tables seen here are

SWWHRINDEX

SWD_CONT

SWWWIHEAD

SWWCNTP0

SWWLOGHIST

SWWWIRET

SWWCNTP0 is Workflow Container: XML Database (P0)

but it is XML structure data. so its of new use to query container fields.

is this reason because of any workflow design or system config ?

how to read container values from database tables in such case?

thanks

bhakti

[Joseph_BERTHE1]

Hello,

We have developed a solution to full fill this kind of requirement. It is a powerfull tool which is able to adapt to any kind of business need like searching inside a container and apply actions to workitems.

I can help you if you want, contact me by email.

We can send to you documentation as well.

Kind Regards

Joseph BERTHE

joseph.berthe@renelco.ch

[Former Member]

You cannot advertise for your products here. Please review the rules of engagement: http://scn.sap.com/docs/DOC-19331 where it clearly states: "Do not embed links to ads in blogs, documents, and forum discussions.  The same goes for email solicitations and advertising."