| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ID | User Interface Profile | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /MRSS/T_UI_PROFILE | Allow NULL? |
| 3 | PRF_GRUPPE | Profile group (sort graphics profiles) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBCG | BCPRFGROUP | Allow NULL? |
| 4 | PRF_NAME | Name of graphics profile | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | TBCG | BCPRFNAME | Allow NULL? |
| 5 | PRF_INDEX | Profile index for the graphics profile | char | 1 | 0 | CHAR | (N' ') | Yes | TBCG | BCPRFINDEX | Allow NULL? |
| 6 | VIEW_ID | View Profile ID | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /MRSS/T_SGU_VIEW_ID_PRO | Allow NULL? |
| 7 | ZOOM_LEVEL | Zoom Factor | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /MRSS/T_SGU_ZOOM_LEVEL | Allow NULL? |
| 8 | TICK_SIZE | Width of Area in Time Axis of Bar Chart | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /MRSS/T_SGU_TICKSIZE | Allow NULL? |
| 9 | TIME_COMPRESS | Compressed Display of Non-Working Times | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_TIME_COMPRESS | Allow NULL? |
| 10 | TICK_SIZE_COMPR | Width of a Compressed, Displayed Area | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /MRSS/T_SGU_SECTSIZE | Allow NULL? |
| 11 | DAILY_START | Daily Start of Working Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /MRSS/T_SGU_DAILY_START | Allow NULL? |
| 12 | DAILY_END | Daily End of Working Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /MRSS/T_SGU_DAILY_END | Allow NULL? |
| 13 | DEFAULT_MODE | Standard Mode for Planning Board | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_DEFAULT_MODE | Allow NULL? |
| 14 | FACTORY_CALENDAR | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | /MRSS/T_SGU_WFCID | Allow NULL? |
| 15 | SCALING_UNIT | Scaling unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SCALING_UNIT | Allow NULL? |
| 16 | ITEM_WORKL_MULT | Enable multi select of item worklist | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_WORKL_MULT | Allow NULL? |
| 17 | UTILTHRESH_DAY | Default utilization threshold | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /MRSS/T_DEF_UTIL_THRESHOLD | |
| 18 | UTILTHRESH_WEEK | Default utilization threshold per Week | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /MRSS/T_DEF_UTIL_THRESHOLD_W | |
| 19 | PERCENTAGE_LINE | Percentage Line for Planning Node Gantt | decimal | 3 | 0 | DEC | ((0)) | Yes | | /MRSS/T_SGU_GANTT_PER_LINE | |
| 20 | PN_VEW_TYPE | Planning Node Gantt View Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_PN_VIEW_TYPE | Allow NULL? |
| 21 | GRAPH_COLOR_FILL | Planning Node Gantt Color Fill | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_GRAPH_COLFILL | Allow NULL? |
| 22 | ROW_WIDTH | Planning Node Gantt Row Width | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_PN_LINE_WIDTH | Allow NULL? |
| 23 | ROW_WIDTH_ABS | Planning Node Gantt Row Width for ABS display | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_PN_LINE_WIDTH_ABS | Allow NULL? |
| 24 | FONT_SIZE | Planning Node Gantt Font Size | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_PN_FONT_SIZE | Allow NULL? |
| 25 | MAX_LIMIT | Maximum Graph limit for Y axis of Planning Node Gantt | decimal | 3 | 0 | DEC | ((0)) | Yes | | /MRSS/T_SGU_PN_MAX_LIMIT | |
| 26 | MAX_LIMIT_ABS | Maximum Graph limit for Y axis of Planning Node Gantt ABS | decimal | 3 | 0 | DEC | ((0)) | Yes | | /MRSS/T_SGU_PN_MAX_LIMIT_ABS | |
| 27 | MIN_LIMIT | Minimum Graph limit for Y axis of Planning Node Gantt | decimal | 3 | 0 | DEC | ((0)) | Yes | | /MRSS/T_SGU_PN_MIN_LIMIT | |
| 28 | MIN_LIMIT_ABS | Minimum Graph limit for Y axis of Planning Node Gantt ABS | decimal | 3 | 0 | DEC | ((0)) | Yes | | /MRSS/T_SGU_PN_MIN_LIMIT_ABS | |
| 29 | PN_GRAPH_TYPE | Planning Node Gantt Graph Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_PN_GRAPH_TYPE | Allow NULL? |
| 30 | RESTR_START_TYPE | Demand Start Restriction | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_RESTRICT_START | Allow NULL? |
| 31 | RESTR_END_TYPE | Demand End Restriction | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_RESTRICT_END | Allow NULL? |
| 32 | USE_WL_MENU | Use Enhanced context menu for Demand Gantt | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_USE_WL_MENU | Allow NULL? |
| 33 | ABS_AVAIL_DISP | Display Absolute Availability | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_ABS_AVAIL_DISPLAY | Allow NULL? |
| 34 | RES_IN_DISPGANTT | Display Resources in Dispatching Gantt | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_GANTT_DISP_RES | Allow NULL? |
| 35 | SET_DISPATCH | Set Dispatch Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_DISPATCHED_STAT | Allow NULL? |
| 36 | JUMP_TO_DATE | Set Plb Start Date | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_JUMP_BEGIN_SET | Allow NULL? |
| 37 | JUMP_START_SIGN | Sign for Gantt Start Date | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_JUMP_BEGIN_SIGN | Allow NULL? |
| 38 | JUMP_START_DATE | Jump to Current Date | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /MRSS/T_SGU_JUMP_BEGIN | Allow NULL? |
| 39 | DAY_WISE_CG | Hide Non-Working Times | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_DAY_WISE_PLAN | Allow NULL? |
| 40 | CAP_IN_PLANLINE | Show Capacitive Assignments in Planning Row | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_CAP_ASG_IN_PLAN | Allow NULL? |
| 41 | CREATE_ASG_DAYB | Create New Assignments Day-Based | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_CREATE_ASG_DAYB | Allow NULL? |
| 42 | OPTIMIZER_PRVENT | Hide Optimization Icon in Planning Board | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_OPTIMIZER_PREVENT | Allow NULL? |
| 43 | SUMBAR_DISPLAY | Display of Sumbar | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_SUMBAR_DISPLAY | Allow NULL? |
| 44 | MAXIMIZE_GANTT | Maximize gantt on Big Screen | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_BIG_SCREEN_GANTT | Allow NULL? |
| 45 | VIEW_ASSIGNMENT | Display Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_ASSIGNMENT | Allow NULL? |
| 46 | VIEW_TIMESPEC | Display Time Allocation | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_TIMESPEC | Allow NULL? |
| 47 | VIEW_TEAM | Display Teams | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_TEAM | Allow NULL? |
| 48 | HIDE_ASG_FOL_DEM | Hide Assignment follows demand checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_HIDE_ASG_FOL_DEM | Allow NULL? |
| 49 | HIDE_TEAM_MEM | Display Team Name Only | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_HIDE_LITERAL_TEAM_MEM | Allow NULL? |
| 50 | ASG_AT_DROP_TIME | Create Assignment for the Time Slot onto Which It Is Dropped | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_ASG_ON_DROP_TIME | Allow NULL? |
| 51 | NUM_PROPOSAL | Number of Proposed Slots for Shifting Demands | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /MRSS/T_SGU_NUM_PROPOSAL | Allow NULL? |
| 52 | SHOW_AVAIL_VIEW | Show Availability View Button in Planning Board | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_SHOW_AVAIL_VIEW | Allow NULL? |
| 53 | AVAIL_VIEW_DEFAU | Set Availability View as Default | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_AVAIL_VIEW_DEFAULT | Allow NULL? |
| 54 | SHOW_ASSOC_RES | Show Resources | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_SHOW_ASSOC_RES | Allow NULL? |
| 55 | SHOW_ASSOC_DEM | Show Demands | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_SHOW_ASSOC_DEM | Allow NULL? |
| 56 | SHOW_ASC_DEM_MGR | Show Demands in Manager Planning Board | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_SHOW_ASSOC_DEM_MGR | Allow NULL? |
| 57 | SHIFT_TIMEZONE | Activate Alternative Time Zone | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_SHIFTTMZN | Allow NULL? |
| 58 | CONSIDER_NON_GAN | Consider Order and Item Worklists for Status Buttons | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_NON_GANTT_PUSH_BTN | Allow NULL? |
| 59 | RET_ONLY_ERR_MSG | Suppress Information and Warning Messages in Planning Board | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RETURN_ONLY_ERROR_MSG | Allow NULL? |
