TTSTR (Time stream: Administration table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TTSTR to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
TSTRTYPE
Time stream: Type
|
TSTRTYPE |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
TSTREAMID
Time stream: External ID
|
TSTRID |
CHAR
|
10 | 0 | ||||||||||||
|
CALENDARID
Calendar ID
|
TSTRCALID | TFACD |
CHAR
|
2 | 0 | |||||||||||
|
RELID
Time stream: Area in IMPORT/EXPORT data table TSTRCOMP
|
TSTRRELID |
CHAR
|
2 | 0 | ||||||||||||
|
HANDLE
Time stream: Time stream handle
|
TSTRHANDLE |
CHAR
|
32 | 0 | ||||||||||||
|
BUFFEROPT
Time stream: Buffer option
|
TSTRBUFFOP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
CALCOPT
Time stream: Option for arith. operations
|
TSTRCALCOP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
GENOPT
Time stream: Generation options
|
TSTRGENOP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
FLAGCONTIN
Time stream: 'Without gaps' flag
|
TSTRCONTIN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
TZONE
Time Zone
|
TZNZONE | TTZZ |
CHAR
|
6 | 0 | |||||||||||
|
SCOPEGENFW
Time stream: No. of years generated in the future
|
TSTRSCOPFW |
NUMC
|
2 | 0 | ||||||||||||
|
SCOPEGENBW
Time stream: No. of years generated in the past
|
TSTRSCOPBW |
NUMC
|
2 | 0 | ||||||||||||
|
CALIDGEN
-- obsolete after 4.5A --
|
TSTRCALIDG |
CHAR
|
2 | 0 | ||||||||||||
|
FBGEN
Time stream: FM for generating time segments
|
TSTRFBGEN | TFDIR |
CHAR
|
30 | 0 | |||||||||||
|
TBGEN
Table for applic.-specific data for generation (optional)
|
TSTRTBGEN | DD02L |
CHAR
|
30 | 0 | |||||||||||
|
FBDEL
Timestream: FM for checks (deletion)
|
TSTRFBDEL |
CHAR
|
30 | 0 | ||||||||||||
|
RUNTRELEAS
Release (development level) of the runtime objects
|
TSTRSAPRL |
CHAR
|
4 | 0 | ||||||||||||
|
FLAGEXTENT
Flag - time slots have extents
|
TSTRFLEXT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
CREATED
Time at which object was created
|
TSTRCREATS |
DEC
|
15 | 0 | ||||||||||||
|
CREATEDBY
User that created object
|
TSTRCREATN | USR02 |
CHAR
|
12 | 0 | |||||||||||
|
CHANGED
Time at which object was last changed
|
TSTRCHANGS |
DEC
|
15 | 0 | ||||||||||||
|
CHANGEDBY
Last user to change object
|
TSTRCHANGN | USR02 |
CHAR
|
12 | 0 | |||||||||||
|
GENERATE
Time stream: Time of last generation
|
TSTRGENERS |
DEC
|
15 | 0 | ||||||||||||
|
GENERATEBY
Time stream: User who generated object
|
TSTRGENERN | USR02 |
CHAR
|
12 | 0 | |||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TTSTR | CALENDARID | TTSTR | CALENDARID |
TFACD
Factory calendar definition
|
IDENT |
| TTSTR | CHANGEDBY | SYST | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| TTSTR | CHANGEDBY | TTSTR | CHANGEDBY |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| TTSTR | CREATEDBY | TTSTR | CREATEDBY |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| TTSTR | CREATEDBY | SYST | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| TTSTR | FBGEN | TTSTR | FBGEN |
TFDIR
Function Module
|
FUNCNAME |
| TTSTR | GENERATEBY | TTSTR | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| TTSTR | GENERATEBY | TTSTR | GENERATEBY |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| TTSTR | MANDT | TTSTR | MANDT |
T000
Clients
|
MANDT |
| TTSTR | TBGEN | TTSTR | TBGEN |
DD02L
SAP Tables
|
TABNAME |
| TTSTR | TBGEN | 'A' |
DD02L
SAP Tables
|
AS4LOCAL | |
| TTSTR | TBGEN | * |
DD02L
SAP Tables
|
AS4VERS | |
| TTSTR | TZONE | TTSTR | MANDT |
TTZZ
Time zones
|
CLIENT |
| TTSTR | TZONE | TTSTR | TZONE |
TTZZ
Time zones
|
TZONE |