1. Home
  2. Resources
  3. SAP Tables
  4. TCY58 - Time scale profile in planning table

SAP Table TCY58

Time scale profile in planning table

TCY58 (Time scale profile in planning table) 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 TCY58 to other SAP tables.

TCY58 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RIBPROF_ID Time scale profile RIB_PROF CHAR 10 0
MIN_YEAR Minimum width for a year MIN_YEAR DEC 10 2
MAX_YEAR Maximum width of a year MAX_YEAR DEC 10 2
MIN_QUART Minimum width for a quarter MIN_QUART DEC 10 2
MAX_QUART Maximum width for a quarter MAX_QUART DEC 10 2
MIN_MONTH Minimum width for a month MIN_MONTH DEC 10 2
MAX_MONTH Maximum width for a month MAX_MONTH DEC 10 2
MIN_WEEK Minimum width for a week MIN_WEEK DEC 10 2
MAX_WEEK Maximum width for a week MAX_WEEK DEC 10 2
MIN_DAY Minimum width for a day MIN_DAY DEC 10 2
MAX_DAY Maximum width of a day MAX_DAY DEC 10 2
MIN_HOUR Minimum width for a hour MIN_HOUR DEC 10 2
MAX_HOUR Maximum width for an hour MAX_HOUR DEC 10 2
MIN_MIN Minimum width for a minute MIN_MIN DEC 10 2
MAX_MIN Maximum with for a minute MAX_MIN DEC 10 2
CLR_YEAR Color for yearly period split CLR_YEAR CHAR 2 0
CLR_QUART Color for quarterly split CLR_QUART CHAR 2 0
CLR_MONTH Color for monthly period split CLR_MONTH CHAR 2 0
CLR_WEEK Color for calendar weekly period split CLR_WEEK CHAR 2 0
CLR_DAY Color for daily period split CLR_DAY CHAR 2 0
CLR_HOUR Color for hourly period split CLR_HOUR CHAR 2 0
CLR_MIN Color for minute period split CLR_MIN CHAR 2 0
MTIC_DAY Main division daily period split MTIC_DAY NUMC 3 0
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 MTIC_HOUR NUMC 3 0
001 Hourly - every day
025 Every day - every week
TTYP_MONTH Heading type month TTYP_MONTH NUMC 2 0
00 Name of the month: January, February, ..., December
01 Month & year in the form: Jan�96
TTYP_WEEK Heading type week TTYP_WEEK NUMC 2 0
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 TTYP_DAY NUMC 2 0
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 GRID_MODE CHAR 1 0
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 GCLR_YEAR CHAR 2 0
GCLR_QUART Color category of time fence for quarter period split GCLR_QUART CHAR 2 0
GCLR_MONTH Color category of time fence for monthly period split GCLR_MONTH CHAR 2 0
GCLR_WEEK Color category of time fence for weekly period split GCLR_WEEK CHAR 2 0
GCLR_DAY Color category of time fence for daily period split GCLR_DAY CHAR 2 0
GCLR_HOUR Color category of time fence for hourly period split GCLR_HOUR CHAR 2 0
GCLR_MIN Color category of time fence for minute period split GCLR_MIN CHAR 2 0
GTIC_YEAR Time fence spacing for yearly period split GTIC_YEAR INT4 10 0
GTIC_QUART Time fence spacing for quarterly period split GTIC_QUART INT4 10 0
GTIC_MONTH Time fence spacing for monthly period split GTIC_MONTH INT4 10 0
GTIC_WEEK Time fence spacing for weekly period split GTIC_WEEK INT4 10 0
GTIC_DAY Time fence spacing for daily period split GTIC_DAY INT4 10 0
GTIC_HOUR Time fence spacing for hourly period split GTIC_HOUR INT4 10 0
GTIC_MIN Time grid spacing for minute period split GTIC_MIN INT4 10 0
FORM_YEAR Form for yearly period split FORM_YEAR CHAR 2 0
FORM_QUART Form for quarterly period split FORM_QUART CHAR 2 0
FORM_WEEK Form for calendar week period split FORM_WEEK CHAR 2 0
FORM_DAY Form for period pattern FORM_DAY CHAR 2 0
FORM_HOUR Form for hourly period split FORM_HOUR CHAR 2 0
FORM_MIN Form for minute period split FORM_MIN CHAR 2 0
FORM_MONTH Form for monthly period split FORM_MONTH CHAR 2 0
OFFS_WEEK Start day of time fence for weekly period split OFFS_WEEK CHAR 1 0
NULL 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 CLR_SHIFT CHAR 2 0
FORM_SHIFT Form for period pattern FORM_SHIFT CHAR 2 0
GCLR_SHIFT Color cat.of time fence for period split GCLR_SHIFT CHAR 2 0
SHOW_SHIFT Indicator: Show shift calendar SHOW_SHIFT CHAR 1 0
X Yes
NULL No
GCLW_SHIFT Color cat.of time fence for period split GCLW_SHIFT CHAR 2 0
OFFS_YEAR Start month of time fence for yearly period split OFFS_YEAR CHAR 2 0
NULL 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 OFFS_QUART CHAR 1 0
NULL 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 OFFS_MONTH CHAR 2 0
NULL Planning section
01 Selectable days
10 Selectable days
20 Selectable days
30 Selectable days
OFFS_DAY Start time time fence for daily period split OFFS_DAY TIMS 6 0
OFFS_HOUR Start minute of time fence for hourly period split OFFS_HOUR CHAR 2 0
NULL Start time for planning section
60 Minutes
01 Minutes
10 Minutes
20 Minutes
30 Minutes
40 Minutes
50 Minutes
OFFS_MINUTE Start seconds for time fence for minute split OFFS_MINUTE CHAR 2 0
NULL Start time for planning section
60 Seconds
01 Seconds
10 Seconds
20 Seconds
30 Seconds
40 Seconds
50 Seconds

TCY58 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCY58 MANDT TCY58 MANDT T000 Clients MANDT