SAP Tables for Workflow

[former_member150733]

Hi,

I want to know the main SAP tables that are used by Workflow. Can anyone help.

I would specifically like to know where the work flow / Work item id is stored. Is there any function modules to find out the workflow/workitem id.

Thanks in Advance,

Anish Thomas

Message was edited by: Anish Thomas

[former_member186746 · Accepted solution]

Along with the SWW* tables,

Table HRS1201 has info on tasks and methods

And table hrs1205 has the info of the active version of the workflow.

Regards, Rob Dielemans

[Former Member]

Hi,

Base on what i have experienced regarding workflows, there are two main table for the work items.

SWW_WI2OBJ - Workflow Runtime: Relation of Work Item to Object

SWWWIHEAD - Workflow Runtime: Header Table for All Work Item Types

Fields: TOP_WI_ID - Workflow ID.

           WI_ID - Work item ID.   

Hope it helps

Regards,

Rex

[Former Member]

Is there a diagram available that shows the table relationships?

Message was edited by: Paul Carey

[Former Member]

For SRM

Check this Function Module BBP_WFL_SC_ACCT_GETDETAIL

See if this helps

Cindy Sy

[former_member181875]

Hi Anish,

Why do you need to know which tables are used?

The fields change from release to release so unless you have really good grounds to otherwise then it's much better to use the SAP_WAPI* function modules.

Best regards,

Alan

[VijayasekarK]

Hi Anish ,

See the package SWW in SE80 , you will get all sap objects ( tables , function group ,etc ) w.r.t workflow

regards,

vijay

[Former Member]

Hi Anish,

the main header table is SWWWIHEAD, other related tables are named SWW*.

There are also quite many standard functions available for reporting, please check fm:s SAP_WAPI_GET* and SAP_WAPI_WORKITEM* for more reference.

Hope this helps,

Mikko