SAP ABAP View /MRSS/V_DEM_ITEM (Subobjects of demand items)
Hierarchy
☛
MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
⤷
PM-WOC-MO (Application Component) Maintenance Orders
⤷
/MRSS/SGD (Package) Planning Board Demand
MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net⤷
PM-WOC-MO (Application Component) Maintenance Orders⤷
/MRSS/SGD (Package) Planning Board Demand
Basic Data
| View Type | D | Database View |
| Database View | /MRSS/V_DEM_ITEM | |
| Short Description | Subobjects of demand items | |
| Root table | /MRSS/D_DEM_PLR | Data required for planning-relevant items |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /MRSS/D_DEM_PLR |
/MRSS/D_DEM_PLR | ||
| 2 | /MRSS/D_DEM_PLRS |
|||
| 3 | /MRSS/D_DEM_INFO |
|||
| 4 | /MRSS/D_DEM_TOOL |
|||
| 5 | /MRSS/D_DEM_MATE |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /MRSS/D_DEM_PLR |
GUID | JL | EQ | 0 | 0 | ||||
| 2 | /MRSS/D_DEM_PLRS |
GUID | JR | EQ | AND | 0 | 0 | |||
| 3 | /MRSS/D_DEM_PLR |
GUID | JL | EQ | 0 | 0 | ||||
| 4 | /MRSS/D_DEM_INFO |
GUID | JR | EQ | AND | 0 | 0 | |||
| 5 | /MRSS/D_DEM_PLR |
GUID | JL | EQ | 0 | 0 | ||||
| 6 | /MRSS/D_DEM_TOOL |
GUID | JR | EQ | AND | 0 | 0 | |||
| 7 | /MRSS/D_DEM_PLR |
GUID | JL | EQ | 0 | 0 | ||||
| 8 | /MRSS/D_DEM_MATE |
GUID | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  CLIENT |
/MRSS/D_DEM_PLR |
CLIENT | MANDT | Client | |||
| 2 | GUID |
/MRSS/D_DEM_PLR |
GUID | /MRSS/T_GUID | GUID | |||
| 3 | PLVAR |
/MRSS/D_DEM_PLR |
PLVAR | PLVAR | Plan Version | |||
| 4 | OTYPE |
/MRSS/D_DEM_PLR |
OTYPE | OTYPE | Object Type | |||
| 5 | OBJID |
/MRSS/D_DEM_PLR |
OBJID | OBJEKTID | Object ID | |||
| 6 | VAL_FROM |
/MRSS/D_DEM_PLR |
VAL_FROM | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 7 | VAL_TO |
/MRSS/D_DEM_PLR |
VAL_TO | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 8 | PLAN_FROM |
/MRSS/D_DEM_PLR |
PLAN_FROM | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 9 | PLAN_TO |
/MRSS/D_DEM_PLR |
PLAN_TO | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 10 | EARL_START |
/MRSS/D_DEM_PLR |
EARL_START | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 11 | LAT_START |
/MRSS/D_DEM_PLR |
LAT_START | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 12 | EARL_END |
/MRSS/D_DEM_PLR |
EARL_END | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 13 | LAT_END |
/MRSS/D_DEM_PLR |
LAT_END | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 14 | SCHED_FROM |
/MRSS/D_DEM_PLR |
SCHED_FROM | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 15 | SCHED_TO |
/MRSS/D_DEM_PLR |
SCHED_TO | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 16 | DURATION |
/MRSS/D_DEM_PLR |
DURATION | /MRSS/T_SGE_DURATION | Duration | |||
| 17 | DURATION_UNIT |
/MRSS/D_DEM_PLR |
DURATION_UNIT | /MRSS/T_SGE_DURATION_UNIT | Unit for the Transaction Duration | |||
| 18 | UTIL |
/MRSS/D_DEM_PLR |
UTIL | /MRSS/T_UTILISATION | Resource Utilization | |||
| 19 | MULT_RES |
/MRSS/D_DEM_PLR |
MULT_RES | /MRSS/T_SGE_MULT_RES | Number of Persons | |||
| 20 | STAT_REL |
/MRSS/D_DEM_PLR |
STAT_REL | /MRSS/T_BOOLEAN | Boolean Variable | |||
| 21 | STRATEGY |
/MRSS/D_DEM_PLR |
STRATEGY | /MRSS/T_SCHEDULE_STRAT | Scheduling strategy | |||
| 22 | PRE_ASSMT |
/MRSS/D_DEM_PLR |
PRE_ASSMT | /MRSS/T_BOOLEAN | Boolean Variable | |||
| 23 | IS_CAPACITIVE |
/MRSS/D_DEM_PLR |
IS_CAPACITIVE | /MRSS/T_DEM_IS_CAPACITIVE | Capacitive planning allowed for demand? | |||
| 24 | IS_FIXED_DATE |
/MRSS/D_DEM_PLR |
IS_FIXED_DATE | /MRSS/T_DEM_IS_FIXED_DATE | Does demand contain fixed date specified by customer? | |||
| 25 | IS_DESIRED_DATE |
/MRSS/D_DEM_PLR |
IS_DESIRED_DATE | /MRSS/T_DEM_IS_DESIRED_DATE | Does demand contain customer's desired date? | |||
| 26 | IS_ARRANGE_DATE |
/MRSS/D_DEM_PLR |
IS_ARRANGE_DATE | /MRSS/T_DEM_IS_ARRANGE_DATE | Agreement on dates (with customer) required? | |||
| 27 | IS_RESOURCE_FIX |
/MRSS/D_DEM_PLR |
IS_RESOURCE_FIX | /MRSS/T_DEM_IS_FIXED_RESOURCE | Does demand contain resource specified by customer? | |||
| 28 | REQ_PROFILE_GUID |
/MRSS/D_DEM_PLR |
REQ_PROFILE_GUID | /MRSS/T_PROFILE_GUID | Profile GUID | |||
| 29 | PRIORITY |
/MRSS/D_DEM_PLRS |
PRIORITY | /MRSS/T_SGE_PRIORITY | Priority of an Operation | |||
| 30 | MODEL |
/MRSS/D_DEM_PLRS |
MODEL | /MRSS/T_WL_MODEL | Model | |||
| 31 | BEG_SLA |
/MRSS/D_DEM_PLRS |
BEG_SLA | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 32 | END_SLA |
/MRSS/D_DEM_PLRS |
END_SLA | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
| 33 | PARTNER_NO |
/MRSS/D_DEM_INFO |
PARTNER_NO | BU_PARTNER | Business Partner Number | |||
| 34 | ORDERED_PRODUCT |
/MRSS/D_DEM_INFO |
PRODUCT | /MRSS/T_ORDERED_PROD | Product Name Entered | |||
| 35 | KUNNR |
/MRSS/D_DEM_INFO |
KUNNR | /MRSS/T_DEM_KUNNR | Customer Number | |||
| 36 | PROBABILITY |
/MRSS/D_DEM_INFO |
PROBABILITY | /MRSS/T_DEM_PROBABILITY | Demand Probability | |||
| 37 | SUPERVISOR |
/MRSS/D_DEM_INFO |
SUPERVISOR | /MRSS/T_DEM_SUPERVISOR | Site supervisor indicator of demand | |||
| 38 | FOUND_RESOURCES |
/MRSS/D_DEM_INFO |
FOUND_RESOURCES | /MRSS/T_DEM_FOUND_RESOURCES | Resources Found for Demand | |||
| 39 | PRODUCT |
/MRSS/D_DEM_TOOL |
PRODUCT | /MRSS/T_GUID_32 | GUID in CHAR32 format | |||
| 40 | PRODUCT_KIND |
/MRSS/D_DEM_TOOL |
PRODUCT_KIND | CHAR1 | Single-Character Flag | |||
| 41 | AVAIL_DATE |
/MRSS/D_DEM_MATE |
AVAIL_DATE | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20141109 |
| SAP Release Created in | 195 |
