on 05-27-2013 2:14 PM
Hi All,
I need to list all the SC(Shopping Cart) and PO(Purchase Order) created for a WBS element till date.
Is there any standard report or table available in SAP SRM7 to achieve this?
Regards,
Amarjeet
Hi Amarjeet,
For SC, You can create a Query with the following logic. Or if it is just a one time requirement you can take the data in excel and get the list with the combination of different tables.
- Go to table BBP_PDACC : Give the Acc Assgn Cat + Cost Object(WBS Value), get the Parent GUID
- Go to CRMD_LINK, in the field Object GUID (GUID SET) give the parent GUID which you have got from table BBP_PDACC.
- From the CRMD_LINK you will get the GUID from field (GUID H). These are the Item GUID of the object type.
- Put this GUID into table CRMD_ORDERADM_I in field GUID. within the table you will get PARENT/HEADER GUID of the SC.
- Put the Header GUID in table CRMD_ORDERADM_H. You will get the Object id (SC)number. Check the Transaction number against Transaction type SHC.
Best Regards,
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For shopping carts, use Shopping cart Monitor. Here you have the option to search carts based on Account assignment and creation date
For PO, you can use Advanced search.
Regards,
Sushil.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes , you can do this in 'advance search' option available in SRM portal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.