| 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 | VIEW_ID | View Profile ID | nvarchar | 3 | 0 | NUMC | (N'000') | No | | /MRSS/T_SGU_VIEW_ID | Allow NULL? |
| 4 | ASSIGNMENT | Display Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_ASSIGNMENT | Allow NULL? |
| 5 | TIMESPEC | Display Time Allocation | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_TIMESPEC | Allow NULL? |
| 6 | LINK | Display Links | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_LINK | Allow NULL? |
| 7 | TEAM | Display Teams | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_TEAM | Allow NULL? |
| 8 | CLOCK_INF | Display Time Data | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_CLOCK_INF | Allow NULL? |
| 9 | SUMBARS | Display Sumbars in the Planning board | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_SUMBARS | Allow NULL? |
| 10 | COLLISIONS | Display Collisions in the Planning Board | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_COLLISIONS | Allow NULL? |
| 11 | DATELINE | Display Time-Now line | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_TIME_NOW | Allow NULL? |
| 12 | ABSOLUTE_AVAIL | Display Absolute Availability | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_ABS_AVAIL | Allow NULL? |
| 13 | RELATIVE_AVAIL | Display Relative Utilization | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_REL_AVAIL | Allow NULL? |
| 14 | RESOURCE_NOTE | Note for Resource | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RES_NOTE_FLG | Allow NULL? |
| 15 | CAP_ASG_NUM | Number of Capacitive Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_CAP_ASG_NUM | Allow NULL? |
| 16 | PROJECT | Display Projects | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_PROJECT | Allow NULL? |
| 17 | WBS | Display Work Breakdown Structure | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_WBS | Allow NULL? |
| 18 | ASSIGNMENT_DEM | Display Assignments in Demand View | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_ASGN_DEM_VIEW | Allow NULL? |
| 19 | SHOW_STD_DEM_COL | Display Standard Demand Gantt columns | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_STD_DEM_COLS | Allow NULL? |
| 20 | ALL_DEMANDS_DISP | Dispatch all demands in Dispatching View | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_ALL_DEM_DISPA | Allow NULL? |
| 21 | COLLISIONS_DEM | Display Collisions in the Planning Board | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_VIEW_COLLISIONS | Allow NULL? |