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

[bhakti2]

thank you for the reponse

solved problemby making entry in z-table at different points in workflow

thanks

[Former Member]

Hello,

Making a Z table is not a good idea when the data is already stored in the workflow log.

regards

Rick Bakker

hanabi technology

[bhakti2]

hi RIck,

i do not have the workflow id number with me

i have invoice number for which i need to find the workflows

busines object has not been used in the wf design so i cant use WAPI funciton modules to get wf instance number from the invoice document number

pl advice.

thank you

[Former Member]

Hello,

If you can still change the workflow then I would add a BOR (or class) which does include the document number.

If not, you could retrieve every instance of that workflow (search on WS..... number) and check the container of each one (using SAP_WAPI*) till you find the document number. Of course, that may be a problem if there is a huge number of them. You could check them in reverse chronological order if recent ones are more likely to be sought, it all depends what this is for.

You're right, making a Z table could be the best thing to do here. But only as a last resort.

regards

Rick Bakker

hanabi technology