Flexible workflow table details

[SAPSupport]

Hello Team,

Want to know the tables in which the approver details are stored when we maintain through "manage workflow for central purchase contract" and "manage workflow for centrally managed purchase order" apps.

Thanks,

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hi,

My name is Lisa from the MM team. I have checked your query and would ask that you please review the following:

The details of approvers assigned to certain workflows are not stored in tables.

Workflows can be viewed in transaction SWF_PROCESS_ADMIN and if you then click into each workflow and select the desired version. All details can be seen here.

These are the tables used by Flexible Workflow when a document is relevant for approval:
SWW_CONT - Container Contents for Work Item Data Container
SWW_CONTOB - Container Cont. for Work Item Data Container (Only Objects)
SWWLOGHIST - History of a work item
SWWUSERWI - Current Work Items Assigned to a User
SWWWIHEAD - Header Table for all Work Item Types
SWW_WI2OBJ - Decision comments related to the work item/Workflow Runtime: Relation of Work Item to Object

I hope this helps further with your query.

Kind Regards,
Lisa
SAP Support

[MO_samir · Accepted solution]

Hello Lisa,

regarding the same topic, i'm getting latest work id from table sww_wi2obj then checking in table swwuserwi to get release date and time, in case no entry in swwuserwi then tis means the po is fully release then i go to table SWWWIHEAD with work id to get date, time and username.

my issue is in case of release cancelation no update on the data in these tables and i can not detect in my report of there is a cancelation or not.

can you help with this point

[phfranca · Accepted solution]

Hello everyone! I am trying to create a query using T-CODE SQVI that includes the tables EKKO, SWW_WI2OBJ, and SWWWIHEAD. However, I need one or more tables that I can use to establish relationships between EKKO and SWW_WI2OBJ/SWWWIHEAD. Could someone guide me on how to create the relationship between these, or possibly other, tables? Ultimately, I would like to query the purchase order and receive data from the SWW_WI2OBJ and SWWWIHEAD tables. The query should include EKKO, SWW_WI2OBJ, and SWWWIHEAD.

[David_mT · Accepted solution]

Thanks a lot. Just missing table to find "Workflow Steps", for example Purchasing group of purchase order is XXXX net amount of purchase order is less than or equal to 1.000,00EUR