SAP ABAP Table /MRSS/T_RMOR_SOFTBOOK_EXP (Softbook expiry report)
Hierarchy
☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC (Application Component) Maintenance Processing
     ⤷ /MRSS/RMOR (Package) Online Reporting for RMFS
Basic Data
Table Category INTTAB    Structure 
Structure /MRSS/T_RMOR_SOFTBOOK_EXP   Table Relationship Diagram
Short Description Softbook expiry report    
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 T_RM_CAND /MRSS/T_RM_CANDIDATE   STRU 0   0    
2 .INCLUDE       0   0   Object Key for Role  
3 GUID SYSUUID_X SYSUUID RAW 16   0   UUID in X form (binary)  
4 REQUEST_NUMBER /MRSS/T_RM_REQ_ID /MRSS/T_REQ_ID CHAR 12   0   Request Number  
5 ROLE_NUMBER /MRSS/T_RM_ROLE_ID VORNR CHAR 4   0   Role Number  
6 DEMAND_GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
7 ID /MRSS/T_RM_CANDIDATE_ID PERNR NUMC 8   0   Consultant ID  
8 NAME /MRSS/T_RM_EMP_NAME TEXT40 CHAR 40   0   Employee Name  
9 USERID /MRSS/T_RM_USER_ID XUBNAME CHAR 12   0   User Name in User Master Record  
10 CANDIDATE_TYPE /MRSS/T_RM_CANDIDATE_TYPE /MRSS/RM_CANDIDATE_TYPE CHAR 10   0   Candidate Type  
11 CANDIDATE_TYPE_DESC /MRSS/T_RM_CAND_TYPE_DESC TEXT30 CHAR 30   0   Candidate Type Desc  
12 PROFIT_CENTER_ID /MRSS/T_RM_CAND_PRCTR PRCTR CHAR 10   0   Candidate Profit Center ID  
13 PROFIT_CENTER /MRSS/T_RM_PROFIT_CENTER_DESC TEXT20 CHAR 20   0   Profit Center  
14 HR_OBJID /MRSS/T_RM_HR_OBJECT NUM08 NUMC 8   0   Org. unit of the Candidate  
15 HR_OBJID_NAME /MRSS/T_RM_HR_OBJ_NAME CHAR100 CHAR 100   0   Org. unit Name  
16 VISIBLE /MRSS/T_RM_FLAG FLAG CHAR 1   0   Indicator  
17 STATUS_TAB /MRSS/T_RM_CAND_STAT_TAB   TTYP 0   0    
18 STATUS_OLD /MRSS/T_RM_PARTNER_STAT_OLD J_ESTAT CHAR 5   0   Partner Status  
19 .INCLUDE       0   0   Additional Partner Details  
20 STATUS /MRSS/T_RM_PARTNER_STAT J_ESTAT CHAR 5   0   Candidate Status  
21 REJ_CODE /MRSS/T_RM_REJ_CODE /MRSS/RM_REJ_CODE CHAR 2   0   Candidate Rejection Code  
22 COMMENTS /MRSS/T_RM_PARTNER_COMMENT TEXT255 CHAR 255   0   Comments for Partner  
23 CREATEDON TZNTSTMPLL TZNTSTMPLL NUMC 21   0   Time Stamp - Long Format  
24 CREATED_BY /MRSS/T_RM_AUFERFNAM USNAM CHAR 12   0   Entered by  
25 CHANGEDON TZNTSTMPLL TZNTSTMPLL NUMC 21   0   Time Stamp - Long Format  
26 CHANGEDBY /MRSS/T_RM_AUFAENAM USNAM CHAR 12   0   Last changed by  
27 VERSION_NO /MRSS/T_RM_MDCI_VERSION CHAR10 CHAR 10   0   Version Number  
28 STATUS_OBJ_KEY J_OBJNR J_OBJNR CHAR 22   0   Object number  
29 START_DATE /MRSS/T_RM_CAND_PROPOSED_START DATUM DATS 8   0   Proposed Start Date  
30 END_DATE /MRSS/T_RM_CAND_PROPOSED_END DATUM DATS 8   0   Proposed End Date  
31 STAFFED_DAYS /MRSS/T_RM_STAFFED_DAYS DEC3_1 DEC 4   1   Staffed Days  
32 SOFT_BOOK_EXP /MRSS/T_RM_CAND_SOFT_EXPDT DATUM DATS 8   0   Soft Booking Expiry Date  
33 VENDOR_CONS_NAME /MRSS/T_RM_VENDOR_CONS_NAME TEXT40 CHAR 40   0   Partner Consultant name  
34 VENDOR_COST_RATE /MRSS/T_RM_VENDOR_COST_RATE   CURR 13   2   Vendor Cost Rate  
35 VENDOR_RATE_CURR WAERS WAERS CUKY 5   0   Currency Key  
36 FOUR_BY_TEN_IND /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
37 ASSGN_EXIST /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
38 BOOK_TYPE /MRSS/T_RM_BOOKING_TYPE /MRSS/RM_BOOKING_TYPE CHAR 10   0   Booking Type  
39 BOOK_TYPE_DESC /MRSS/T_RM_BOOK_TYPE_DESC CHAR60 CHAR 60   0   Booking type text  
40 SP_GROUP /MRSS/T_RM_SP_GROUP /MRSS/T_RM_CR_OBJID NUMC 8   0   Searching Party Group  
41 SP_ID /MRSS/T_RM_SEARCH_PARTY PERNR NUMC 8   0   Searching Party Name  
42 ORIGIN_TYPE /MRSS/T_RM_ORIGIN_TYPE /MRSS/_RM_ORIGIN_TYPE CHAR 1   0   RM Origin Type  
43 ORIGIN_ID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
44 STATUS_DESC /MRSS/T_RM_CAND_STATUS_DESC TEXT30 CHAR 30   0   Candidate Status  
45 REJ_CODE_DESC /MRSS/T_RM_REJ_DESC TEXT20 CHAR 20   0   Rejection Code Description  
46 RESUME /MRSS/T_RM_RESUME TEXT80 CHAR 80   0   Link to Candidate Resume  
47 RESUME_URL /MRSS/T_RM_RESUME_URL CHAR255 CHAR 255   0   Field for Resume URL  
48 CONS_MANAGER_ID PERNR_D PERNR NUMC 8   0   Personnel Number  
49 CONS_MANAGER /MRSS/T_RM_CONS_MANAGER TEXT40 CHAR 40   0   Consultant Manager  
50 HOME_CITY /MRSS/T_RM_CONS_CITY   CHAR 40   0   Home City  
51 HOME_REGION /MRSS/T_RM_CONS_REGION TEXT20 CHAR 20   0   Region  
52 HOME_POSTAL_CODE /MRSS/T_RM_CONS_POSTAL_CODE PSTLZ CHAR 10   0   Home Postal Code  
53 OFFICE_LOCATION /MRSS/T_RM_CONS_OFF_LOCATION PAD_ORT01 CHAR 40   0   Office Location  
54 COUNTRY /MRSS/T_RM_CONS_COUNTRY TEXT15 CHAR 15   0   Country of the Consultant  
55 KRATE /MRSS/T_RM_KRATE /MRSS/RM_KRATE CHAR 10   0   K-rate  
56 COST_RATE /MRSS/T_RM_CONS_COST_RATE USRCURR13 CURR 13   3   Cost Rate of the consultant  
57 COST_RATE_CURR WAERS WAERS CUKY 5   0   Currency Key  
58 JOB_TEXT /MRSS/T_RM_JOB_TEXT_DESC TEXT40 CHAR 40   0   Job Text  
59 ORIGIN /MRSS/T_RM_CONS_ORIGIN TEXT10 CHAR 10   0   Resource Origin  
60 PROFILE_GUID /MRSS/T_PROFILE_GUID /MRSS/_SQP_GUID RAW 16   0   Profile GUID  
61 .INCLUDE       0   0   Third Party Candidates  
62 VENDOR_NAME /MRSS/T_RM_VENDOR_NAME TEXT30 CHAR 30   0   Partner name  
63 VENDOR_ID LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor  
64 EXT_CANDIDATE CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
65 EXT_PARTNER_ID /MRSS/T_SGE_PARTNER_ID /MRSS/_SGE_PARTNER_ID CHAR 20   0   Partner ID  
66 CREATED_DATE /MRSS/T_RM_AUFERFDAT DATUM DATS 8   0   Created on  
67 CHANGED_DATE /MRSS/T_RM_AUFAEDAT DATUM DATS 8   0   Change date for Order Master  
68 CREATED_BY_NAME /MRSS/T_RM_CREATEDBY_NAME /MRSS/RM_NAME CHAR 40   0   Created By Name  
69 CHANGED_BY_NAME /MRSS/T_RM_CHANGEDBY_NAME /MRSS/RM_NAME CHAR 40   0   Changed By Name  
70 COST_RATE_DISP /MRSS/T_RM_COSTRATE_DISP CHAR20 CHAR 20   0   Cost rate display field  
71 ATTACHMENTS /MRSS/T_RM_ATTACH_TAB   TTYP 0   0    
72 PROFILE_URL /MRSS/T_RM_CAND_PROFILE_URL   STRG 0   0   Profile Url  
73 .INCLUDE       0   0   Candidate button Authorization structure  
74 CAND_NEW /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
75 CAND_DELETE /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
76 CAND_EMAIL /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
77 CAND_CREAT_ASIGN /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
78 CAND_ASGN_DETL /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
79 CAND_PROF_ATTACH /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
80 CAND_RM_ATTACH /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
81 CAND_ASGN_DELETE /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
82 SELF_BK_VISIBLE /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
83 SELF_BK_ENABLE /MRSS/T_BOOLEAN /MRSS/_BOOLEAN CHAR 1   0   Boolean Variable  
84 COMPANY_CODE BUKRS BUKRS CHAR 4   0   Company Code  
85 COMPANY_CODE_NAME /MRSS/T_RM_COMPANY_CODE_NAME CHAR40 CHAR 40   0   Company code name  
86 PLATINUM_DESIG /MRSS/T_RM_PLAT_CONS CHAR1 CHAR 1   0   Platinum Consultant Indicator  
87 TRAVEL_RESTRICTION /MRSS/T_RM_TRAVEL_IND CHAR1 CHAR 1   0   Travel Restriction Indicator  
88 SAP_EXPOSURE_DATE /MRSS/T_RM_SAP_EXP_DATE DATS DATS 8   0   SAP Exposure Date  
89 POSITION /MRSS/T_RM_POSITION CHAR20 CHAR 20   0   Position  
90 MOBILE_PHONE_NUM /MRSS/T_RM_MOBILE_PHONE NUMC13 NUMC 13   0   Candidate's Cell Phone Number  
91 CONS_COMMENT /MRSS/T_RM_CONS_COMMENT CHAR100 CHAR 100   0   Consultant's Comments  
92 CONS_MGR_COOMENT /MRSS/T_RM_CONS_MGR_COMM CHAR100 CHAR 100   0   Consultant's Manger's Comments  
93 CURRENT_CUSTOMERS /MRSS/T_RM_CURR_CUST   STRG 0   0   Current Customers for the resource  
94 OLD_ASSIGNMENTS /MRSS/T_RMFS_ASSIGN_EXT_TAB   TTYP 0   0    
95 CHG_ASSIGNMENTS /MRSS/T_RMFS_ASSIGN_EXT_TAB   TTYP 0   0    
96 CANDIDATE_INO /MRSS/T_RM_CAND_INO TEXT40 CHAR 40   0   Personal No or Employee Id  
97 CAND_AUTH_ACTVT ACTIV_AUTH ACTIV_AUTH CHAR 2   0   Activity  
98 CAND_AUTH /MRSS/T_RM_CAND_AUTH /MRSS/RM_CAND_AUTH CHAR 1   0   RM candidate Authorization  
99 SP_GRP_NAME /MRSS/T_RM_SP_GROUP_DESC TEXT40 CHAR 40   0   Searching Party Group Name  
100 SP_NAME /MRSS/T_RM_SEARCH_PARTY_NAME TEXT40 CHAR 40   0   Searching Party Person Name  
101 EMP_FIELD1 /MRSS/T_RM_EMP_FIELD   STRG 0   0   Employee Fields  
102 EMP_FIELD2 /MRSS/T_RM_EMP_FIELD   STRG 0   0   Employee Fields  
103 EMP_FIELD3 /MRSS/T_RM_EMP_FIELD   STRG 0   0   Employee Fields  
104 EMP_FIELD4 /MRSS/T_RM_EMP_FIELD   STRG 0   0   Employee Fields  
105 .INCLUDE       0   0    
106 REQUEST_NUMBER /MRSS/T_RM_REQ_ID /MRSS/T_REQ_ID CHAR 12   0   Request Number  
107 ROLE_NUMBER /MRSS/T_RM_ROLE_ID VORNR CHAR 4   0   Role Number  
108 GUID /MRSS/T_GUID SYSUUID RAW 16   0   GUID  
109 RESOURCE_KEY /MRSS/T_GUID_RES SYSUUID RAW 16   0   Resource GUID  
110 KEY_EXT /MRSS/T_DEM_KEY_EXT CHAR60 CHAR 60   0   External Demand Key  
111 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
112 NAME /MRSS/T_RM_EMP_NAME TEXT40 CHAR 40   0   Employee Name  
113 ID /MRSS/T_SGE_PARTNER_ID /MRSS/_SGE_PARTNER_ID CHAR 20   0   Partner ID  
114 USERID /MRSS/T_RM_USER_ID XUBNAME CHAR 12   0   User Name in User Master Record *
115 CN_RM_GR /MRSS/T_RMOR_CAN_RM_GROUP /MRSS/_CR_OBJID NUMC 8   0   Candidate RM Group ID  
116 DESCRIPTION /MRSS/T_RM_ROLE_DESC TEXT40 CHAR 40   0   Role Description  
117 SOL_PROFILE_DESC /MRSS/T_RMOR_SOL_PROFILE_DESC TEXT40 CHAR 40   0   PACE solution profile desc  
118 PACE_COMPETENCE_PROF_ID /MRSS/T_RMOR_COMP_PROFILE_ID /MRSS/_SGW_QUALI NUMC 8   0   PACE Comp Profile ID  
119 VENDOR_CONS_NAM /MRSS/T_RM_VENDOR_CONS_NAME TEXT40 CHAR 40   0   Partner Consultant name  
120 ORIGIN /MRSS/T_RM_CONS_ORIGIN TEXT10 CHAR 10   0   Resource Origin  
121 HR_OBJID /MRSS/T_RM_HR_OBJECT NUM08 NUMC 8   0   Org. unit of the Candidate  
122 HR_OBJID_NAME /MRSS/T_RM_HR_OBJ_NAME CHAR100 CHAR 100   0   Org. unit Name  
123 COMPANY_CODE BUKRS BUKRS CHAR 4   0   Company Code *
124 COUNTRY /MRSS/T_RM_CONS_COUNTRY TEXT15 CHAR 15   0   Country of the Consultant  
125 REQUEST_OWNER_ID /MRSS/T_RM_ROLE_RO_ID PERNR NUMC 8   0   Request Owner - Role  
126 REQUEST_OWNER_NAME /MRSS/T_RM_ROLE_RO_NAME TEXT40 CHAR 40   0   Request Owner Name - Role  
127 REQUIRED_PACE_COMPETENCE_PROFI /MRSS/T_RMOR_COMP_PROFILE_DESC TEXT40 CHAR 40   0   Competency Profile Description  
128 SOL_PROFILE_DESC_ID /MRSS/T_RMOR_SOLUTION_PROFILE /MRSS/_SGW_QUALI NUMC 8   0   PACE Solution Profile ID  
129 PROFIT_CENTER_ID /MRSS/T_RM_CAND_PRCTR PRCTR CHAR 10   0   Candidate Profit Center ID *
130 PROFIT_CENTER /MRSS/T_RM_PROFIT_CENTER_DESC TEXT20 CHAR 20   0   Profit Center  
131 RO_GROUP_ID /MRSS/T_RM_RO_GROUP_HDR /MRSS/T_RM_CR_OBJID NUMC 8   0   Request Owner Header Group ID  
132 RO_GROUP_NAME /MRSS/T_RM_ROGROUP_NAME TEXT40 CHAR 40   0   RO Group  
133 REQUESTER_ID /MRSS/T_RM_REQUESTER PERNR NUMC 8   0   Requester  
134 REQUESTER_NAME /MRSS/T_RM_REQUESTER_NAME /MRSS/RM_NAME CHAR 40   0   Requester Name  
135 TYPE /MRSS/T_RM_REQUEST_TYPE /MRSS/RM_REQUEST_TYPE CHAR 2   0   Request Type  
136 TYPE_DESC /MRSS/T_RM_REQ_TYPE_DESC TEXT20 CHAR 20   0   Request Type Description  
137 ORDER_PROB /MRSS/T_RM_ROLE_ORDER_PROB /MRSS/RM_ORDER_PROB CHAR 2   0   Probability to Close(Role) *
138 ORDER_PROB_DESC /MRSS/T_RM_ROLE_ORD_PROB_DESC TEXT20 CHAR 20   0   Probability to Close (Role) desc  
139 COMPANY_CODE_NAME /MRSS/T_RM_COMPANY_CODE_NAME CHAR40 CHAR 40   0   Company code name  
140 EXT_PARTNER_ID /MRSS/T_SGE_PARTNER_ID /MRSS/_SGE_PARTNER_ID CHAR 20   0   Partner ID  
141 SOFT_BOOK_EXP /MRSS/T_RM_CAND_SOFT_EXPDT DATUM DATS 8   0   Soft Booking Expiry Date  
142 ASSIGNMENT_TYPE_ID /MRSS/T_RM_ASSIGNMENT_TYPE /MRSS/RM_ASSIGNMENT_TYPE CHAR 2   0   Assignment Type ID *
143 ASSIGNMENT_TYPE_DESC /MRSS/T_RM_ASSGN_TYPE_DESC TEXT20 CHAR 20   0   Assignment Type Description  
144 CUSTOMER_ID /MRSS/T_RM_CUST_ID /MRSS/T_RM_KUNNR CHAR 10   0   Customer Number  
145 CUSTOMER_NAME /MRSS/T_RM_CUST_NAME TEXT40 CHAR 40   0   Customer Name  
146 COMMENTS /MRSS/T_RM_PARTNER_COMMENT TEXT255 CHAR 255   0   Comments for Partner  
147 STATUS_DESC /MRSS/T_RM_CAND_STATUS_DESC TEXT30 CHAR 30   0   Candidate Status  
148 STATUS /MRSS/T_RM_PARTNER_STAT J_ESTAT CHAR 5   0   Candidate Status *
149 REQUESTING_REGION_ID /MRSS/T_RMOR_REGION /MRSS/_PRQ_CH8 CHAR 8   0   Requesting Region  
150 REQUESTING_REGION_DESC /MRSS/T_RMOR_REQ_SAP_REG_DESC TEXT30 CHAR 30   0   Requesting SAP Region desc  
151 REQUESTING_COUNTRY /MRSS/T_RMOR_REQ_COUNTRY_DESC TEXT20 CHAR 20   0   Requesting country Description  
152 RO_HDR_ID /MRSS/T_RMOR_RO_HDR_ID PERNR NUMC 8   0   RO - Header ID  
153 RO_HDR_NAME /MRSS/T_RMOR_RO_NAME_HDR /MRSS/RM_NAME CHAR 40   0   RO - Header Name  
154 CONS_MANGR_ID /MRSS/T_RMOR_CONS_MGR CHAR30 CHAR 30   0   Cons. Manager ID  
155 CONSULTANT_MANAGER_NAME /MRSS/T_RM_CONS_MANAGER TEXT40 CHAR 40   0   Consultant Manager  
156 RO_ROLEGROUP_ID /MRSS/T_RM_RO_GROUP_ROLE /MRSS/T_RM_CR_OBJID NUMC 8   0   Role Owner Group - Role  
157 RO_ROLEGROUP_NAME /MRSS/T_RM_RO_ROLEGROUP_NAME TEXT40 CHAR 40   0   RO Group Name -Role  
158 REJ_CODE /MRSS/T_RM_REJ_CODE /MRSS/RM_REJ_CODE CHAR 2   0   Candidate Rejection Code *
159 OBJID /MRSS/T_RMOR_SPGRP   CHAR 10   0   SP group  
160 SEARCH_GROUP_DESC /MRSS/T_RMOR_SP_GROUP_DESC TEXT40 CHAR 40   0   Searching Party Group Name  
161 SEARCH_PARTY_ID /MRSS/T_RMOR_SP_ID   NUMC 8   0   Searching Party ID  
162 SEARCH_PARTY_NAME /MRSS/T_RMOR_SP_NAME TEXT40 CHAR 40   0   Searching Party Name  
163 SFTBKD_DT /MRSS/T_RMOR_SFTBKD_DT DATUM DATS 8   0   Softbooked Date  
164 BCGRP /MRSS/T_RMOR_SPGRP   CHAR 10   0   SP group  
165 STAFFED_DAYS /MRSS/T_RM_STAFFED_DAYS DEC3_1 DEC 4   1   Staffed Days  
166 .INCLUDE       0   0    
History
Last changed by/on SAP  20141109 
SAP Release Created in 610