| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | CO_AUFPL | Allow NULL? |
| 3 | APLZL | General counter for order | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | AFVC | CO_APLZL | Allow NULL? |
| 4 | SLWID | Key word ID for user-defined fields | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | TCN00 | SLWID | Allow NULL? |
| 5 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | USRCHAR20 | Allow NULL? |
| 6 | USR01 | User field with 20 characters | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | USRCHAR20 | Allow NULL? |
| 7 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USRCHAR10 | Allow NULL? |
| 8 | USR03 | User field with 10 characters | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USRCHAR10 | Allow NULL? |
| 9 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | USRQUAN13 | |
| 10 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | USRUNIT | Allow NULL? |
| 11 | USR05 | User field for quantity (length 10.3) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | USRQUAN13 | |
| 12 | USE05 | User field: Unit for quantity fields | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | USRUNIT | Allow NULL? |
| 13 | USR06 | User-defined field for values (length 10,3) | decimal | 13 | 3 | CURR | ((0)) | Yes | | USRCURR13 | |
| 14 | USE06 | User field: Unit for value fields | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | USRCUKY | Allow NULL? |
| 15 | USR07 | User-defined field for values (length 10,3) | decimal | 13 | 3 | CURR | ((0)) | Yes | | USRCURR13 | |
| 16 | USE07 | User field: Unit for value fields | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | USRCUKY | Allow NULL? |
| 17 | USR08 | User field for date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | USRDATE | Allow NULL? |
| 18 | USR09 | User field for date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | USRDATE | Allow NULL? |
| 19 | USR10 | User-defined field: Indicator for reports | char | 1 | 0 | CHAR | (N' ') | Yes | | USRFLAG | Allow NULL? |
| 20 | USR11 | User-defined field: Indicator for reports | char | 1 | 0 | CHAR | (N' ') | Yes | | USRFLAG | Allow NULL? |
| 21 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8JV | JV_NAME | Allow NULL? |
| 22 | RECID | Recovery Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JJ | JV_RECIND | Allow NULL? |
| 23 | ETYPE | Equity type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T8JG | JV_ETYPE | Allow NULL? |
| 24 | JV_OTYPE | Joint Venture Object Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JV_OTYPE | Allow NULL? |
| 25 | JV_JIBCL | JIB/JIBE Class | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T8J6A | JV_JIBCL | Allow NULL? |
| 26 | JV_JIBSA | JIB/JIBE Subclass A | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T8J6C | JV_JIBSA | Allow NULL? |
| 27 | JV_OCO | JV original cost object | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_OR_CO | Allow NULL? |
| 28 | DUMMY_CI_AFVU | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 29 | SPARAMETER1 | Scheduling Parameters for External Scheduling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSCHEDULEPARAM1 | SPARAMETER | Allow NULL? |
| 30 | SPARAMETER2 | Scheduling Parameters for External Scheduling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSCHEDULEPARAM2 | SPARAMETER | Allow NULL? |
| 31 | SPARAMETER3 | Scheduling Parameters for External Scheduling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSCHEDULEPARAM3 | SPARAMETER | Allow NULL? |
| 32 | /MRSS/ID_PROFILE | Requirements Profile Was Changed Manually | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_REQU_UPD | Allow NULL? |
| 33 | /MRSS/PROF_KEY | Profile Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RSG_REQUID | Allow NULL? |
| 34 | /MRSS/PROF_GUID | Character field, length 32 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CHAR32 | Allow NULL? |
| 35 | /MRSS/ACT_TYPE | Process variant | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_ACTIVITY_TYPE | Allow NULL? |
| 36 | /MRSS/ORDER_PROB | Order probability in percent | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_ORDER_PROB | Allow NULL? |
| 37 | /MRSS/INIT_DONE | Internal initialization carried out once | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_INIT_DONE | Allow NULL? |
| 38 | /MRSS/DATACHANGE | Data was changed in the controls on the user screen | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_USCREENCTL_DATACHANGED | Allow NULL? |
| 39 | /MRSS/DEM_COUNT | Counter for Demands in Operation | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /MRSS/T_DEM_COUNT | Allow NULL? |
| 40 | /MRSS/SUPERV_CNT | Number of Site Supervisors | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RAP_SUPERVISOR_COUNT | Allow NULL? |
| 41 | /MRSS/RULE_ID | Time Rule Id | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RSG_TIME_RULE_ID | Allow NULL? |
| 42 | /MRSS/SALES_ORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 43 | /MRSS/REFF_RCNT | Determination of Remaining Demand: No. of Resources | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /MRSS/T_REM_EFFORT_RES_COUNT | Allow NULL? |
| 44 | /MRSS/REFF_E_BEG | Time stamp: start | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | /MRSS/T_TIMESTAMP_BEGIN | Allow NULL? |
| 45 | /MRSS/REFF_E_END | Time stamp: end | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | /MRSS/T_TIMESTAMP_END | Allow NULL? |
| 46 | /MRSS/REFF_L_BEG | Time stamp: start | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | /MRSS/T_TIMESTAMP_BEGIN | Allow NULL? |
| 47 | /MRSS/REFF_L_END | Time stamp: end | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | /MRSS/T_TIMESTAMP_END | Allow NULL? |
| 48 | /MRSS/RELEVANT | Operation Set as MRS-Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RELEVANT_FOR_MRS | Allow NULL? |
| 49 | /MRSS/TEAM_PLAN | Team Planning flag for Demand | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RSG_TEAM_PLANNING | Allow NULL? |
| 50 | /MRSS/SINGL_RES | Combine Operations and Assign Same Resource | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RSG_FORCE_SINGLE_RES | Allow NULL? |
| 51 | /MRSS/TO_BEGDAT | Field of type DATS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATS | Allow NULL? |
| 52 | /MRSS/TO_BEGTIM | Field of type TIMS | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TIMS | Allow NULL? |
| 53 | /MRSS/TO_ENDDAT | Field of type DATS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATS | Allow NULL? |
| 54 | /MRSS/TO_ENDTIM | Field of type TIMS | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TIMS | Allow NULL? |
| 55 | /MRSS/TO_DURAT | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHAR10 | Allow NULL? |
| 56 | /MRSS/TO_DUNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 57 | /MRSS/TO_DISTAN | 19 Characters | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CHAR19 | Allow NULL? |
| 58 | /MRSS/TO_MANUAL | Boolean Variable | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RSG_BOOLEAN | Allow NULL? |
| 59 | /MRSS/FR_BEGDAT | Field of type DATS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATS | Allow NULL? |
| 60 | /MRSS/FR_BEGTIM | Field of type TIMS | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TIMS | Allow NULL? |
| 61 | /MRSS/FR_ENDDAT | Field of type DATS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATS | Allow NULL? |
| 62 | /MRSS/FR_ENDTIM | Field of type TIMS | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TIMS | Allow NULL? |
| 63 | /MRSS/FR_DURAT | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHAR10 | Allow NULL? |
| 64 | /MRSS/FR_DUNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 65 | /MRSS/FR_DISTAN | 19 Characters | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CHAR19 | Allow NULL? |
| 66 | /MRSS/FR_MANUAL | Boolean Variable | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_RSG_BOOLEAN | Allow NULL? |
| 67 | ILART_OP | Maintenance activity type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | ILA | Allow NULL? |
| 68 | FERC_IND | Regulatory indicator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FERC_C7 | FE_IND | Allow NULL? |
