Date Fields, Time Fields, and Time Stamp Fields
The following data types in ABAP Dictionary describe date fields, time fields, and time stamp fields:
7.31 | 7.40 | 7.54
Date Types, Time Types, and Time Stamp Types
The following built-in data types in ABAP Dictionary represent real date types, time types, and time stamp types in a database:
- DATN for date fields in the database
- TIMN for time fields in the database
- UTCLONG for time stamp fields in the database
Database fields with these types generally contain only valid values for dates, times, and time stamps (in the internal representation of the database). These types are currently only supported by SAP HANA databases.
- The dictionary types DATN and TIMN are mapped to the character-like ABAP date type and time type
t. The built-in ABAP type
utclong, on the other hand, provides a real time stamp type for UTCLONG.
- The types DATN and TIMN are recommended for saving individual dates and times. Access to dates and times in the corresponding functions and expressions is optimized for these types. In the case of the dictionary types DATS and TIMS, such access may not be possible at all or they may need to be converted to real date and time types.
- The output formats for fields on dynpros and Web dynpros and in the statements
WRITE TOcan be predefined for the types DATN, TIMN, and UTCLONG specific to each user in the user master record. The output length required for formatted output is usually greater than the number of places in ABAP Dictionary.
Character-Like Date Fields and Time Fields
Instances of the following data types in ABAP Dictionary are created on the database using character-like fields:
dand the associated rules apply.
tand the associated rules apply.
- ACCP for posting periods
- If possible, the types DATN and TIMN should be used.
- The output formats for fields on dynpros and Web Dynpros and in the statements
WRITE TOcan be predefined for the types DATS and TIMS specific to each user in the user master record. The output length required for formatted output is usually greater than the number of places in ABAP Dictionary. If the output length is too short, any formatting characters are suppressed.