List of open documents for shopped on behalf user

[Former Member]

I'm producing a list of open documents for a user by querying table CRMD_ORDERADM_H where CREATED_BY = user. However, this doesn't work for shop on behalf because the actual creator is put in this field and not the person who was shopped on behalf. Any suggestions on how to retrieve the shop on behalf documents based on shopped on behalf user and not creator?

We're running the EBP extended classic scenario with SRM 4.0 and SRM_SERVER 5.00.

Thanks,

Brad

[imthiaz_ahmed · Accepted solution]

Well if I understood correctly. Here is the answer, You have to search by "Requester" not by "Creator" of the SC. In that case you need to first hit the CRMD_PARTNER table using the partner guid, get the GUID, then hit the CRMD_LINK table and then get the GUID__HI, then again go to table CRMD_ORDERADM_I and get the parent GUID and hit CRMD_ORDERADM_H. Hope it solves your problem.

Regards,

Imthiaz