SAP table reference
TTSTRSD
Working Times in SD/WSExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TTSTRSD.
SAP table TTSTRSD has 4 primary key fields: MANDT,TSTRTYPE,TSTREAMID,CALENDARID.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
TTSTRSD fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| Key TSTRTYPE | Time stream: Type | CHAR | 2 | 0 | TSTRTYPE | ||||||||||
| |||||||||||||||
| Key TSTREAMID | Working time from sales view | CHAR | 10 | 0 | TSTRIDSD | ||||||||||
| Key CALENDARID | Calendar ID | CHAR | 2 | 0 | TTSTR | TSTRCALID | |||||||||
| SHIFTPROG | Shift sequence | CHAR | 4 | 0 | TC38A | TSTRSHIFTP | |||||||||
| 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
TTSTRSD relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| TTSTRSD | CALENDARID | TTSTR | Time stream: Administration table | MANDT |
| TTSTRSD | CALENDARID | TTSTR | Time stream: Administration table | TSTRTYPE |
| TTSTRSD | CALENDARID | TTSTR | Time stream: Administration table | TSTREAMID |
| TTSTRSD | CALENDARID | TTSTR | Time stream: Administration table | CALENDARID |
| TTSTRSD | CHANGEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TTSTRSD | CREATEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TTSTRSD | GENERATEBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TTSTRSD | SHIFTPROG | TC38A | Shift sequence | MANDT |
| TTSTRSD | SHIFTPROG | TC38A | Shift sequence | SPROG |
| TTSTRSD | SHIFTPROG | TC38A | Shift sequence | SCHNR |