SAP-tabelreferentie
TTSTRSD
Working Times in SD/WSBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel TTSTRSD.
SAP-tabel TTSTRSD heeft 4 primaire sleutelvelden: MANDT,TSTRTYPE,TSTREAMID,CALENDARID.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
TTSTRSD velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| Sleutel TSTRTYPE | Time stream: Type | CHAR | 2 | 0 | TSTRTYPE | ||||||||||
| |||||||||||||||
| Sleutel TSTREAMID | Working time from sales view | CHAR | 10 | 0 | TSTRIDSD | ||||||||||
| Sleutel 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 | |||||||||
/ Relaties
TTSTRSD relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |