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

[Former Member · Accepted solution]

Hello,

They are most likely in SWWCNTP0 but they are only readable using function modules, e.g. SAP_WAPI_READ_CONTAINER.

I know, it is annoying. Much easier when they were stored in SWW_CONT.

If the document number is used in the workitem texts (e.g APPROVE: Doc no. xxxxx) then you may be able to get them from SWWWIHEAD.

regards

Rick Bakker

hanabi technology