Question Re: Workflow tables in Technology Q&A

Workflow tables

Former Member — Wed, 25 May 2011 18:10:12 GMT

Hi experts,

am Vasanth,

i have experience in abap but now the project is about handling the values of workflow trace so i am a bit confused.

I did search alot and requesting now about the tables api's or function modules in PI/xi where i can get attributes of workflow trace (swf_trc).

Please let me know few bapi's or Fn. Modules or rfc and tables for swf_trc where i can get values like who created trace and time and date and other important values.

Will Really appreciate any help.

thanks alot

Best Regards

Vasanth.

Re: Workflow tables

bpawanchand — Wed, 25 May 2011 18:36:07 GMT

Welcome to SCN the best place to start is check the

[Business workflow Wiki page|http://wiki.sdn.sap.com/wiki/display/ABAP/SAPBusinessWorkflow].

And you can all the WAPI Workflow Application Programming Interfaces from SE37 search simply SAP_WAPI* click F4.

Some important tables

SWWWIHEAD, SWWUSERWI

Txn: SWI1, SWUD, SWUE, SWUS, SWI2_DIAG, SWEL , SWELS.......

Regards

Pavan

Edited by: Pavan Bhamidipati on May 26, 2011 12:06 AM

Re: Workflow tables

Eddie_Morris — Wed, 25 May 2011 18:46:09 GMT

Hi Vasanth,

Why do you need data from the trace tables exactly.

Regards,

Eddie

Re: Workflow tables

Former Member — Thu, 26 May 2011 04:46:03 GMT

Hi,

Please find some important tables below....

SWEINSTCOU : Instance Linkage Event u2013 Receiver

SWFDEVINST : Event Linkages with Instance Reference

SWW_CONTOB : Work Item Data Container (WI to Business Objects)

SWW_CONT : Workflow Runtime: Work Item Data Container

SWWORGTASK : Assignment of WIs to Org. Unit/Task (WI to Task)

SWWWIHEAD : Header Table for All Work Item Types

SWW_WI2OBJ : Workitem form Bus Object Key ( e.g. Material No )

SWWLOGHIST : History of a Work Item

SWW_OUTBOX : DB View for Selection of Outbox ( WI text, WI stat etc)

SWWUSERWI : Current Work Items Assigned to a User

HRP1001 : Infotype 1001 DB Table ( Resp to Org Obj )

HRP1240 : DB Table for Infotype 1240 ( Resp to Rule )

HRP1217 : Infotype 1217 DB Table ( All Task Details )

AGR_USERS : Assignment of roles to users

HRSOBJECT : Index for Standard Objects ( e.g. All running workflows )

SWETYPECOU : Type Linkage Events u2013 Receiver

SWFDEVENA : Activations for Event Linkages

SWFDEVTYP : Event Linkages Without Instance Reference

SWETYPEENA : Type Linkage Events - Receiver: Activation Table

Thanks and regards,

SNJY

Re: Workflow tables

Former Member — Thu, 26 May 2011 07:12:25 GMT

Hi,

funny, I knew the workflow trace existed but I have never yet have to use it.

Since you're an abapper why didnt you simply activate the SQL trace execute the transaction and see which tables are touched.

ST05

Kind regards, Rob Dielemans

Re: Workflow tables

bpawanchand — Thu, 26 May 2011 07:14:07 GMT

Hey Rob

You are right... Even I Missed this.... Yep Great Man Accepted....

Regards

Pavan

Edited by: Pavan Bhamidipati on May 26, 2011 12:47 PM

Re: Workflow tables

Former Member — Thu, 26 May 2011 07:38:06 GMT

Hi,

also check package SWT in se80, there are function modules and stuff.

But why are you using the workflow trace (SWU10)?

I always thought this is extremely resources consuming and should only be used in rare and temporary cases.

I might also be completely disinformed about this 😛

Kind regards, Rob Dielemans

Re: Workflow tables

Former Member — Thu, 26 May 2011 18:27:18 GMT

Pavan,

Thank u for the wapi's i searched keeping sap_wapi*.

I got nice usefull wapi's also tables.

I think i can make usefull of those and get attributes required. I also debugged transaction code swf_trc to know which tables and function modules it is using.

Actually i found one function module Display_trace_list (i think ) But the out put from this function module is in screens. For POC (proof of concept) I need a Bapi or Function which can just fetch and display few fields of swf_trc.

Right now i am trying to create a F. module but for POC i wanted one bapi or rfc where i can show them these information we can get. actually i am also trying to use that function module and remove screens and get just data.

If you came or come across any bapi or function module let me know.

Best Regards

Vasanth

Re: Workflow tables

Former Member — Thu, 26 May 2011 18:29:42 GMT

Hi Eddie,

We here are trying to fetch values of workflow trace and show them to customer. like a proof of concept i need a bapi or an rfc which can get atleast few attributes of swf_trc and show.

Let me know if you came across anything similar.

Thanks in advance.

Regards

Vasanth

Re: Workflow tables

Former Member — Thu, 26 May 2011 18:43:50 GMT

Snjy,

Thanks alot for info.Info is stored in different different tables and i need to create a custom bapi or rfc to get all attributes from these tables. but if u came across any function module or rfc or bapi please let me know.

I am also trying to create an rfc but leads prefer Standard bapis.

regards

Vasanth

Re: Workflow tables

Former Member — Thu, 26 May 2011 18:49:54 GMT

Rob,

Thank you i did get lot function modules from SWT package. Thank u .

We are working on a concept to get values from workflow trace and actually many other transactions via rfc .

so was searching for standard bapis or rfc which i can show them but dint get much on workflow trace. got about workflow work items and delete information (got rfc related).

So wanted to know any standard bapi or function which can help me .

Regards

Vasanth.

Re: Workflow tables

Former Member — Mon, 30 May 2011 09:23:51 GMT

Hi,

What didn't they like about the SAP standard transaction for showing information?

Also why do you need the workflow trace?

I usually train managers in the usage of SWI5, which is enough in most cases to get information on the usage of workflows in their production system.

Kind regards, Rob Dielemans