SAP Table
TTSTR Time stream: Administration table
SAP table TTSTR has 4 primary key fields being MANDT,TSTRTYPE,TSTREAMID,CALENDARID.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TTSTR columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyTSTRTYPE | Time stream: Type | CHAR | 2 | 0 | TSTRTYPE | ||||||||||
|
|||||||||||||||
| KeyTSTREAMID | Time stream: External ID | CHAR | 10 | 0 | TSTRID | ||||||||||
| KeyCALENDARID | 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 | |||||||||
/ Relationships
TTSTR foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TTSTR | CHANGEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TTSTR | CREATEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TTSTR | FBGEN | TFDIR | Function Module | FUNCNAME |
| TTSTR | GENERATEBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TTSTR | TBGEN | DD02L | SAP Tables | TABNAME |
| TTSTR | TBGEN | DD02L | SAP Tables | AS4LOCAL |
| TTSTR | TBGEN | DD02L | SAP Tables | AS4VERS |
| TTSTR | TZONE | TTZZ | Time zones | TZONE |