Skip to Content
avatar image
Former Member

which table holds "duration" between two dates in any transaction of crm

Hi All,

In CRM_ORDER_READ  i am able to see the "duration" in ET_appointment. but exactly in which table i can find this field with data..

searched SCAPPT and SCAPPTSEG tables  unable to find. i want this "duration"field  in one zprogram as input field data should be saved in (table?).

  
Thanks,

vinnu.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 29, 2014 at 03:10 AM

    Hi Vinnu,

    It is stored in table SCAPPT. You can get it as per the field "APPT_GUID".

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 10:18 AM

    Hi Vinnu,

    You can see the duration feild in table CRMD_SERVICE_I as feild SRV_CONF_TIME  '"Confirmed Duration".

    Hope it will resolve your query

    Thanks!!

    Regards,

    Vicky

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      Hello Vinnu,

      Expanation to your query "" why  duration is not storing in  ET_APPOINTMENT - DURATION"".

      Try to create a transaction and keep debugger in CRM_ORDER_MAINTAIN and check what values are passed into the table structures input_fields like in ET_SERVICE_I and  ET_APPOINTMENT.

      You will observe that value of "duration" field is passed into ET_SERVICE_I structure not in ET_APPOINTMENT structure.

      Praobable solution to fetch the value of  "duration"field  in your zprogram is to read the structure ET_SERVICE_I from crm_order_read and the use it as you want.

      Hope it will resolve your issue.

      Thanks!!

      Regards,

      Vicky