| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | REGION | Super Region per Country | nvarchar | 8 | 0 | CHAR | (N' ') | No | /MRSS/C_RM_SR | /MRSS/T_RM_PRQ_SUREG | Allow NULL? |
| 3 | BROADCAST_TARGET | Broadcast Targets | nvarchar | 5 | 0 | CHAR | (N' ') | No | /MRSS/C_RM_BT | /MRSS/T_RM_BROADCAST_TARGET | Allow NULL? |
| 4 | RESP_RM_ORG | Responsible RM Org. ID | nvarchar | 2 | 0 | NUMC | (N'00') | No | /MRSS/C_RM_ORG | /MRSS/T_RM_RESP_RM_ORG | Allow NULL? |
| 5 | REQUEST_TYPE | Request Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | /MRSS/C_RM_RT | /MRSS/T_RM_REQUEST_TYPE | Allow NULL? |
| 6 | ACCESS_SEQUENCE | Access Sequence for determining RM Group | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | /MRSS/T_RM_ACCESS_SEQ | Allow NULL? |
| 7 | LINE_OF_BUSINESS | Requesting Line of Business ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | /MRSS/C_RM_LOB | /MRSS/T_RM_REQUEST_LOB | Allow NULL? |
| 8 | SALES_PC | Sales Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CEPC | /MRSS/T_RM_SALES_PC | Allow NULL? |
| 9 | DELIVERY_PC | Delivery Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CEPC | /MRSS/T_RM_DELIVERY_PC | Allow NULL? |
| 10 | REQ_LEVEL | Request Level (header, role) | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RM_REQ_LEVEL | Allow NULL? |
| 11 | DEFAULT_TO_ROLE | Default Header to Roles | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RM_DEFAULT_TO_ROLE | Allow NULL? |
| 12 | RM_LEVEL | Request Owner or Searching Party | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RM_LEVEL | Allow NULL? |
| 13 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNNR | Allow NULL? |
| 14 | MASTERCODE | Attribute 3 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVK3 | KATR3 | Allow NULL? |
| 15 | COUNTRY | Project Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | /MRSS/T_RM_PROJ_COUNTRY | Allow NULL? |
| 16 | STATE | State | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | /MRSS/T_RM_STATE | Allow NULL? |
| 17 | PACE_SOLUTION | Pace Solution Profile | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | /MRSS/T_RM_PACE_SOLUTION | Allow NULL? |
| 18 | PACE_SOLUTION_LL | Include Lower Levels of PACE profile | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RM_INCLUDE_LOWER_LEVEL | Allow NULL? |
| 19 | PACE_INDUSTRY | Pace Industry Profile | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | /MRSS/T_RM_PACE_INDUSTRY | Allow NULL? |
| 20 | PACE_INDUSTRY_LL | Include Lower Levels of PACE profile | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RM_INCLUDE_LOWER_LEVEL | Allow NULL? |
| 21 | PACE_COMPETENCE | Pace Competence Profile | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | /MRSS/T_RM_PACE_COMPETENCE | Allow NULL? |
| 22 | PACE_COMP_LL | Include Lower Levels of PACE profile | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RM_INCLUDE_LOWER_LEVEL | Allow NULL? |
| 23 | REQUESTER_ID | Requester | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | /MRSS/T_RM_REQUESTER | Allow NULL? |
| 24 | RM_GROUP | Resource planning nodes | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | /MRSS/T_RM_PLAN_STRUCT_ID | Allow NULL? |
| 25 | RM_PERSON | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 26 | PROJECT_SERVICE | Project Service ID | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | /MRSS/C_RM_PRSRV | /MRSS/T_RM_PROJ_SERVICE | Allow NULL? |