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. Ive 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.