Skip to Content
author's profile photo Former Member
Former Member

workflow tables for query

Hi everybody, we've implemented the workflow for payment release (WS90000021), but we need some reports in order to audit the process, like:

Status of documents (workitems) and who have them in their business workplace.

Does someone knows wich workflow tables I can use to make a query??

Regards

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Dec 19, 2008 at 11:46 PM

    Hello,

    Try the SWW* tables, notably SWWUSERWI and SWWWIHEAD.

    regards

    Rick Bakker

    Hanabi Technology

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2008 at 04:34 AM

    Hi Eugenia Zuniga

    For determining the agent name you can use this table SWWWIAGENT and for searching the workitem you can use sww* in table and press f4.

    Regards

    vijay

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2008 at 04:49 AM

    Hi,

    You can make use of some function modules that reads the workflow log. You can call them in a report and then call this report in your workflow.

    This will do all the job.

    Here's the report program

    REPORT ZWFLOG.

    DATA : WF_LOG LIKE SWP_LOGTAB OCCURS 0 WITH HEADER LINE.

    DATA : WA_WF TYPE SWP_LOGTAB.

    CALL FUNCTION 'SWP_WORKFLOW_LOG_READ'

    EXPORTING

    TOP_LEVEL_WF = '000000059015'

    • WF_ID =

    • LANGUAGE = SY-LANGU

    • NESTING_LEVEL = '1'

    • WITH_NODES = 'X'

    • WITH_MESSAGES = 'X'

    • EXPAND_SUBFLOWS = ' '

    • ARCHIVE_MODE = ' '

    • ARCHIVE_DATA =

    • WITH_BLOCKENDS =

    • IMPORTING

    • FLOWITEM =

    TABLES

    WF_LOG = WF_LOG

    • EXCEPTIONS

    • WORKFLOW_DOES_NOT_EXIST = 1

    • OTHERS = 2

    .

    IF SY-SUBRC <> 0.

    • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    LOOP AT WF_LOG INTO WA_WF.

    WRITE : /.

    WRITE : (12) WA_WF-WI_ID,

    (72) WA_WF-WI_TEXT,

    (9) WA_WF-WI_AAGENT,

    (12) WA_WF-WI_CD,

    (12) WA_WF-WI_CT,

    (10) WA_WF-WI_STAT.

    ENDLOOP.

    Just pass the workflow instance no. to this FM and this will work.

    Regards,

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2008 at 10:40 PM

    This has been asked and answered many times before. Avoid accessing tables directly, and use the SAP_WAPI* function modules.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.