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