SAP table TTSTR (Time stream: Administration table)
SAP table TTSTR has 4 primary key fields being MANDT,TSTRTYPE,TSTREAMID,CALENDARID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| TSTRTYPE | Time stream: Type | CHAR | 2 | 0 | TSTRTYPE |
|
|||||||||
| TSTREAMID | Time stream: External ID | CHAR | 10 | 0 | TSTRID | ||||||||||
| CALENDARID | Calendar ID | CHAR | 2 | 0 | TFACD | TSTRCALID | |||||||||
| RELID | Time stream: Area in IMPORT/EXPORT data table TSTRCOMP | CHAR | 2 | 0 | TSTRRELID | ||||||||||
| HANDLE | Time stream: Time stream handle | CHAR | 32 | 0 | TSTRHANDLE | ||||||||||
| BUFFEROPT | Time stream: Buffer option | CHAR | 1 | 0 | TSTRBUFFOP |
|
|||||||||
| CALCOPT | Time stream: Option for arith. operations | CHAR | 1 | 0 | TSTRCALCOP |
|
|||||||||
| GENOPT | Time stream: Generation options | CHAR | 1 | 0 | TSTRGENOP |
|
|||||||||
| FLAGCONTIN | Time stream: 'Without gaps' flag | CHAR | 1 | 0 | TSTRCONTIN | ||||||||||
| TZONE | Time Zone | CHAR | 6 | 0 | TTZZ | TZNZONE | |||||||||
| SCOPEGENFW | Time stream: No. of years generated in the future | NUMC | 2 | 0 | TSTRSCOPFW | ||||||||||
| SCOPEGENBW | Time stream: No. of years generated in the past | NUMC | 2 | 0 | TSTRSCOPBW | ||||||||||
| CALIDGEN | -- obsolete after 4.5A -- | CHAR | 2 | 0 | TSTRCALIDG | ||||||||||
| FBGEN | Time stream: FM for generating time segments | CHAR | 30 | 0 | TFDIR | TSTRFBGEN | |||||||||
| TBGEN | Table for applic.-specific data for generation (optional) | CHAR | 30 | 0 | DD02L | TSTRTBGEN | |||||||||
| FBDEL | Timestream: FM for checks (deletion) | CHAR | 30 | 0 | TSTRFBDEL | ||||||||||
| RUNTRELEAS | Release (development level) of the runtime objects | CHAR | 4 | 0 | TSTRSAPRL | ||||||||||
| FLAGEXTENT | Flag - time slots have extents | CHAR | 1 | 0 | TSTRFLEXT | ||||||||||
| CREATED | Time at which object was created | DEC | 15 | 0 | TSTRCREATS | ||||||||||
| CREATEDBY | User that created object | CHAR | 12 | 0 | USR02 | TSTRCREATN | |||||||||
| CHANGED | Time at which object was last changed | DEC | 15 | 0 | TSTRCHANGS | ||||||||||
| CHANGEDBY | Last user to change object | CHAR | 12 | 0 | USR02 | TSTRCHANGN | |||||||||
| GENERATE | Time stream: Time of last generation | DEC | 15 | 0 | TSTRGENERS | ||||||||||
| GENERATEBY | Time stream: User who generated object | CHAR | 12 | 0 | USR02 | TSTRGENERN |
TTSTR foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TTSTR | CHANGEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 1 TTSTR | CREATEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 0 TTSTR | FBGEN | TFDIR | Function Module | FUNCNAME |
| 1 TTSTR | GENERATEBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 0 TTSTR | TBGEN | DD02L | SAP Tables | TABNAME |
| 0 TTSTR | TBGEN | DD02L | SAP Tables | AS4LOCAL |
| 0 TTSTR | TBGEN | DD02L | SAP Tables | AS4VERS |
| 1 TTSTR | TZONE | TTZZ | Time zones | TZONE |