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]

Hi Bhakti,

Please could you advise me how we use Z table in workflow.

My requirement is escalate approval work item to the users supervisor if an approval is not executed after 3 days.

I'm new to workflow so please advise.

Thanks in advance.

Sudheer

[Former Member]

Hello,

Since you are new to Workflow I will offer you some advice:

Do NOT use Z tables with Workflow, unless there is no other option.

For example, in your case you can probably make use of rule AC00000168 to find the line manager.

Please always open a new thread with the specifics of your question, you will get more answers that way.

regards

Rick

[bhakti2]

there is no requirement of ztable

also following wat Rick says

in yr case created a loop

inside that loop keep the approval dialog workitem

put latest end details and bring out a modeled deadline

in the deadline outcome, mark the dialog workitem to obsolete

you will need to activate the obsolete outsome in the dialog step

in the obsolete branch outcome set appropriate counters for looping and changing agents

Message was edited by: Bhakti . (corected for there is 'no' req of ztable