/MRSS/C_SGU_PRO SAP table for – UI Planning Profiles

Here we would like to draw your attention to /MRSS/C_SGU_PRO table in SAP. As we know it is being mainly used with the SAP PM-WOC (Maintenance Processing in PM) component which is coming under PM module (Plant Maintenance). /MRSS/C_SGU_PRO is a SAP standard transparent table used for storing UI Planning Profiles related data in SAP. It comes under the package /MRSS/SGU.

SAP /MRSS/C_SGU_PRO table

Table /MRSS/C_SGU_PRO technical data

Table/MRSS/C_SGU_PRO
Data storingUI Planning Profiles
ModulePM
ComponentPM-WOC
SAP Package/MRSS/SGU
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP /MRSS/C_SGU_PRO Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /MRSS/C_SGU_PRO table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • TIME_COMPRESS
    Its data type is C (Character String) with field length 2
  • TICK_SIZE_COMPR
    Its data type is N (Character String with Digits Only) with field length 8
  • DAILY_START
    Its data type is T (Time (Time: HHMMSS)) with field length 12
  • DAILY_END
    Its data type is T (Time (Time: HHMMSS)) with field length 12
  • DEFAULT_MODE
    Its data type is C (Character String) with field length 8
  • FACTORY_CALENDAR
    Its data type is C (Character String) with field length 4
  • SCALING_UNIT
    Its data type is C (Character String) with field length 20
  • ITEM_WORKL_MULT
    Its data type is C (Character String) with field length 2
  • UTILTHRESH_DAY
    Its data type is X (Byte string) with field length 1
  • UTILTHRESH_WEEK
    Its data type is X (Byte string) with field length 1
  • ID : Demo hierarchy: Node ID
    Its a key field. Its data type is C (Character String) with field length 20
  • PERCENTAGE_LINE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • PN_VEW_TYPE
    Its data type is C (Character String) with field length 2
  • GRAPH_COLOR_FILL
    Its data type is C (Character String) with field length 2
  • ROW_WIDTH
    Its data type is C (Character String) with field length 4
  • ROW_WIDTH_ABS
    Its data type is C (Character String) with field length 6
  • FONT_SIZE
    Its data type is C (Character String) with field length 4
  • MAX_LIMIT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MAX_LIMIT_ABS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MIN_LIMIT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MIN_LIMIT_ABS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is BCPROFILE
  • PN_GRAPH_TYPE
    Its data type is C (Character String) with field length 2
  • RESTR_START_TYPE
    Its data type is C (Character String) with field length 2
  • RESTR_END_TYPE
    Its data type is C (Character String) with field length 2
  • USE_WL_MENU
    Its data type is C (Character String) with field length 2
  • ABS_AVAIL_DISP
    Its data type is C (Character String) with field length 2
  • RES_IN_DISPGANTT
    Its data type is C (Character String) with field length 2
  • SET_DISPATCH
    Its data type is C (Character String) with field length 2
  • JUMP_TO_DATE
    Its data type is C (Character String) with field length 2
  • JUMP_START_SIGN
    Its data type is C (Character String) with field length 2
  • JUMP_START_DATE
    Its data type is N (Character String with Digits Only) with field length 6
  • PRF_GRUPPE
    Its data type is C (Character String) with field length 8
  • DAY_WISE_CG
    Its data type is C (Character String) with field length 2
  • CAP_IN_PLANLINE
    Its data type is C (Character String) with field length 2
  • CREATE_ASG_DAYB
    Its data type is C (Character String) with field length 2
  • OPTIMIZER_PRVENT
    Its data type is C (Character String) with field length 2
  • SUMBAR_DISPLAY
    Its data type is C (Character String) with field length 20
  • MAXIMIZE_GANTT
    Its data type is C (Character String) with field length 2
  • VIEW_ASSIGNMENT
    Its data type is C (Character String) with field length 2
  • VIEW_TIMESPEC
    Its data type is C (Character String) with field length 2
  • VIEW_TEAM
    Its data type is C (Character String) with field length 2
  • HIDE_ASG_FOL_DEM
    Its data type is C (Character String) with field length 2
  • PRF_NAME
    Its data type is C (Character String) with field length 24
  • HIDE_TEAM_MEM
    Its data type is C (Character String) with field length 2
  • ASG_AT_DROP_TIME
    Its data type is C (Character String) with field length 2
  • NUM_PROPOSAL
    Its data type is N (Character String with Digits Only) with field length 4
  • SHOW_AVAIL_VIEW
    Its data type is C (Character String) with field length 2
  • AVAIL_VIEW_DEFAU
    Its data type is C (Character String) with field length 2
  • SHOW_ASSOC_RES
    Its data type is C (Character String) with field length 2
  • SHOW_ASSOC_DEM
    Its data type is C (Character String) with field length 2
  • SHOW_ASC_DEM_MGR
    Its data type is C (Character String) with field length 2
  • SHIFT_TIMEZONE
    Its data type is C (Character String) with field length 2
  • CONSIDER_NON_GAN
    Its data type is C (Character String) with field length 2
  • PRF_INDEX
    Its data type is C (Character String) with field length 2
  • RET_ONLY_ERR_MSG
    Its data type is C (Character String) with field length 2
  • VIEW_ID
    Its data type is N (Character String with Digits Only) with field length 6
  • ZOOM_LEVEL
    Its data type is N (Character String with Digits Only) with field length 6
  • TICK_SIZE
    Its data type is N (Character String with Digits Only) with field length 8