Approver's email address in Shopping cart Approval Flow

[Former Member]

Dear SRMers,

System Information: SRM 4.0.

Can you please let me know which database table in SRM stores the email address of the approver in the shopping cart approval flow.

Points will be rewarded for answers.

Thanks & Best regards,

Bob

[mani_sreedharala · Accepted solution]

Hello Bob,

The approver email address will be same as the email address of the corresponding SU01 User entry.

If you check the table SWWWIAGENT,which contains all the approval agents for the workitems and from here take the user Id and query it to SU01 transaction and you will the email address.

Hope this information will be useful.

Regards,

Mani

[Former Member · Accepted solution]

Hi Mani,

Thanks for your reply.

So the Approver's email address is not stored in any shopping cart tables, except for the SU01 User record?

Thanks in advance.

Best Regards,

Bob

[mani_sreedharala · Accepted solution]

Hello Bob,

Yes, the email address is purely driven from the SU01 user record. If you see the ORG structure PPOSA_BPP for the approver ,the position is tightly integrated to the SU01 record and based on this i am saying this.

Any other alteratives might be there and hope the SRM gurus -:) will respond to it.

Regards,

Mani

[Former Member · Accepted solution]

Mani, Thanks for your prompt response.

Points have been rewarded

[Former Member · Accepted solution]

Hi Mani,

FYI.

HRP1032 table related to HR objects also stores the email address.

Thanks,

Raj