Is there a timestamp datatype?
I am trying to create a timestamp (Date and time) field in a custom table on the R/3 side. (used Tcode se11). I do not see any predefined data type relating to timestamp. I saw some other R/3 tables and they seem to use NUMC field with 14 lengh to hold the timestamp value. YYYYMMDDHHMISS
Is this what I need for storing timestamp values? Would SAP recognize that I am storing timestmp values and would it correctly do the right comparison if I compare this field value with another timestamp value to say which one is higher or lower (in terms of the actual time)..
If there is one SAP provided, please let me know .. please try to be specific with some example as to how to include it as a field in a table.
Answers do merit points.
I did search before posting this question..
Thanks in advance,