SAP table CTIMEDEF (Time definition)

SAP table CTIMEDEF has 2 primary key fields being MANDT,TIMDEF.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
TIMDEF Time Definition CHAR 10 0 TIMEDEF
TSTRID Time stream: External ID CHAR 10 0 TTSTR TSTRID
SCHGRUP Grouping for Shift Definitions and Shift Sequences CHAR 2 0 TC39A SCHGRUP
SPROG Key for the Shift Sequence CHAR 4 0 TC38A SCHPROG
FABKL Factory calendar key CHAR 2 0 TFACD FABKL
WERKS Plant CHAR 4 0 T001W WERKS_D
MRPPP PPC Planning Calendar CHAR 3 0 T439G MRPPP

CTIMEDEF foreign key relationships

Table Field Check Table Check Field
0 CTIMEDEF MRPPP T439G PP Planning periods: header table MANDT
0 CTIMEDEF MRPPP T439G PP Planning periods: header table WERKS
1 CTIMEDEF SCHGRUP TC39A Grouping shift definitions and shift sequences MANDT
1 CTIMEDEF SCHGRUP TC39A Grouping shift definitions and shift sequences SCHGRUP
0 CTIMEDEF SPROG TC38A Shift sequence MANDT
0 CTIMEDEF SPROG TC38A Shift sequence SPROG
0 CTIMEDEF SPROG TC38A Shift sequence SCHNR
1 CTIMEDEF TSTRID TTSTR Time stream: Administration table MANDT
1 CTIMEDEF TSTRID TTSTR Time stream: Administration table TSTRTYPE
1 CTIMEDEF TSTRID TTSTR Time stream: Administration table TSTREAMID
1 CTIMEDEF TSTRID TTSTR Time stream: Administration table CALENDARID
0 CTIMEDEF WERKS T001W Plants/Branches WERKS