SAP ABAP Table /MRSS/T_REQ_DEM_UI (Request Demand UI structure)
Hierarchy
☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ CA-CUS (Application Component) Global Organization Customizing
     ⤷ /MRSS/REQUEST_INT (Package) Requests for Internal Consultants
Basic Data
Table Category INTTAB    Structure 
Structure /MRSS/T_REQ_DEM_UI   Table Relationship Diagram
Short Description Request Demand UI structure    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   Request Demand UI structure  
2 .INCLUDE       0   0   Request UI Structure  
3 GUID /MRSS/T_REQ_GUID /MRSS/T_RAW16 RAW 16   0   Portal GUID  
4 .INCLUDE       0   0   Portal Demand Data  
5 DEMAND_GUID /MRSS/T_REQ_DEM_GUID /MRSS/T_RAW16 RAW 16   0   Portal Demand GUID  
6 OTYPE OTYPE OTYPE CHAR 2   0   Object Type *
7 OBJID HROBJID HROBJID NUMC 8   0   Object ID *
8 DEM_TYPE /MRSS/T_REQ_TYPE CHAR01 CHAR 1   0   Portal Type  
9 DEM_DESC /MRSS/T_REQ_DESCRIPTION CHAR80 CHAR 80   0   Request Description  
10 PRIORITY /MRSS/T_REQ_PRIORITY NUMC1 NUMC 1   0   Priority  
11 RM_CONTACT /MRSS/T_REQ_RES_CONT CHAR30 CHAR 30   0   Resource Contact  
12 STATUS_OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
13 PLND_START TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
14 PLND_END TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
15 NO_RES /MRSS/T_REQ_RES_COUNT INT4 INT4 10   0   Number of Resources  
16 DURATION /MRSS/T_SGE_DURATION MENG13 QUAN 13   3   Duration  
17 CREATED_BY USNAM XUBNAME CHAR 12   0   User name *
18 CREATED_AT TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
19 CHANGED_BY USNAM XUBNAME CHAR 12   0   User name *
20 CHANGED_AT TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
21 .INCLUDE       0   0    
22 OPERATION /MRSS/T_REQ_OPERATION CHAR1 CHAR 1   0   Type of Operation  
23 CURRENT_STATUS J_STATUS J_STATUS CHAR 5   0   Object status  
24 STATUS_TAB /MRSS/T_STATUS_TAB   TTYP 0   0    
25 REQ_PROFILE_ID /MRSS/T_REQ_REQUID CHAR10 CHAR 10   0   Requirement Profile ID  
26 .INCLUDE       0   0   Request Descriptions for UI  
27 REQ_DESC /MRSS/T_REQ_DESC CHAR40 CHAR 40   0   Description  
28 STATUS_DESC TXT30 TEXT30 CHAR 30   0   Text  
29 STATUS_UI /MRSS/T_REQ_STATUS_UI_TAB   TTYP 0   0    
30 .INCLUDE       0   0   Role Details Base Structure  
31 REQUEST_NO /MRSS/T_RM_REQ_ID /MRSS/T_REQ_ID CHAR 12   0   Request Number  
32 ROLE_NO /MRSS/T_RM_ROLE_ID VORNR CHAR 4   0   Role Number  
33 NAME /MRSS/T_RM_REQUEST_NAME TEXT40 CHAR 40   0   Request Name  
34 CUSTOMER_NAME /MRSS/T_RM_CUST_NAME TEXT40 CHAR 40   0   Customer Name  
35 TYPE_DESC /MRSS/T_RM_REQ_TYPE_DESC TEXT20 CHAR 20   0   Request Type Description  
36 REQUESTING_COUNTRY_ID /MRSS/T_RM_COUNTRY_ID /MRSS/RM_BROADCAST_TARGET CHAR 5   0   Req-ing Country *
37 REQUESTING_COUNTRY_DESC /MRSS/T_RM_COUNTRY_DESC TEXT20 CHAR 20   0   Requesting country  
38 DESCRIPTION /MRSS/T_RM_ROLE_DESC TEXT40 CHAR 40   0   Role Description  
39 NO_OF_CONS /MRSS/T_RM_NUMBER_CONSULT INT1 INT1 3   0   Number of Consultants  
40 PRIORITY_ID /MRSS/T_RM_ROLE_PRIORITY NW_PRIO CHAR 1   0   Role Priority *
41 PRIORITY_DESC /MRSS/T_RM_ROLE_PRIORITY_DESC TEXT40 CHAR 40   0   Role Priority desc  
42 NEARSHORE /MRSS/T_RM_IND /MRSS/RM_FLAG CHAR 1   0   Nearshore/Offshore Indicator  
43 FOUR_BY_TEN_IND /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
44 INT_DURATION /MRSS/T_RM_DURATION MENG13 QUAN 13   3   Duration  
45 DURATION_UNIT /MRSS/T_RM_DURATION_UNIT MEINS UNIT 3   0   Duration Unit *
46 START_DATE /MRSS/T_RM_ROLE_START_DATE DATUM DATS 8   0   Planned Start Date  
47 END_DATE /MRSS/T_RM_ROLE_END_DATE DATUM DATS 8   0   Planned Role End Date  
48 EFFORT /MRSS/T_RM_NO_OF_REQ_DAYS ARBEIT QUAN 7   1   Number of Requested Days  
49 EFFORT_UNIT USRUNIT MEINS UNIT 3   0   User field: Unit for quantity fields T006
50 NO_OF_DAYS_PER_WEEK /MRSS/T_RM_NUMBER_DAYS /MRSS/RM_NUMBER_DAYS NUMC 1   0   Number of days per week (Working Ratio)  
51 PART_TIME /MRSS/T_RM_PART_TIME /MRSS/RM_FLAG CHAR 1   0   Part Time Possible  
52 REQUIRED_24_HOURS /MRSS/T_RM_IMMEDIATE_REQ /MRSS/RM_FLAG CHAR 1   0   Consultant required in 24 hours  
53 LATEST_FEEDBACK_DATE /MRSS/T_RM_LATEST_FEEDBCK_DATE DATUM DATS 8   0   Latest Feedback date  
54 PROJECT_LOCATION /MRSS/T_RM_ROLE_LOCATION TEXT40 CHAR 40   0   Role Location  
55 PROJECT_CTRY_ID /MRSS/T_RM_PROJ_COUNTRY LAND1 CHAR 3   0   Project Country T005S
56 PROJECT_CTRY_DESC /MRSS/T_RM_PROJ_COUNTRY_DESC TEXT15 CHAR 15   0   Project Country Description  
57 PROJECT_STATE_ID /MRSS/T_RM_STATE REGIO CHAR 3   0   State /MRSS/V_RM_T005S
58 PROJECT_STATE_DESC /MRSS/T_RM_STATE_DESC TEXT20 CHAR 20   0   State Desc.  
59 REMOTE /MRSS/T_RM_REMOTE /MRSS/RM_REMOTE_POSSIBLE CHAR 1   0   Remote possible  
60 ROLE_TYPE_ID /MRSS/T_RM_ROLE_TYPE /MRSS/RM_ROLE_TYPE CHAR 2   0   Role Type ID /MRSS/C_RM_RTY
61 ROLE_TYPE_DESC /MRSS/T_RM_ROLE_TYPE_DESC TEXT40 CHAR 40   0   Role Type Description  
62 PRESALES /MRSS/T_RM_PRESALES FLAG CHAR 1   0   Relevant for Presales  
63 LANGUAGES /MRSS/T_RM_LANGUAGE TEXT40 CHAR 40   0   Language(s)  
64 CALC_COST_RATE /MRSS/T_RM_CALC_COST_RATE USRCURR13 CURR 13   3   Calculated Cost Rate  
65 CALC_COST_RATE_CURR WAERS WAERS CUKY 5   0   Currency Key TCURC
66 SKILL_UI /MRSS/T_RM_SKILL_UI   STRU 0   0    
67 UNSTRUCTURED_SKILLS /MRSS/T_RM_NONCAT_SKILLS_TAB   TTYP 0   0    
68 STRUCTURED_SKILLS /MRSS/T_RM_STRUCTURED_QUAL_TAB   TTYP 0   0    
69 ADDN_ATTRIBUTES /MRSS/T_RM_REQ_ADDN_ATTR   STRU 0   0    
70 COMP_PROFILE_ID /MRSS/T_RM_COMP_PROFILE /MRSS/T_RM_QUALI NUMC 8   0   Competency Profile  
71 COMP_PROF_DESC /MRSS/T_RM_COMP_PROF_DESC TEXT40 CHAR 40   0   PACE Competence Profile  
72 SOL_PROFILE_ID /MRSS/T_RM_SOLUTION_PROFILE /MRSS/T_RM_QUALI NUMC 8   0   Solution Profile  
73 SOL_PROFILE_DESC /MRSS/T_RM_SOL_PROF_DESC TEXT40 CHAR 40   0   PACE Solution Profile  
74 IND_FOCUS_ID /MRSS/T_RM_INDUSTRY_FOCUS /MRSS/T_RM_QUALI NUMC 8   0   Industry Focus  
75 IND_FOCUS_DESC /MRSS/T_RM_IND_FOCUS_DESC /MRSS/RM_DESC_40 CHAR 40   0   PACE Industry Focus  
76 JOB_TEXT_ID /MRSS/T_RM_JOB_TEXT NUMC8 NUMC 8   0   Job Text ID  
77 JOB_TEXT_DESC /MRSS/T_RM_JOB_TEXT_DESC TEXT40 CHAR 40   0   Job Text  
78 JOB_TEXT_IND /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
79 PLATINUM_CONS CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
80 POSSIBLE_LANG /MRSS/T_RM_LANGUAGE TEXT40 CHAR 40   0   Language(s)  
81 CMP_PR_TOBE_ID /MRSS/T_RM_COMP_PROFILE /MRSS/T_RM_QUALI NUMC 8   0   Competency Profile  
82 CMP_PR_TOBE_DSC /MRSS/T_RM_COMP_PROF_DESC TEXT40 CHAR 40   0   PACE Competence Profile  
83 SOL_PROF_GRP /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
84 COMP_PROF_GRP /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
85 SOL_PROF_ND_ID /MRSS/T_RM_SOLUTION_PROFILE /MRSS/T_RM_QUALI NUMC 8   0   Solution Profile  
86 COMP_PROF_ND_ID /MRSS/T_RM_COMP_PROFILE /MRSS/T_RM_QUALI NUMC 8   0   Competency Profile  
87 SOL_PROF_NODE_DESC /MRSS/T_RM_SOL_PROF_DESC TEXT40 CHAR 40   0   PACE Solution Profile  
88 COMP_PROF_NODE_DESC /MRSS/T_RM_COMP_PROF_DESC TEXT40 CHAR 40   0   PACE Competence Profile  
89 SOL_NODE_TYPE OTYPE OTYPE CHAR 2   0   Object Type *
90 COMP_NODE_TYPE OTYPE OTYPE CHAR 2   0   Object Type *
91 .INCLUDE       0   0   Object Key for Role  
92 GUID SYSUUID_X SYSUUID RAW 16   0   UUID in X form (binary)  
93 REQUEST_NUMBER /MRSS/T_RM_REQ_ID /MRSS/T_REQ_ID CHAR 12   0   Request Number  
94 ROLE_NUMBER /MRSS/T_RM_ROLE_ID VORNR CHAR 4   0   Role Number  
95 COMP_PROF_TOBE_ID /MRSS/T_RM_QUALI_D /MRSS/_QUALI NUMC 8   0   Qualification Keys  
96 COMP_PROF_TOBE_DESC /MRSS/T_RM_QTEXT   CHAR 40   0   Qualification Text  
97 DUMMY /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
98 THIRD_PARTY_ALLOWED /MRSS/T_RM_THIRD_PARTY FLAG CHAR 1   0   External Consultant Flag  
99 REQUESTED_THIRD_PARTY /MRSS/T_RM_REQ_PARTNER USRCHAR20 CHAR 20   0   Requested Partner  
100 SYSTEM_INFO /MRSS/T_RM_SYSTEM_INFO TEXT120 CHAR 120   0   System Info  
101 RO_ROLEGROUP_ID /MRSS/T_RM_RO_GROUP_ROLE /MRSS/T_RM_CR_OBJID NUMC 8   0   Role Owner Group - Role  
102 RO_ROLEGROUP_NAME /MRSS/T_RM_RO_ROLEGROUP_NAME TEXT40 CHAR 40   0   RO Group Name -Role  
103 REQUEST_OWNER_ID /MRSS/T_RM_ROLE_RO_ID PERNR NUMC 8   0   Request Owner - Role  
104 REQUEST_OWNER_NAME /MRSS/T_RM_ROLE_RO_NAME TEXT40 CHAR 40   0   Request Owner Name - Role  
105 TOTAL_EFFORT /MRSS/T_RM_ROLE_TOTAL_EFFORT DAUER_4_1 QUAN 5   1   Total Effort  
106 KRATE /MRSS/T_RM_KRATE /MRSS/RM_KRATE CHAR 10   0   K-rate  
107 PUBLISH_EXT /MRSS/T_RM_RO_PUB_TO_PORTAL FLAG CHAR 1   0   Publish Requested Role - RO  
108 ASSIGNMENT_TYPE_ID /MRSS/T_RM_ASSIGNMENT_TYPE /MRSS/RM_ASSIGNMENT_TYPE CHAR 2   0   Assignment Type ID /MRSS/C_RM_AT
109 ASSIGNMENT_TYPE_DESC /MRSS/T_RM_ASSGN_TYPE_DESC TEXT20 CHAR 20   0   Assignment Type Description  
110 PROJECT_ACTIVITY_ID /MRSS/T_RM_PROJECT_ACTIVITY /MRSS/RM_PROJECT_ACTIVITY CHAR 2   0   Role Activity ID /MRSS/C_RM_PA
111 PROJECT_ACTIVITY_DESC /MRSS/T_RM_PROJECT_ACTVTY_DESC TEXT20 CHAR 20   0   Project Activity Desc.  
112 STATUS_INDICATOR /MRSS/T_RM_STATUS_IND /MRSS/RM_STATUS_INDICATOR CHAR 1   0   STATUS Indicator  
113 SP_ID /MRSS/T_RM_SEARCH_PARTY PERNR NUMC 8   0   Searching Party Name  
114 SP_NAME /MRSS/T_RM_SEARCH_PARTY_NAME TEXT40 CHAR 40   0   Searching Party Person Name  
115 SP_GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
116 SP_GROUP /MRSS/T_RM_SP_GROUP /MRSS/T_RM_CR_OBJID NUMC 8   0   Searching Party Group  
117 SP_GRP_NAME /MRSS/T_RM_SP_GROUP_DESC TEXT40 CHAR 40   0   Searching Party Group Name  
118 SP_STATUS_ID /MRSS/T_RM_SP_STATUS FLAG CHAR 1   0   Searching Party Status  
119 SP_DURATION_UNIT /MRSS/T_RM_SP_DURATION_UNIT MEINS UNIT 3   0   Duration Unit *
120 SP_DURATION /MRSS/T_RM_SP_DURATION DAUER_4_1 QUAN 5   1   Searching Party Duration  
121 SP_NOOF_RESR /MRSS/T_RM_SP_NUMBER_CONSULT INT1 INT1 3   0   Number of Consultants  
122 .INCLUDE       0   0   Request/Role Administrative Data  
123 INT_CREATED_BY /MRSS/T_RM_AUFERFNAM USNAM CHAR 12   0   Entered by  
124 INT_CREATED_ON /MRSS/T_RM_AUFERFDAT DATUM DATS 8   0   Created on  
125 INT_CHANGED_BY /MRSS/T_RM_AUFAENAM USNAM CHAR 12   0   Last changed by  
126 INT_CHANGED_ON /MRSS/T_RM_AUFAEDAT DATUM DATS 8   0   Change date for Order Master  
127 INT_CREATEDUSER /MRSS/T_RM_CREATED_BY CHAR30 CHAR 30   0   Created By  
128 INT_CHANGEDUSER /MRSS/T_RM_CHANGED_BY CHAR30 CHAR 30   0   Changed By Name  
129 BROADCASTS_VBKZ /MRSS/T_RM_VBKZ /MRSS/_VERBUCHER CHAR 1   0   Update Indicator  
130 HIGHEST_CAND_STATUS_ID /MRSS/T_RM_HIGH_CAND_STATUS_ID /MRSS/RMS_PARTNER_STAT CHAR 5   0   Highest Candidate Status  
131 HIGHEST_CAND_STATUS_DESC /MRSS/T_RM_HIGH_CAND_STAT_DESC TEXT30 CHAR 30   0   Highest Candidate Status  
132 VISIBLE /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
133 INT_CHANGED_AT /MRSS/T_RM_CHANGEDAT_TS TZNTSTMPLL NUMC 21   0   Changed at Timestamp  
134 VERSION_NO /MRSS/T_RM_MDCI_VERSION CHAR10 CHAR 10   0   Version Number  
135 CREATEDON /MRSS/T_RM_CREATEDON_TS TZNTSTMPLL NUMC 21   0   Created On Timestamp  
136 REQUESTING_SUB_REGION_DESC /MRSS/T_RM_SUB_REGION_DESC TEXT20 CHAR 20   0   Requesting Sub Region  
137 REQUESTING_SUB_REGION /MRSS/T_RM_SUB_REG /MRSS/RM_SUB_REG CHAR 8   0   Subregion  
138 USER_ROLES /MRSS/T_RM_USER_ROLES   STRU 0   0    
139 REQUESTER /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
140 OWNER /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
141 ROSP /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
142 SEARCHING_PARTY /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
143 DISP_WITH_SAVE /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
144 CONSULTANT /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
145 ROLE_AUTH ACTIV_AUTH ACTIV_AUTH CHAR 2   0   Activity *
146 ROLE_SCOPE_TEXT /MRSS/T_RM_ROLE_SCOPE_TEXT   STRG 0   0   Role Scope  
147 PROJECT_LANGU SPRAS SPRAS LANG 1   0   Language Key *
148 ROLE_SERVICE_PHASE_ID /MRSS/T_RM_SERV_PHASE_ROLE /MRSS/RM_SERV_PHASE CHAR 2   0   Resource Management Role Service Phase *
149 ROLE_SERVICE_PHASE_DESC /MRSS/T_RM_SERV_PHASE_ROLE_DES TEXT20 CHAR 20   0   Resource Management Role Service Phase Description  
150 ORDER_PROB /MRSS/T_RM_ROLE_ORDER_PROB /MRSS/RM_ORDER_PROB CHAR 2   0   Probability to Close(Role) *
151 ORDER_PROB_DESC /MRSS/T_RM_ROLE_ORD_PROB_DESC TEXT20 CHAR 20   0   Probability to Close (Role) desc  
152 BUDGET /MRSS/T_RM_BUDGET_RESTRICTION TEXT40 CHAR 40   0   Budget Restriction  
153 CORPORATE_ORG_ID /MRSS/T_RM_CORP_ORG /MRSS/RM_CORP_ORG CHAR 2   0   Corporate Organization *
154 CORPORATE_ORG_DESC /MRSS/T_RM_CORP_ORG_DESC TEXT20 CHAR 20   0   Corporate Organization  
155 BILLING_OBJECT /MRSS/T_RM_BILL_OBJ AUFEX CHAR 20   0   SO/IO/CC Number  
156 BILLING_OBJECT_TYPE /MRSS/T_RM_BILLING_OBJECT_TYPE /MRSS/RM_BILLING_OBJECT_TYPE CHAR 2   0   Billing Object Type  
157 FLEX_START_DATE /MRSS/T_RM_FLEX_START_DATE FLAG CHAR 1   0   Flexible Start Date  
158 COMMENTS_EXTERNAL /MRSS/T_RM_ROLE_EXT_COMMENTS   STRG 0   0   Role External comments  
159 REQ_COMMENTS_EXT /MRSS/T_RM_EXT_COMM_HDR   STRG 0   0   External Comments - Header  
160 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /MRSS/T_REQ_DEM_UI ASSIGNMENT_TYPE_ID /MRSS/C_RM_AT ASSIGNMENT_TYPE    
2 /MRSS/T_REQ_DEM_UI CALC_COST_RATE_CURR TCURC WAERS    
3 /MRSS/T_REQ_DEM_UI EFFORT_UNIT T006 MSEHI    
4 /MRSS/T_REQ_DEM_UI PROJECT_ACTIVITY_ID /MRSS/C_RM_PA ACTIVITY_TYPE    
5 /MRSS/T_REQ_DEM_UI PROJECT_CTRY_ID T005S LAND1    
6 /MRSS/T_REQ_DEM_UI PROJECT_STATE_ID /MRSS/V_RM_T005S BLAND    
7 /MRSS/T_REQ_DEM_UI ROLE_TYPE_ID /MRSS/C_RM_RTY ROLE_TYPE    
History
Last changed by/on SAP  20141109 
SAP Release Created in 700