Workflow Table

former_member445996 — Mon, 17 Apr 2006 21:45:44 GMT

Hi All,

Does anyone know which table or tables store the inbox items(documents)? Also, what are some of the most common workflow tables?

Thanks in advance for your feedback.

Re: Workflow Table

vinod_gunaware2 — Mon, 17 Apr 2006 21:51:56 GMT

As the system is running, index records are frequently created for the workflow runtime tables and then deleted again. This has a negative effect on performance during accesses via these indexes.

Note that you MUST shut down the R/3 System before starting the program

Depending on the data volume of the processes, indexes of the database runtime tables should be reorganized regularly (for example on a monthly basis). If you use ORACLE or INFORMIX, you can use the SAP tool SAPDBA to do this.

A reorganization should always be started after an archiving run.

The following tables / indexes should be edited in this case:

SWW_CONT - Index 0

SWW_CONTOB - Index 0

Index A

SWWWIDH - Index 0

Index A

SWWORGTASK - Index 0

Index A

SWWWIAGENT - Index 0

Index A

Index TYP

SWWWIHEAD - Index 0

Index A

Index B

Index C

Index E (as of Release 45A, if distribution is used)

SWWWIDEADL - Index 0

SWWWIRET - Index 0

Index A

SWEINSTCOU - Index B

Index C

Index D

SWWLOGHIST - Index 0

Index 1 (as of Release 4.6A)

SWZAI - Index 0 (if work queues are used)

SWZAIENTRY - Index 0 (if work queues are used)

SWZAIRET - Index 0 (if work queues are used)

SWPNODELOG - Index 0

SWPSTEPLOG - Index 0

SWP_ADM_US - Index 0 (as of Release 4.5A)

SWP_HEADER - Index 0

SWWBINDEF - Index 0 (as of Release 4.0A)

SWWRUNMETH - Index 0 (as of Release 4.0A)

SWWSWPRET - Index 0 (as of Release 4.0A)

SWP_NODEWI - Index 0 (as of Release 4.6A)

Index NOD

Tables

SWWWIHEAD Different selections of data of the table SWWWIHEAD take a long time.

<b>tRFC and qRFC tables</b>Tables ARFCSSTATE and ARFCSDATA

regards

vinod

Re: Workflow Table

suresh_datti — Tue, 18 Apr 2006 01:08:00 GMT

>>which table or tables store the inbox items(documents)?

Did you try any of the SO* tables? SOFM in particular..

Regards,

Suresh Datti

topic Workflow Table in Application Development and Automation Discussions

Workflow Table

Re: Workflow Table

Re: Workflow Table