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 | Possible values |
|---|---|---|---|---|---|---|
|
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 | MANDT |
T439G
PPplanning periods: header table
|
MANDT |
| CTIMEDEF | MRPPP | CTIMEDEF | WERKS |
T439G
PPplanning periods: header table
|
WERKS |
| CTIMEDEF | MRPPP | CTIMEDEF | MRPPP |
T439G
PPplanning periods: header table
|
MRPPP |
| CTIMEDEF | SCHGRUP | CTIMEDEF | MANDT |
TC39A
Grouping shift definitions and shift sequences
|
MANDT |
| CTIMEDEF | SCHGRUP | CTIMEDEF | SCHGRUP |
TC39A
Grouping shift definitions and shift sequences
|
SCHGRUP |
| CTIMEDEF | SPROG | CTIMEDEF | SCHGRUP |
TC38A
Shift sequence
|
SCHGRUP |
| CTIMEDEF | SPROG | CTIMEDEF | SPROG |
TC38A
Shift sequence
|
SPROG |
| CTIMEDEF | SPROG | * |
TC38A
Shift sequence
|
SCHNR | |
| CTIMEDEF | SPROG | CTIMEDEF | MANDT |
TC38A
Shift sequence
|
MANDT |
| 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 | TSTRID | CTIMEDEF | FABKL |
TTSTR
Time stream: Administration table
|
CALENDARID |
| CTIMEDEF | WERKS | CTIMEDEF | MANDT |
T001W
Plants/Branches
|
MANDT |
| CTIMEDEF | WERKS | CTIMEDEF | WERKS |
T001W
Plants/Branches
|
WERKS |