Is there a timestamp datatype?

[Former Member]

Hi SAPians,

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,

RS

[ravikanth_indurthi · Accepted solution]

Hi Raghu,

There are no such data types for time stamps, but it can be split into two different fields Time and Data and stored in different infoobjects using routines in transformations/transfer rules.

Hope this helps...........

Rgs,

Ravikanth.

[Former Member]

Thanks. I got it. My need was to have it in a single field only.

[Former Member]

NUMC with length 14 is the way to go.