How to get Shopping Carts based on UserId's?

[Former Member]

Hello All,

I want to get all the shopping carts by passing the User Id.

Is there any FM which suits the requirement??

Regards,

Yugesh A.

[Former Member · Accepted solution]

Hi Yugesh.

You can get all the shopping cart by fetching all the object_id from CRMD_ORDERADM_H

Where PROCESS_TYPE = 'SHC ' and created_by = sy-uname.

Regards,

Neelima

[Former Member]

Hi,

please check t.code: BBP_BW_SC4

Report in SRM where you can enter the user ID and Cost centre is mandatory field

Regards

Ganesh kumar .G

[Former Member]

Hello All,

Is der any std table which maintains approvers for a particular SC??

Regards,

Yugesh A.

[Former Member]

Hello Yugesh,

Check this link , it might help you.

Regards,

Neelima

[Former Member]

the approver is the last person who change the doc right?

can you also check by CHANGED_BY = 'USER ID'.

OBJECT_TYPE = BUS2121

CHANGED_BY = USER ID

and then get all the Shopping carts get the GUID of them and check table CRM_JEST for approve status.

If i'm not wrong I believe the STAT for Approved is "I1129".

hope this help!

Jason PV

[Former Member]

Hello Neelima,

I am in SRM7.0.

I dont have any of Object Id and header guid. I have only UserId of the Approver.

I want all the SC's under his approval.

Regards,

Yuges A.

[Former Member]

Hello Neelima,

Thanks for the information provided. Is ther any possibility to know the SC where are under "Approval status" for a given UserId. Means, I will pass the UserId, and I want the details of SC's which are to be APPROVED by the user.

Regards,

Yugesh A.

[Former Member]

Hello Yugesh,

Which version your are in??

You can get the status of the Shopping cart FM BBP_DOC_STATUS_GET.

Give the following details to the FM

Import parameters

IV_OBJTYPE = object_id

IV_GUID = header guid

Tables

IT_STATUS = Give all the entries in exist in crm_jest table for same header guid of the shopping cart.

In export parameter u will get the status in

EV_STATUS

EV_STATUS_DESCRIPTION

Regards,

Neelima.

Edited by: S Neelima on May 26, 2010 8:17 AM