Skip to Content

Dates in CRM screens

Hi Gurus,

I have a very basic question regarding dates in CRM. Where can I find dates fields in CRM tables? If I am vieing an activity and there is an 'actual date' , in which table would I find this date and the other date types?

Thank you,

Nick

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 03, 2011 at 07:10 PM

    Hi, Nick

    Please read this topic:

    How to read the data from SCAPPTSEG

    You'll have to use an intermediate table to that. The table is CRMD_LINK, and you can use it to read the dates on tables SCAPPTSEG, SCAPPT or SCGENAPPT.

    The association between the tables Is something like this:

    CRMD_ORDERADM_H-GUID = CRMD_LINK-GUID_HI (CRMD_ORDERADM_H-GUID is document header guid, for example)

    CRMD_LINK-GUID_SET = SCAPPT-APPL_GUID (the appl_guid that you're search for is on CRMD_LINK-GUID_SET)

    The CRMD_LINK table will return a couple of entries. So, in order to read dates check for the entry with this values:

    CRMD_LINK-OBJTYPE_HI EQ '05'

    CRMD_LINK-OBJTYPE_SET EQ '30'

    SAP CRM Tables and Fields for Contract start and End dates

    Check sdn by these tables: SCAPPTSEG, SCAPPT or SCGENAPPT

    Denis.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 03, 2011 at 07:21 PM

    Thanks for your help.

    Add comment
    10|10000 characters needed characters exceeded