Finding Release Date in CRM Service Contract Item

[former_member367551]

Hi forumers,

Might anyone know how I can find the Release Date in an CRM Service Contract Line Item?

In other words, from which data dictionary table / FM can I find this information?

I have tried using the FM, CRM_ORDER_READ and checked the exporting parameter, ET_SCHEDLIN_I -> but the release dates here are all blank.

I can see this information in CRMD_ORDER transaction -> Service Data tab -> Service Plan Data -> Dates -> Release Date.

Appreciate any help at all.

Thanks.

[Former Member · Accepted solution]

Hi Deborah

Using the correct FM.

Check the APPOINTMENTS Export Table.

Regards

Arden

[former_member367551 · Accepted solution]

Thanks, Arden. This worked

[former_member367551 · Accepted solution]

Dear Arden,

Any hint on where might I find this in a data dictionary table?

[Former Member · Accepted solution]

Hi Deborah

Take a look at table: SCAPPTSEG

Regards

Arden

[former_member367551 · Accepted solution]

Dear Arden,

I had seen this table earlier, but I'm unable to find the DATE_FROM data for APPT_TYPE = 'SPLA_SCHED' -- even in other tables.

[Former Member · Accepted solution]

That is odd especially if the values are coming through on APPOINTMENT

[former_member367551 · Accepted solution]

Found these lines in the class, CL_APPOINTMENT of the method, GET_DATA:-

      CONVERT TIME STAMP appointment_data-tst_from

              TIME ZONE appointment_data-zone_from

              INTO DATE appointment_data-date_from

                   TIME appointment_data-time_from.

      CONVERT TIME STAMP appointment_data-tst_to

              TIME ZONE appointment_data-zone_to

              INTO DATE appointment_data-date_to

                   TIME appointment_data-time_to.

So, TST_FROM and ZONE_FROM are converted into DATE_FROM -- this is what I need.

Thanks much~