Linkage of SC with workitem and status

[Former Member]

Hello,

Please inform the tables where I can link the SC to the work item and the status (apporved / created), indicating the status of the approval. 

I have to write a query to identify SC which are fully approved but erred in creating backend document or Current SC approval process.

Thanks,

Bhavesh

[former_member216093 · Accepted solution]

Dear Bhavesh,

The table is SWIWIOBJCT. Check it.

For Process controlled workflow these are the tables  SWW_WI2OBJ and SWWWIHEAD

Please don't forget to award points as appropriate.

Regards,

Ravi

[Former Member · Accepted solution]

Hello Ravi,

This table will give me the list of all workitems under the SC, I am interested in mapping og SC with the main workitem as identified in BBP_PD, unfortunately its not the first one in the table.

Regret for late comment as I was travelling.

Thanks,
Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

Can you try CRM_JEST. Pass the SC header GUID for header level status and individual item GUIDs for item level status.

Hope this helps.

Regards,

Ajay

[Former Member · Accepted solution]

Hi Bhavesh,

For AC the only I use is SWIWIOBJCT.

You use PC WFL?

This might be useful for you:

http://wiki.scn.sap.com/wiki/x/JoTOEg

Cheers,

Melina