SAP Table CTIMEDEF
Time definition
CTIMEDEF (Time definition) 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 CTIMEDEF to other SAP tables.
CTIMEDEF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| TIMDEF | Time definition | TIMEDEF | CHAR | 10 | 0 | |||
| TSTRID | Time stream: External ID | TSTRID | TTSTR | CHAR | 10 | 0 | ||
| SCHGRUP | Grouping for Shift Definitions and Shift Sequences | SCHGRUP | TC39A | CHAR | 2 | 0 | ||
| SPROG | Key for the shift sequence | SCHPROG | TC38A | CHAR | 4 | 0 | ||
| FABKL | Factory calendar key | FABKL | TFACD | CHAR | 2 | 0 | ||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| MRPPP | PPC planning calendar | MRPPP | T439G | CHAR | 3 | 0 | ||
CTIMEDEF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CTIMEDEF | FABKL | CTIMEDEF | FABKL | TFACD | Factory calendar definition | IDENT |
| CTIMEDEF | MRPPP | CTIMEDEF | MRPPP | T439G | PPplanning periods: header table | MRPPP |
| CTIMEDEF | MRPPP | CTIMEDEF | MANDT | T439G | PPplanning periods: header table | MANDT |
| CTIMEDEF | MRPPP | CTIMEDEF | WERKS | T439G | PPplanning periods: header table | WERKS |
| CTIMEDEF | SCHGRUP | CTIMEDEF | SCHGRUP | TC39A | Grouping shift definitions and shift sequences | SCHGRUP |
| CTIMEDEF | SCHGRUP | CTIMEDEF | MANDT | TC39A | Grouping shift definitions and shift sequences | MANDT |
| CTIMEDEF | SPROG | CTIMEDEF | MANDT | TC38A | Shift sequence | MANDT |
| CTIMEDEF | SPROG | CTIMEDEF | SCHGRUP | TC38A | Shift sequence | SCHGRUP |
| CTIMEDEF | SPROG | CTIMEDEF | SPROG | TC38A | Shift sequence | SPROG |
| CTIMEDEF | SPROG | * | TC38A | Shift sequence | SCHNR | |
| CTIMEDEF | TSTRID | CTIMEDEF | FABKL | TTSTR | Time stream: Administration table | CALENDARID |
| CTIMEDEF | TSTRID | CTIMEDEF | MANDT | TTSTR | Time stream: Administration table | MANDT |
| CTIMEDEF | TSTRID | 'TS' | TTSTR | Time stream: Administration table | TSTRTYPE | |
| CTIMEDEF | TSTRID | CTIMEDEF | TSTRID | TTSTR | Time stream: Administration table | TSTREAMID |
| CTIMEDEF | WERKS | CTIMEDEF | MANDT | T001W | Plants/Branches | MANDT |
| CTIMEDEF | WERKS | CTIMEDEF | WERKS | T001W | Plants/Branches | WERKS |
