Created Time in CRM_DNO_MONITOR

[Former Member]

Hi All..

I am having one problem related to Standard Transaction CRM_DNO_MONITOR. In this report there are fields like 'Created On' and 'Changed On'. In this field date&time data is coming different from stored in its table CRMD_ORDERADM_H. If in the table for some Object_Id its value for Created On is 13.09.2010 04:13:05 but when we are running standard transaction its value in the field is coming 13.09.2010 09:43:05. So diff is coming of 5 hours and 30 mins. I want to know how this diff is coming and why??

Thanks,

Vidhi

[Former Member]

Hi,

I think this results from your time zone.

Timestamps are stored timezone independent in crmd_orderadm_h. When they are displayed in CRM_DNO_MONITOR, the timestamps are converted to your timezone.

Regards,

Christoph

[Former Member]

Hi Christoph...

Thanks for your reply. But can you please tell me how to convert this?? Because I am not finding how it is getting converted in the report.

Thanks,

Vidhi

[Former Member]

Hi Vidhi,

use in your display structure or field the data element CRMT_CREATED_AT_USR.

If you want to create your own data element, it has to use domain CRM_TSTMP.

Just assign the timestamp from the database to this field and the conversion is done automatically!

Regards,

Christoph