In which table can i get all the SC for an approver.

[Former Member]

Hello, i need to get a list of all SCs that an approver X has in his inbox.How can i do this(table preferably)?

thx in advance

[Former Member · Accepted solution]

Hi,

You can do the following :

Run FM SAP_WAPI_CREATE_WORKLIST by giving the User Id as Input. This will return all the workitems WIS[] for the user irrespective of the Business Objects.

Use this result and filter by reading the records from table sww_contob. you can give the object type to this as 'BUS2121' . and lv_cont_obj_name ='REQREQ' and map the work id with WIS[].

This would give you all the records meant for approval for an approver.

Best Regards,

Sapna

[Former Member · Accepted solution]

thx a lot. i did not understand what you meant by ' map the work id with WIS[]'.

i understood that you must run FM SAP_WAPI_CREATE_WORKLIST with the approver name.

then go to table SWW_CONTOB and input the WI_ID , ELEMENT = REQREQ and OBJTYPE ='BUS2121'

[Former Member · Accepted solution]

Hi,

You have to read the table sww_contob in the following way:

SELECT wi_id FROM sww_contob

INTO TABLE 'table_name'

FOR ALL ENTRIES IN WIS WHERE wi_id = WIS-wi_id

AND element = 'REQREQ'

AND objtype = 'BUS2121'.

The result set 'table_name' will have all the required work id's for the approver.

Regards,

Sapna

[Former Member · Accepted solution]

Hi,

This is not a table, but is very useful.

Tx SWI5

Type: US

ID: User ID

Flag u201CTo be processed byu201D

Regards,

Abraham