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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| TSTRTYPE | Time stream: Type | TSTRTYPE | CHAR | 2 | 0 |
Possible values
|
||||||||||
| 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 | MANDT | TTSTR | Time stream: Administration table | MANDT |
| 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 | CHANGEDBY | TTSTRSD | CHANGEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TTSTRSD | CHANGEDBY | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| 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 | * | TC38A | Shift sequence | SCHNR | |
| TTSTRSD | SHIFTPROG | TTSTRSD | MANDT | TC38A | Shift sequence | MANDT |
| TTSTRSD | SHIFTPROG | 'SD' | TC38A | Shift sequence | SCHGRUP | |
| TTSTRSD | SHIFTPROG | TTSTRSD | SHIFTPROG | TC38A | Shift sequence | SPROG |
