SAP table TCTH (Settings for hierarchy graphic (schedule maint.))
SAP table TCTH has 2 primary key fields being MANDT,PROFILE.
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
T000
MANDT
PROFILE
Profile for the hierarchy graphic in time scheduling
CHAR
12
0
THPROFILE
VRG_DARST
Activity display in the graphic
CHAR
1
0
ACT_DARST
Possible values
0
Display with expanded nodes
1
Display with large nodes
2
Display with medium nodes
3
Display with small nodes
PSP_DARST
Display options for WBS element in the graphic
CHAR
1
0
PSP_DARST
Possible values
0
Display with expanded node
1
Display with large node
2
Display with medium node
3
Display with small node
DISPACT
Display activities in the hierarchy graphic in the Info syst
CHAR
1
0
PS_H_ACT
COLKZ_VORG
Color for indicator: Activities exist
CHAR
11
0
TWCOL
COLKZ_VORG
COLKZ_AUFT
Color for indicator: Order exists
CHAR
11
0
TWCOL
COLKZ_AUFT
COLKZ_MLST
Color for indicator: Milestone exists
CHAR
11
0
TWCOL
COLKZ_MLST
COLKZ_DOKU
Color for indicator: Document exists
CHAR
11
0
TWCOL
COLKZ_DOKU
COLKZ_ELEM
Color for indicator: Activity element exists
CHAR
11
0
TWCOL
COLKZ_ELEM
COLKZ_TEIL
Color for indicator: Subnetwork exists
CHAR
11
0
TWCOL
COLKZ_TEIL
COLKZ_MAT
Color for indicator: Material exists
CHAR
11
0
TWCOL
COLKZ_MAT
TCTH foreign key relationships
Table
Field
Check Table
Check Field
0 TCTH
COLKZ_AUFT
TWCOL
Possible colors (W lib)
MANDT
1 TCTH
COLKZ_DOKU
TWCOL
Possible colors (W lib)
MANDT
0 TCTH
COLKZ_ELEM
TWCOL
Possible colors (W lib)
MANDT
1 TCTH
COLKZ_MAT
TWCOL
Possible colors (W lib)
MANDT
0 TCTH
COLKZ_MLST
TWCOL
Possible colors (W lib)
MANDT
1 TCTH
COLKZ_TEIL
TWCOL
Possible colors (W lib)
MANDT
0 TCTH
COLKZ_VORG
TWCOL
Possible colors (W lib)
MANDT