SAP Table TTSTRSD
Working Times in SD/WS
TTSTRSD (Working Times in SD/WS) 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 TTSTRSD to other SAP tables.
TTSTRSD table fields
| 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
Working time from sales view
|
TSTRIDSD |
CHAR
|
10 | 0 | ||||||||||||
|
CALENDARID
Calendar ID
|
TSTRCALID | TTSTR |
CHAR
|
2 | 0 | |||||||||||
|
SHIFTPROG
Shift sequence
|
TSTRSHIFTP | TC38A |
CHAR
|
4 | 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 | |||||||||||
TTSTRSD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TTSTRSD | CALENDARID | TTSTRSD | TSTRTYPE |
TTSTR
Time stream: Administration table
|
TSTRTYPE |
| TTSTRSD | CALENDARID | TTSTRSD | TSTREAMID |
TTSTR
Time stream: Administration table
|
TSTREAMID |
| TTSTRSD | CALENDARID | TTSTRSD | CALENDARID |
TTSTR
Time stream: Administration table
|
CALENDARID |
| TTSTRSD | CALENDARID | TTSTRSD | MANDT |
TTSTR
Time stream: Administration table
|
MANDT |
| TTSTRSD | CHANGEDBY | SYST | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| TTSTRSD | CHANGEDBY | TTSTRSD | CHANGEDBY |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| TTSTRSD | CREATEDBY | SYST | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| TTSTRSD | CREATEDBY | TTSTRSD | CREATEDBY |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| TTSTRSD | GENERATEBY | TTSTRSD | MANDT |
USR02
Logon Data (Kernel-Side Use)
|
MANDT |
| TTSTRSD | GENERATEBY | TTSTRSD | GENERATEBY |
USR02
Logon Data (Kernel-Side Use)
|
BNAME |
| TTSTRSD | MANDT | TTSTRSD | MANDT |
T000
Clients
|
MANDT |
| TTSTRSD | SHIFTPROG | TTSTRSD | MANDT |
TC38A
Shift sequence
|
MANDT |
| TTSTRSD | SHIFTPROG | 'SD' |
TC38A
Shift sequence
|
SCHGRUP | |
| TTSTRSD | SHIFTPROG | TTSTRSD | SHIFTPROG |
TC38A
Shift sequence
|
SPROG |
| TTSTRSD | SHIFTPROG | * |
TC38A
Shift sequence
|
SCHNR |