crm table for change history assignment block

[Former Member]

Hi, everyone.

Can anyone provide us with the crm tables containing the user status changes and their corresponding date/time stamps which can be viewed in the Change History assignment block in web ui?

Thanks in advance,

Theresa

[Former Member]

Hi Theresa,

if you mean the status changelog of system or userstatus you can find it in table CRM_JCDS.

you can get it by accessing directly to table crm_jcds by documents guid.

first you can get guid of document by accessing to table crmd_orderadm_h and use the guid to get the status history using objnr = guid.

http://sapfans.com/forums/viewtopic.php?f=13&t=329301

regards

vishwantha.

[Former Member]

Hi, Vishwanatha. 

Thanks, that was actually helpful.  How about the table/s where we can find the date types in the Dates and Durations section in the Service Level Agreement or Dates assignment block?

Regards,

Theresa

[praveen_kumar194]

i thin it is SCAPPT.

[Former Member]

hi

got through below link

http://help.sap.com/saphelp_crm70/helpdata/en/69/3daad32d564b05a6fa00ef7cb2d354/content.htm?frameset...

otherwise go to particular filed check in the M-getter Method  they referring some data element.