Skip to Content
avatar image
Former Member

Appointment tables

Hi guys. Could you please help me to find dates and durations in CRM tables.

I have the following data in a Sales order:

Sales order date = (for example) 16.08.2007.

And Sales order duration = 10 month.

There is SCAPPTSEG table where, as I understand, dates are to be recorded. I’ve found SCAPPTSEG - APPL_GUID = CRMD_LINK-GUID_SET. So now I can see 2 lines in the SCAPPTSEG table for my dates.

And I have the following questions:

1. For my sales order date there are records in TST_FROM and TST_TO fields= 20.070.815.220.000. So that means that date is 15.08 but not 16.08. Why does the system subtracts 1 day from my actual date? Is it right? Or may be I should take my date from some other fields or may be even from other table?

2. There is a second line in the SCAPPTSEG table for Sales order duration. But there are no fields filling with my 10 months. Could you please advice where I can find this data? May be in the other tables?

Appreciate any help.

Thanks in advance.

Sunny

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 23, 2007 at 01:25 PM

    Hello Sunny,

    1. For my sales order date there are records in TST_FROM and TST_TO fields= 20.070.815.220.000. So that means that date is 15.08 but not 16.08. Why does the system subtracts 1 day from my actual date? Is it right? Or may be I should take my date from some other fields or may be even from other table?

    Dates are stored in GMT time, you're probably in CET and that's GMT+1. If you specify a date, eg 21.10.2007 with no hour this is interpreted as 21.10.2007 00:00:00 -> System converts date/time to GMT so -1h -> 20.10.2007 23:00:00. But don't worry, the date will be shown correctly on the screen and when you convert timestamps into date - time you have to specify the timezone, if you enter CET you'll get your original date. In short, the data is correct, it's just the internal mechanism of SAP. If you don't use a from/to date the TST_FROM and TST_TO are equal.

    2. There is a second line in the SCAPPTSEG table for Sales order duration. But there are no fields filling with my 10 months. Could you please advice where I can find this data? May be in the other tables?

    And this date is showing up in your transaction? (Normally every date used in a transaction is stored in the SCAPPTSEG table)

    When you say that sales order duration = start date + 10 months you could do the calculation at runtime too.

    Hope this helps,

    Kind regards,

    Joost

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello, Joost.

      Thanks for your reply!

      You are absolutely right in the 1-st question. I have a CET time and it affects my dates.

      About the second one.

      "And this date is showing up in your transaction? (Normally every date used in a transaction is stored in the SCAPPTSEG table)

      When you say that sales order duration = start date + 10 months you could do the calculation at runtime too."

      I don't use my duration to calculate any other date. I just need to have duration in a Sales order = 10 month. And I need to know a table where duration is saved to write specification for abap consultants. 😔

      Do these 10 months have to be shown in SCAPPTSEG table? (as I said unfortunately now they are not there). Or may be anywhere else?