Need Approver details Tables in SRM

[Former Member]

Dear Experts,

Have an issue, at BI BEx Report level Instead of Auto Approval it is happening Manuel Approval. To find out solution for this we are checking the data which is coming from the Extractor: 0BBP_TD_SC_1

Now, my question is how can we find out the tables which are used in this Extractor????? and where Approver's information laying in SRM system???

Thanks for your instance help.

Regards,

Raj

[Former Member]

Did you manage to find the tables ? I am also looking for the below data not sure where to check ?

I need these fields in relation to the SC .. Please advise ..

[Former Member]

Not sure about the extractor per se, you can debug it maybe via transaction RSAG with /h, etc.

But in general look at table SWW_WI2OBJ; put the shopping cart number in the "Instance ID" field complete with leading zeros, Object Type BUS2121 and Object Category BO. This will return the task number of the incomplete task, as well as the date the task was created. The u201CIDu201D field (not u201CWorkflow IDu201D) here is the key needed to look up who has the open work item. Using the ID field value from the prior join that up with entries in SWWUSERWI to get the ID of the current task owner.

Hope this opens a few doors for you.

[Former Member]

Hi Raj,

Refer the tables SWW_CONT and SWW_CONTOB.

Velrajan

[Former Member]

Hi,

Use the Foll FM to get the approvers for any document.Just pass the work item ID to the FM:

BBP_WFL_DIN_APPR_FINALLIST_GET

BR,

Deepti.

[Former Member]

Hi,

Please check with SRM guy, which workflow they are using in SRM and if they are maintainging any 'Z' tables for approvers

in SRM system.

Thanks

prasad.s