Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.


Former Member
Not what you were looking for? View more on this topic or Ask a question