SAP ABAP Table /MRSS/V_SGE_PR_R (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /MRSS/V_SGE_PR_R   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client  
2 PROFILE /MRSS/T_SGE_PROFILE   CHAR 10   0   Planning Board Profile  
3 TEXT /MRSS/T_SGE_PROFILE_TEXT TEXT30 CHAR 30   0   Description of Scheduling Engine Profile  
4 RES_LOCK /MRSS/T_RES_LOCK /MRSS/_BOOLEAN CHAR 1   0   Lock Active at Resource Level  
5 ORD_LOCK /MRSS/T_ORD_LOCK /MRSS/_BOOLEAN CHAR 1   0   Lock Active at Order Level  
6 TMZ /MRSS/T_SGE_TIMEZONE TZNZONE CHAR 6   0   Time Zone for Planning Board TTZZ
7 SPLT_MIN_DUR /MRSS/T_SPLT_MIN_DUR /MRSS/_SPLT_MIN_DUR DEC 5   1   Minimum Duration of an Assignment for Split  
8 SPLT_MIN_DUR_UN /MRSS/T_SPLT_MIN_DUR_UNIT /MRSS/_TIME_UNIT CHAR 3   0   Unit for Minimum Duration of an Assignment for Split  
9 OVRTM_MAX /MRSS/T_OVRTM_MAX /MRSS/_OVRTM_MAX DEC 5   1   Split: Maximum Overtime Hours  
10 OVRTM_MAX_UNIT /MRSS/T_OVRTM_MAX_UNIT /MRSS/_TIME_UNIT CHAR 3   0   Time Unit for Maximum Overtime Hours  
11 OVRTM_MAX_RATIO /MRSS/T_OVRTM_MAX_RATIO /MRSS/_OVRTM_MAX_RATIO INT1 3   0   Split: Maximum Ratio of Overtime Hours to Total Time  
12 SPLT_MAX_GAP /MRSS/T_SPLT_MAX_GAP /MRSS/_SPLT_MAX_GAP DEC 5   1   Maximum Difference Between Two Assignments When Split  
13 SPLT_MAX_GAP_UN /MRSS/T_SPLT_MAX_GAP_UNIT /MRSS/_TIME_UNIT CHAR 3   0   Unit for Maximum Difference Between Assignments When Split  
14 CHECK_PROFILE /MRSS/T_CHECK_PROFILE   CHAR 10   0   Profile for Checks in the Planning Board /MRSS/C_CHECK_P
15 ALERT_PROFILE /MRSS/T_ALERT_PROFILE   CHAR 10   0   Scheduling alert profiles /MRSS/C_AL_PROF
16 WL_PROFILE /MRSS/T_WL_PROFILE   CHAR 10   0   Worklist Profile /MRSS/C_WL_PR
17 UI_PROFILE /MRSS/T_UI_PROFILE /MRSS/_SGU_UI_PROFILE CHAR 10   0   User Interface Profile /MRSS/C_SGU_PRO
18 MIN_ASS_DUR /MRSS/T_MIN_ASS_DUR   NUMC 3   0   Minimum Duration of an Assignment (in Minutes)  
19 TIME_GRAN /MRSS/T_TIME_GRAN /MRSS/_TIME_GRAN NUMC 2   0   Time Granularity in Resource Planning  
20 REFRESH_PERIOD /MRSS/T_CLOCK_REFRESH /MRSS/_CLOCK_REFRESH DEC 3   0   Period for Refreshing Time Recording Information  
21 ACTIVE_CLOCK /MRSS/T_ACTIVE_CLOCK /MRSS/_BOOLEAN CHAR 1   0   Time Recording Is Active  
22 ACTIVE_TEAM /MRSS/T_ACTIVE_TEAM /MRSS/_BOOLEAN CHAR 1   0   Planning Board Teams Are Supported  
23 ACTIVE_LINK /MRSS/T_ACTIVE_LINK /MRSS/_BOOLEAN CHAR 1   0   Links Are Active  
24 CLOCK_EXTRAPOL /MRSS/T_CLOCK_EXTRAPOL /MRSS/_BOOLEAN CHAR 1   0   Extrapolate Time Recording Data  
25 TEXT_ALERT /MRSS/T_ALERT_PROFILE_TEXT TEXT30 CHAR 30   0   Description of the alert profile  
26 TEXT_CHECK /MRSS/T_CHECK_PROFILE_TEXT TEXT30 CHAR 30   0   Description of Check Profile  
27 TEXT_UI TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
28 TEXT_WL /MRSS/T_WL_PROFILE_TEXT TEXT30 CHAR 30   0   Description of Worklist Profile  
29 REFRESH_WL /MRSS/T_REFRESH_WL /MRSS/_BOOLEAN CHAR 1   0   Update worklist automatically  
30 CHECK_QUAL /MRSS/T_CHECK_QUAL /MRSS/_BOOLEAN CHAR 1   0   Availability Check for Qualification Ranking  
31 AUTO_SAVE /MRSS/T_AUTO_SAVE /MRSS/_BOOLEAN CHAR 1   0   Enable Automatic Saving  
32 TIMER_BASED /MRSS/T_TIMER_BASED /MRSS/_BOOLEAN CHAR 1   0   Timer-based Saving  
33 NO_AUTO_SAVE /MRSS/T_NO_AUTO_SAVE /MRSS/_BOOLEAN CHAR 1   0   No Automatic Saving  
34 TIMER_TOGGLE /MRSS/T_UNTOGGLE_MODE /MRSS/_BOOLEAN CHAR 1   0   Untoggled-Timer Based  
35 SHOW_ORGUNIT /MRSS/T_SHOWORG /MRSS/_BOOLEAN CHAR 1   0   Show resource plannig node in front of resource  
36 TIMER_PERIOD /MRSS/T_CLOCK_TIMER_SAVE   DEC 3   0   Customizable Time interval for Automatic Save  
37 MANUAL_LOCKING /MRSS/T_SGE_MANUAL_LOCKING XFELD CHAR 1   0   Manual lock  
38 RESEL_DEM_NODE /MRSS/T_SGE_RESEL_DEM_NODE /MRSS/_BOOLEAN CHAR 1   0   Demand Planning Node  
39 RESEL_DEM_HIER /MRSS/T_SGE_RESEL_DEM_HIER /MRSS/_BOOLEAN CHAR 1   0   Demand Hierarchy  
40 RESEL_EXPLICIT /MRSS/T_SGE_RESEL_EXPLICIT /MRSS/_BOOLEAN CHAR 1   0   Explicit Planning Nodes  
41 DEM_HIER_LEVEL /MRSS/T_SGE_HIERARCHY_LEVEL /MRSS/_SGE_HIERARCHY_LEVEL NUMC 2   0   Resource Planning Node Hierarchy Level  
42 PRESEL_ID /MRSS/T_SQE_PRESEL_ID /MRSS/_SQE_PRESEL_ID CHAR 3   0   Preselection criteria identifier /MRSS/C_SQE_PSEL
43 QLF_MATCH_DISP /MRSS/T_SGE_QLF_MATCH_DISP /MRSS/_BOOLEAN CHAR 1   0   Display Qualification Match Result  
44 DEM_RES_SEL /MRSS/T_DEM_BASED_RES_SEL /MRSS/_BOOLEAN CHAR 1   0   Demand-Based Resource Selection  
45 TEAM_RESP /MRSS/T_TEAM_RESP /MRSS/_BOOLEAN CHAR 1   0   Person Responsible in the Team Required  
46 INTL_SHIFT_ACTV /MRSS/T_INTL_SHIFT /MRSS/_BOOLEAN CHAR 1   0   To check if intelligent Shifting is active or not  
47 MAX_SCALE_FACTOR /MRSS/T_SCALE_FACTOR /MRSS/_SCALE_FACTOR INT1 3   0   Maximum Scaling Factor for intelligent Shifting  
48 GEO_PROFILE /MRSS/T_GEO_PROFILE /MRSS/_GEO_PROFILE CHAR 10   0   Geo Profile Key /MRSS/C_GEO_SYS
49 OPT_PROFILE /MRSS/T_OPT_PROFILE   CHAR 10   0   Profile key of the optimizer /MRSS/C_OPT_SYS
50 BASIC_AVAIL /MRSS/T_BASIC_AVAIL /MRSS/_BOOLEAN CHAR 1   0   Basic Availability of the resource  
51 RESOURCE_STAT /MRSS/T_RES_STAT /MRSS/_BOOLEAN CHAR 1   0   Activates Status for Resources in Planning board  
52 DELAY_ASSGN /MRSS/T_DELAY_ASSGN /MRSS/_DELAY_ASSGN CHAR 1   0   Delay in Assignment Creation  
53 ACTIVE_OPT /MRSS/T_ACTIVE_OPT /MRSS/_BOOLEAN CHAR 1   0   Optimization Active  
54 ACTIVE_TRV_TIME /MRSS/T_ACTIVE_TRV_TIME /MRSS/_BOOLEAN CHAR 1   0   Travel Time Profile Active  
55 ACTIVE_MAP /MRSS/T_ACTIVE_MAP /MRSS/_BOOLEAN CHAR 1   0   Map is active  
56 GEO_PROF_DESC /MRSS/T_GEO_PROFILE_DESC TEXT80 CHAR 80   0   Geo profile Description  
57 OPT_PROF_DESC /MRSS/T_OPT_PROFILE_DESC TEXT80 CHAR 80   0   Optimizer Profile Description  
58 RES_LOCK_NO_DATE /MRSS/T_SGE_RES_LOCK_NO_DATE /MRSS/_BOOLEAN CHAR 1   0   Resource Lock Ignoring Dates  
59 ASK_FOR_SAVE /MRSS/T_SGU_ASK_FOR_SAVE /MRSS/_BOOLEAN CHAR 1   0   Confirm before save  
60 INIT_ALL_ITEMS /MRSS/T_INIT_ALL_ITEMS /MRSS/_BOOLEAN CHAR 1   0   Initialize All Work Items  
61 MAP_PROF_DESC /MRSS/T_MAP_PROFILE_DESC TEXT80 CHAR 80   0   Map Profile Description  
62 OPT_SCEN_DESC /MRSS/T_OPT_SCENARIO_DESC TEXT80 CHAR 80   0   Optimization Scenario Description  
63 DYNAMIC_BREAK /MRSS/T_SGE_DYNAMIC_BREAK /MRSS/_BOOLEAN CHAR 1   0   Enable Dynamic Breaks  
64 DEL_REF_ACT /MRSS/T_SGE_DELTA_REF_ACTIVE /MRSS/_BOOLEAN CHAR 1   0   Delta Refresh Active?  
65 DAYB_SCHED_ACT /MRSS/T_SGE_DAYBASED_SCHED_ACT /MRSS/_BOOLEAN CHAR 1   0   Activate Day-Based Scheduling  
66 DISTANCE_UNIT /MRSS/T_SGE_DISTANCE_UNIT /MRSS/_SGE_DISTANCE_UNIT CHAR 2   0   Unit of Measurement for the Distance  
67 IGNORE_HORIZON /MRSS/T_SGE_IGNORE_HORIZON /MRSS/_SGE_IGNORE_HORIZON CHAR 1   0   Deactivate Planning Horizon Checks  
68 NO_COMPL_ITEMS /MRSS/T_NO_COMPLETED_ITEMS /MRSS/_NO_COMPLETED_ITEMS CHAR 1   0   No Completed Items  
69 TRAVEL_TIME_UNIT /MRSS/T_TRAVEL_TIME_UNIT /MRSS/_TRAVEL_TIME_UNIT CHAR 3   0   Travel Time Unit  
70 DEM_SPLIT_MAINT /MRSS/T_DEM_SPLIT_MAINT   CHAR 1   0   Demand Split Maintenence  
71 MAP_PROFILE /MRSS/T_MAP_PROFILE /MRSS/_MAP_PROFILE CHAR 10   0   Map Profile /MRSS/C_GEO_MAP
72 OPT_SCENARIO /MRSS/T_OPT_SCENARIO_KEY /MRSS/_SCE_PROFILE_KEY CHAR 10   0   Optimization Scenario Key /MRSS/C_OPT_SCE
73 SI_UNITS /MRSS/T_SI_UNITS /MRSS/_BOOLEAN CHAR 1   0   Unit of Measurement for Travel Distance  
74 FPS_UNITS /MRSS/T_FPS_UNITS /MRSS/_BOOLEAN CHAR 1   0   Unit of measurement for Travel Distance in FPS Units  
75 WEBUI_PROFILE /MRSS/T_SGX_WEBUI_ID /MRSS/_SGX_WEBUI_PROFILE CHAR 10   0   ID of the Web User Interface Profile /MRSS/C_SGX_WPRO
76 TEXT_WEBUI /MRSS/T_SGX_PROFILE_TEXT TEXT30 CHAR 30   0   Description of the Web UI Profile  
77 AUTO_SCHED_MULTD /MRSS/T_SGE_MULTIDAY_SCHED_ACT /MRSS/_BOOLEAN CHAR 1   0   Automatic Scheduling of Multiday Assignments Is Active  
78 PARTS_CHECK_PROF /MRSS/T_MAT_CHECK_PROFILE   CHAR 10   0   Parts Check Profile /MRSS/C_MAT_CHK
79 TEXT_MAT_CHK /MRSS/T_MAT_PROFILE_DESC CHAR80 CHAR 80   0   Material Check Profile Description  
80 PART_COMM_EXEC /MRSS/T_PARTIAL_COMMAND_EXEC /MRSS/_PARTIAL_COMMAND_EXEC CHAR 1   0   Allow Partial Changes  
81 ALIGN_ASSIGNMENT /MRSS/T_SGE_ALIGN_ASSIGNMENTS /MRSS/_BOOLEAN CHAR 1   0   Align Assignments  
82 ALIGN_DROP_GAP /MRSS/T_SGE_ALIGN_DROP_GAP /MRSS/_SGE_ALIGN_DROP_GAP INT1 3   0   Maximum Time Interval in Hours  
83 ALIGN_TRV_NONAV /MRSS/T_SGE_NONAVAIL_TRV_TIME /MRSS/_BOOLEAN CHAR 1   0   Travel Time in Non-Availability  
84 RAL_PROFILE /MRSS/T_RAL_PROFILE_ID /MRSS/_RAL_PROFILE_ID CHAR 10   0   Resource Assignment List Profile ID /MRSS/C_RAL_DSEL
85 TEXT_RAL /MRSS/T_RAL_PROFILE_TEXT TEXT30 CHAR 30   0   Resource Assignment List Profile Description  
86 MOB_BASE /MRSS/T_ACTIVE_MOBILIZATION /MRSS/_BOOLEAN CHAR 1   0   Display Processing Times  
87 IGNORE_DEM_DATES /MRSS/T_SGE_IGNORE_DEM_DATES /MRSS/_BOOLEAN CHAR 1   0   Ignore Demand Dates in Alignment of Assignments  
88 RES_CONFIDENTIAL /MRSS/T_RES_CONFIDENTIALITY /MRSS/_BOOLEAN CHAR 1   0   Resource Is Confidential Outside Validity Period  
89 ASGN_CHNG_ALLOW /MRSS/T_ASGN_CHNG_ALLOW /MRSS/_BOOLEAN CHAR 1   0   Allow Resource Planning Outside Resource Validity Period  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /MRSS/V_SGE_PR_R ALERT_PROFILE /MRSS/C_AL_PROF ALERT_PROFILE    
2 /MRSS/V_SGE_PR_R CHECK_PROFILE /MRSS/C_CHECK_P CHECK_PROFILE    
3 /MRSS/V_SGE_PR_R GEO_PROFILE /MRSS/C_GEO_SYS GEO_PROFILE    
4 /MRSS/V_SGE_PR_R MAP_PROFILE /MRSS/C_GEO_MAP MAP_PROFILE    
5 /MRSS/V_SGE_PR_R OPT_PROFILE /MRSS/C_OPT_SYS PROFILE_KEY    
6 /MRSS/V_SGE_PR_R OPT_SCENARIO /MRSS/C_OPT_SCE SCENARIO_KEY    
7 /MRSS/V_SGE_PR_R PARTS_CHECK_PROF /MRSS/C_MAT_CHK PARTS_CHECK_PROF    
8 /MRSS/V_SGE_PR_R PRESEL_ID /MRSS/C_SQE_PSEL PRESEL_ID    
9 /MRSS/V_SGE_PR_R RAL_PROFILE /MRSS/C_RAL_DSEL RAL_PROFILE    
10 /MRSS/V_SGE_PR_R TMZ TTZZ TZONE    
11 /MRSS/V_SGE_PR_R UI_PROFILE /MRSS/C_SGU_PRO ID    
12 /MRSS/V_SGE_PR_R WEBUI_PROFILE /MRSS/C_SGX_WPRO WEB_UI_PROFILE    
13 /MRSS/V_SGE_PR_R WL_PROFILE /MRSS/C_WL_PR PROFILE    
History
Last changed by/on DDIC  20141109 
SAP Release Created in