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

[Former Member]

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.

[Former Member · Accepted solution]

Hi Vinnu,

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

[Former Member · Accepted solution]

Hi Liu,

Thanks for the response..

actually my problem is..  in my zprogram i have "date_from" , "date_to" and "duration" fields,

by one of the activity i will get date_from  then date_to.. now i want the difference between these two dates means duration and that should be save and display in duration field...

how can i achieve this... if possible code...

Thanks,

vinnu.

[VishnAndr · Accepted solution]

Hello vinnu.

Check class CL_CRM_SRQM_UPDATE_DUR_DT and its method UPDATE_DURATION. There you'll find an example of the code you needed.

[Former Member]

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

[Former Member]

Hi Vicky,

Thanks for the response....

In my exploration, my duration data is coming into  ET_SERVICE_I  segment of CRM_ORDER_READ.

in ET_SERVICE_I, i found that both SRV_CONF_TIME and DURATION  fields. my data is storing under DURATION field not in SRV_CONF_TIME.

and also i am unable to find DURATION field in CRMD_SERVICE_I table.

and what about the ET_APPOINTMENT - DURATION ( my dates are storing in ET_APPOINTMENT)..?

why duration is not storing in  ET_APPOINTMENT - DURATION.

can you please explain.. if possible.  

Thanks,

Vinnu.

[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