Skip to Content
avatar image
Former Member

Created Time in CRM_DNO_MONITOR

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 14, 2010 at 01:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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