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.

Sunny

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