| 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 | * | MANDT | Allow NULL? |
| 2 | DEMAND_GUID | GUID | varbinary | 16 | 0 | RAW | | No | | /MRSS/T_GUID | |
| 3 | PLVAR | Plan Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778P | PLVAR | Allow NULL? |
| 4 | OTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778O | OTYPE | Allow NULL? |
| 5 | OBJID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | OBJEKTID | Allow NULL? |
| 6 | VAL_FROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 7 | VAL_TO | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 8 | PLAN_FROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 9 | PLAN_TO | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 10 | EARL_START | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 11 | LAT_START | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 12 | EARL_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 13 | LAT_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 14 | SCHED_FROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 15 | SCHED_TO | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 16 | DURATION | Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_DURATION | |
| 17 | DURATION_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_DURATION_UNIT | Allow NULL? |
| 18 | TOTAL_WORK | Total Work | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_TOTAL_WORK | |
| 19 | TOTAL_WORK_UNIT | Unit of Total Work of Operation | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_TOTAL_WORK_UNIT | Allow NULL? |
| 20 | UTIL | Resource Utilization | decimal | 3 | 0 | DEC | ((0)) | Yes | | /MRSS/T_UTILISATION | |
| 21 | MULT_RES | Number of Persons | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /MRSS/T_SGE_MULT_RES | Allow NULL? |
| 22 | STAT_REL | Boolean Variable | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_BOOLEAN | Allow NULL? |
| 23 | STRATEGY | Scheduling strategy | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SCHEDULE_STRAT | Allow NULL? |
| 24 | PRE_ASSMT | Boolean Variable | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_BOOLEAN | Allow NULL? |
| 25 | IS_CAPACITIVE | Capacitive planning allowed for demand? | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_IS_CAPACITIVE | Allow NULL? |
| 26 | IS_FIXED_DATE | Does demand contain fixed date specified by customer? | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_IS_FIXED_DATE | Allow NULL? |
| 27 | IS_DESIRED_DATE | Does demand contain customer's desired date? | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_IS_DESIRED_DATE | Allow NULL? |
| 28 | IS_ARRANGE_DATE | Agreement on dates (with customer) required? | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_IS_ARRANGE_DATE | Allow NULL? |
| 29 | IS_RESOURCE_FIX | Does demand contain resource specified by customer? | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_IS_FIXED_RESOURCE | Allow NULL? |
| 30 | REQ_PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_PROFILE_GUID | |
| 31 | REQ_PROFILE_ID | Profile key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_REQUID | Allow NULL? |
| 32 | PLANT | Maintenance planning plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /MRSS/T_PM_PLANT | Allow NULL? |
| 33 | ACTIVITY_TYPE | Maintenance activity type (operations) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | /MRSS/T_PM_DEM_ACTIVITY_TYPE | Allow NULL? |
| 34 | TIME_RULE_ID | Time Rule Id | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_TIME_RULE_ID | Allow NULL? |
| 35 | TIME_RULE_TYPE | Time Rule Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGE_TIME_RULE_TYPE | Allow NULL? |
| 36 | RESTR_START_TYPE | Demand Start Restriction | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_RESTRICT_START | Allow NULL? |
| 37 | RESTR_END_TYPE | Demand End Restriction | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_RESTRICT_END | Allow NULL? |
| 38 | RESTRICT_START | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 39 | RESTRICT_END | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 40 | TEAM_PLANNING | Team Planning flag for Demand | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGE_TEAM_PLANNING | Allow NULL? |
| 41 | FORCE_SINGLE_RES | Indicator for Forcing a Single Resource | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGE_FORCE_SINGLE_RES | Allow NULL? |
| 42 | SPARE_PARTS_REQ | Boolean Variable | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_BOOLEAN | Allow NULL? |
| 43 | SERVICE_AREA | GUID | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_GUID | |
| 44 | MULT_SLOTS | Multiple Slots For a Demand | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /MRSS/T_SGE_MULT_SLOTS | Allow NULL? |
| 45 | CONFIDENTIAL | Demand Confidentiality | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_IS_CONFIDENTIAL | Allow NULL? |
| 46 | PREP_PER_DAY | Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_DURATION | |
| 47 | PREP_DUR_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_DURATION_UNIT | Allow NULL? |
| 48 | WRAP_UP_PER_DAY | Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_DURATION | |
| 49 | WRAP_UP_DUR_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_DURATION_UNIT | Allow NULL? |
| 50 | TRAVEL_PER_DAY | Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_DURATION | |
| 51 | TRAVEL_DUR_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_DURATION_UNIT | Allow NULL? |
| 52 | MOB_PER_DAY | Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_DURATION | |
| 53 | MOB_DUR_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_DURATION_UNIT | Allow NULL? |
| 54 | DEMOB_PER_DAY | Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_DURATION | |
| 55 | DEMOB_DUR_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_DURATION_UNIT | Allow NULL? |
| 56 | TRATIME_PER_DAY | Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_DURATION | |
| 57 | TRV_DUR_UNIT | Unit for the Transaction Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_DURATION_UNIT | Allow NULL? |
| 58 | PLANNING_STATUS | Planning Status of the Demand | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_PLANNING_STATUS | Allow NULL? |
| 59 | ASSIGNMENT_COUNT | Number of Assignments for the Demand | smallint | 5 | 0 | INT2 | ((0)) | Yes | | /MRSS/T_DEM_ASSIGNMENT_COUNTER | |
| 60 | REMAINING_DUR | Remaining Work of Operation | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_SGE_REMAIN_DUR | |
| 61 | REMAIN_DUR_UNIT | Unit of Remaining Work of Operation | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_SGE_REMAIN_DUR_UNIT | Allow NULL? |
| 62 | TIME_ZONE | Time Zone of Demand | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | /MRSS/T_DEM_TIMEZONE | Allow NULL? |
