SRM table which stored shopping cart approval start and end time

[Former Member]

Hi,

I want to know the table in SRM which stores

Shopping cart No or GUID, Shopping cart Item or GUID, Approver, Approval Start Date, Approval Start Time, Approval End Date, Approval End time.

I am trying to extract this data in BI through standard extractor and it is not working. If i get the table then I can use my own generic extractor for it.

Thanks and Regards,

Shashank

[Former Member · Accepted solution]

Hi Shashank,

You can access these data from the tables like CRMD_ORDERADM_H, CRMD_ORDERADM_I,SWWWIHEAD, BBP_PDIGP.

Regards

Sameer

[Former Member · Accepted solution]

Shashank

Sorry It was a typo error, its SWIWIOBJCT. This table gives you all the details of the workflow workitem.

Regards

Virender Singh

[Former Member]

Thanks

[Former Member]

Hi

If you are in SRM5.0 or older versions then SWIWIOBJECT is the table which has Workflow Work items for a SRM Document

If you are using Process controlled workflow in SRM7.0 there are couple of tables SWW_WI2OBJ and SWWWIHEAD

Other details like SC GUID etc can be referenced from tables available in BBP_PD view of the document.

Regards

Virender Singh

[Former Member]

Hi,

We are on SRM 4.0 and I could not find the table SWIWIOBJECT in SE 11. Are you sure the name is correct?

Regards,

Shasank