SAP table TCY58 (Time scale profile in planning table)

SAP table TCY58 has 2 primary key fields being MANDT,RIBPROF_ID.

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
RIBPROF_ID Time scale profile CHAR 10 0 RIB_PROF
MIN_YEAR Minimum width for a year DEC 10 2 MIN_YEAR
MAX_YEAR Maximum width of a year DEC 10 2 MAX_YEAR
MIN_QUART Minimum width for a quarter DEC 10 2 MIN_QUART
MAX_QUART Maximum width for a quarter DEC 10 2 MAX_QUART
MIN_MONTH Minimum width for a month DEC 10 2 MIN_MONTH
MAX_MONTH Maximum width for a month DEC 10 2 MAX_MONTH
MIN_WEEK Minimum width for a week DEC 10 2 MIN_WEEK
MAX_WEEK Maximum width for a week DEC 10 2 MAX_WEEK
MIN_DAY Minimum width for a day DEC 10 2 MIN_DAY
MAX_DAY Maximum width of a day DEC 10 2 MAX_DAY
MIN_HOUR Minimum width for a hour DEC 10 2 MIN_HOUR
MAX_HOUR Maximum width for an hour DEC 10 2 MAX_HOUR
MIN_MIN Minimum width for a minute DEC 10 2 MIN_MIN
MAX_MIN Maximum with for a minute DEC 10 2 MAX_MIN
CLR_YEAR Color for yearly period split CHAR 2 0 CLR_YEAR
CLR_QUART Color for quarterly split CHAR 2 0 CLR_QUART
CLR_MONTH Color for monthly period split CHAR 2 0 CLR_MONTH
CLR_WEEK Color for calendar weekly period split CHAR 2 0 CLR_WEEK
CLR_DAY Color for daily period split CHAR 2 0 CLR_DAY
CLR_HOUR Color for hourly period split CHAR 2 0 CLR_HOUR
CLR_MIN Color for minute period split CHAR 2 0 CLR_MIN
MTIC_DAY Main division daily period split NUMC 3 0 MTIC_DAY
001 Daily - every week
008 Every week - every month
032 Every month - every quarter
123 Every quarter - every year
MTIC_HOUR Main division hourly period split NUMC 3 0 MTIC_HOUR
001 Hourly - every day
025 Every day - every week
TTYP_MONTH Heading type month NUMC 2 0 TTYP_MONTH
00 Name of the month: January, February, ..., December
01 Month & year in the form: Jan´96
TTYP_WEEK Heading type week NUMC 2 0 TTYP_WEEK
00 Week number as integer: 1, 2, 3, 4, ..., 52, 53
01 Calendar week: CW 1, CW 2, CW 3, ..., CW 52, CW 53
TTYP_DAY Heading type day NUMC 2 0 TTYP_DAY
00 Number of the day in the month: 1, 2, 3, 4,...12
01 First letter of the day of the week, e.g. F (Friday)
02 Day of the week according to user parameters
03 Day written out completely
GRID_MODE Time fence mode CHAR 1 0 GRID_MODE
0 No time grid
1 Finest scale defines the time fence
2 Roughest scale defines the time fence
3 All scales define the time fence
GCLR_YEAR Color category of time fence for yearly period split CHAR 2 0 GCLR_YEAR
GCLR_QUART Color category of time fence for quarter period split CHAR 2 0 GCLR_QUART
GCLR_MONTH Color category of time fence for monthly period split CHAR 2 0 GCLR_MONTH
GCLR_WEEK Color category of time fence for weekly period split CHAR 2 0 GCLR_WEEK
GCLR_DAY Color category of time fence for daily period split CHAR 2 0 GCLR_DAY
GCLR_HOUR Color category of time fence for hourly period split CHAR 2 0 GCLR_HOUR
GCLR_MIN Color category of time fence for minute period split CHAR 2 0 GCLR_MIN
GTIC_YEAR Time fence spacing for yearly period split INT4 10 0 GTIC_YEAR
GTIC_QUART Time fence spacing for quarterly period split INT4 10 0 GTIC_QUART
GTIC_MONTH Time fence spacing for monthly period split INT4 10 0 GTIC_MONTH
GTIC_WEEK Time fence spacing for weekly period split INT4 10 0 GTIC_WEEK
GTIC_DAY Time fence spacing for daily period split INT4 10 0 GTIC_DAY
GTIC_HOUR Time fence spacing for hourly period split INT4 10 0 GTIC_HOUR
GTIC_MIN Time grid spacing for minute period split INT4 10 0 GTIC_MIN
FORM_YEAR Form for yearly period split CHAR 2 0 FORM_YEAR
FORM_QUART Form for quarterly period split CHAR 2 0 FORM_QUART
FORM_WEEK Form for calendar week period split CHAR 2 0 FORM_WEEK
FORM_DAY Form for period pattern CHAR 2 0 FORM_DAY
FORM_HOUR Form for hourly period split CHAR 2 0 FORM_HOUR
FORM_MIN Form for minute period split CHAR 2 0 FORM_MIN
FORM_MONTH Form for monthly period split CHAR 2 0 FORM_MONTH
OFFS_WEEK Start day of time fence for weekly period split CHAR 1 0 OFFS_WEEK
First day of planning section
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday
7 Sunday
CLR_SHIFT Color for period split CHAR 2 0 CLR_SHIFT
FORM_SHIFT Form for period pattern CHAR 2 0 FORM_SHIFT
GCLR_SHIFT Color cat.of time fence for period split CHAR 2 0 GCLR_SHIFT
SHOW_SHIFT Indicator: Show shift calendar CHAR 1 0 SHOW_SHIFT
GCLW_SHIFT Color cat.of time fence for period split CHAR 2 0 GCLW_SHIFT
OFFS_YEAR Start month of time fence for yearly period split CHAR 2 0 OFFS_YEAR
Month of planning section
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
OFFS_QUART Start quarter for time fence for quarterly split CHAR 1 0 OFFS_QUART
Quarter of planning section
1 Quarter 1 (January - March)
2 Quarter 2 (April - June)
3 Quarter 3 (July - September)
4 Quarter 4 (October - December)
OFFS_MONTH Start day for time fence for monthly period split CHAR 2 0 OFFS_MONTH
Planning section
01 Selectable days
10 Selectable days
20 Selectable days
30 Selectable days
OFFS_DAY Start time time fence for daily period split TIMS 6 0 OFFS_DAY
OFFS_HOUR Start minute of time fence for hourly period split CHAR 2 0 OFFS_HOUR
Start time for planning section
01 Minutes
10 Minutes
20 Minutes
30 Minutes
40 Minutes
50 Minutes
60 Minutes
OFFS_MINUTE Start seconds for time fence for minute split CHAR 2 0 OFFS_MINUTE
Start time for planning section
01 Seconds
10 Seconds
20 Seconds
30 Seconds
40 Seconds
50 Seconds
60 Seconds