Skip to Content

SQVI Query: Document is approved by last approver but still the document stuck in Awaiting Approval Status due to workflow error

A simple SQVI Query can be created in order to achieve the subjected requirement. Kindly get the details below.

Tables to be Joined:

  • CRMD_ORDERADM_H – Document header Table
  • /SAPSRM/D_WF_000    – Table for persistent class /SAPSRM/CL_WF_PROCESS
  • SWWWIHEAD              – Header Table for All Work Item Types

Selection Screen Fields:

  • Transaction Number                               – CRMD_ORDERADM_H-OBJECT_ID
  • Business Trans. Cat.                             – CRMD_ORDERADM_H-OBJECT_TYPE
  • Posting Date for a Business Transaction – CRMD_ORDERADM_H-POSTING_DATE
  • Work item text                                       – SWWWIHEAD-WI_TEXT
  • Processing Status of a Work Item           – SWWWIHEAD-WI_STAT

Output:

Transaction Number

+As per your requirement

Join Conditions:

Join the GUID of CRMD_ORDERADM_H to DOCUMENT_GUID of /SAPSRM/D_WF_000.

Join the WORKFLOW_INST_ID of /SAPSRM/D_WF_000 to TOP_WI_ID of SWWWIHEAD.

Run the query for below selection values:

Business Trans. Cat                              = BUS2201

Posting Date for a Business Transaction = As per your requirement

Work item text                                       = Handle Process Finish

Processing Status of a Work Item           = ERROR

With above selection values, you will get the required documents.

Regards,

Arpit

Be the first to leave a comment
You must be Logged on to comment or reply to a post.