Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-BW-SRV (Application Component) BW Generation Tool and Set Object⤷
SODQS (Package) Operational Delta Queue Services
Basic Data
| Data Element | ODQ_TIMESTAMP_ID |
| Short Description | Unique Time Stamp ID (such as TSN, TID) |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ODQ_TSN | |
| Data Type | DEC | Counter or amount field with comma and sign |
| Length | 23 | |
| Decimal Places | 9 | |
| Output Length | 35 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Time St.ID |
| Medium | 20 | Time Stamp (TSN) |
| Long | 40 | Unique Time Stamp ID (such as TSN) |
| Heading | 28 | Unique Time Stamp ID |
Documentation
Definition
A time stamp ID is a unique time stamp used in the SAP system.
The time stamp ID is set centrally using the enqueue service. The ID consists of a time stamp value (exact to the second) in UTC and a sequence number with a maximum of 6 digits, which can be added to the time stamp value as decimal places.
Time stamp IDs are used in the delta queue in different roles, for example,
The time stamp ID is formatted as follows when displayed: {Date Time Sequence Number Time Zone}
The following applies:
- Date is the date part of the time stamp (YYYY-MM-DD) formatted in the ISO standard
- Time is the time part of the time stamp (HH:MM:SS) formatted in the ISO standard
- Sequence number is a six-digit sequence number that returns the sequence of time stamp IDs in the same second
- Time zone is the time zone configured in the user settings of the user currently logged on.
Date and time are formatted according to ISO 8601, regardless of the profile of the user currently logged on.
Use
Abbreviated entries can be used as input (see the following examples). The following rules apply:
- If you do not enter a date, the time stamp ID relates to the current day.
- If you have entered a number greater than or equal to 10,102,000,000 then the number is interpreted as a UTC time stamp. The first six decimal places represent the sequence number.
- You can also use a decimal point (internal ABAP format) in the time stamp entries, if a decimal comma is configured in the user settings. If an entry is ambiguous (for example, 1,234), then the format that matches the user settings has priority.
- You can enter abbreviated times. Numbers from 1 to 23 are interpreted as times that are exact to the hour. Numbers from 100 to 2359 are interpreted as times that are exact to the minute. Numbers from 10000 to 235959 are interpreted as times that are exact to the second.
- If you enter two numbers separated by spaces, the first number is interpreted as the time and the second number is interpreted as the sequence number.
- If you enter three numbers, you can specify an abbreviated date in the usual six-digit format (for example, 091210 instead of 9.12.2010).
- You have the option of adding a valid time zone for interpreting the date and time (with the exception of time stamp input).
Dependencies
Example
The following examples require that the entry on the 2nd February 2011 is made with the following user settings:
Decimal format: 1.234.567,89
Date format: DD.MM.YYYY
Time zone: CET
A time stamp ID assigned by the enqueue service on the 1st February at 11:34:56 UTC is displayed for a user with the Central European Time zone CET (equal to UTC +1) as follows:
{2011-02-01 12:34:56 000123 CET}
The following table lists the various possible input conversions:
Input Internal value (UTC) Output
1 2.0110.201.000.000,000000 {2011-02-01 01:00:00 000000 CET}
12 UTC 2.0110.201.120.000,000000 {2011-02-01 13:00:00 000000 CET}
123 2.0110.201.002.300,000000 {2011-02-01 01:23:00 000000 CET}
1234 2.0110.201.113.400,000000 {2011-02-01 12:34:00 000000 CET}
12345 2.0110.201.002.345,000000 {2011-02-01 01:23:45 000000 CET}
123456 2.0110.201.113.456,000000 {2011-02-01 12:34:56 000000 CET}
1234 123 2.0110.201.113.400,000123 {2011-02-01 12:34:00 000123 CET}
011210 1234 123 2.0101.201.113.400,000123 {2011-02-01 12:34:00 000123 CET}
20110201113456 2.0110.201.113.456,000000 {2011-02-01 12:34:56 000000 CET}
2.011.020.111.3456,789012 2.0110.201.113.456,000123 {2011-02-01 12:34:56 789012 CET}
2,011,020,111,3456.789012 2.0110.201.113.456,000123 {2011-02-01 12:34:56 789012 CET}
20110201113456.789012 2.0110.201.113.456,000123 {2011-02-01 12:34:56 789012 CET}
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 703 |
