/MRSS/D_DEM_PLR SAP table for – Data required for planning-relevant items

Here we would like to draw your attention to /MRSS/D_DEM_PLR table in SAP. As we know it is being mainly used with the SAP PM-WOC (Maintenance Processing in PM) component which is coming under PM module (Plant Maintenance). /MRSS/D_DEM_PLR is a SAP standard transparent table used for storing Data required for planning-relevant items related data in SAP. It comes under the package /MRSS/SGD.

SAP /MRSS/D_DEM_PLR table

Table /MRSS/D_DEM_PLR technical data

Table/MRSS/D_DEM_PLR
Data storingData required for planning-relevant items
ModulePM
ComponentPM-WOC
SAP Package/MRSS/SGD
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /MRSS/D_DEM_PLR Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /MRSS/D_DEM_PLR table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is /MRSS/T_DEM_OBJECT_KEY
  • VAL_TO : To value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PLAN_FROM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PLAN_TO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • EARL_START
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LAT_START
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • EARL_END
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LAT_END
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SCHED_FROM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SCHED_TO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DURATION : Duration in Seconds
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • DURATION_UNIT
    Its data type is C (Character String) with field length 6
  • TOTAL_WORK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TOTAL_WORK_UNIT
    Its data type is C (Character String) with field length 6
  • UTIL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MULT_RES
    Its data type is N (Character String with Digits Only) with field length 6
  • STAT_REL
    Its data type is C (Character String) with field length 2
  • STRATEGY
    Its data type is C (Character String) with field length 20
  • PRE_ASSMT
    Its data type is C (Character String) with field length 2
  • IS_CAPACITIVE
    Its data type is C (Character String) with field length 2
  • IS_FIXED_DATE
    Its data type is C (Character String) with field length 2
  • GUID : 16 Byte UUID in 32 Characters (Hexadecimal Encoded)
    Its a key field. Its data type is X (Byte string) with field length 16
  • IS_DESIRED_DATE
    Its data type is C (Character String) with field length 2
  • IS_ARRANGE_DATE
    Its data type is C (Character String) with field length 2
  • IS_RESOURCE_FIX
    Its data type is C (Character String) with field length 2
  • REQ_PROFILE_GUID
    Its data type is X (Byte string) with field length 16
  • REQ_PROFILE_ID
    Its data type is C (Character String) with field length 20
  • PLANT
    Its data type is C (Character String) with field length 8
  • ACTIVITY_TYPE
    Its data type is C (Character String) with field length 12
  • TIME_RULE_ID
    Its data type is C (Character String) with field length 50
  • TIME_RULE_TYPE
    Its data type is C (Character String) with field length 6
  • RESTR_START_TYPE
    Its data type is C (Character String) with field length 2
  • RESTR_END_TYPE
    Its data type is C (Character String) with field length 2
  • RESTRICT_START
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • RESTRICT_END
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TEAM_PLANNING
    Its data type is C (Character String) with field length 2
  • FORCE_SINGLE_RES
    Its data type is C (Character String) with field length 2
  • SPARE_PARTS_REQ
    Its data type is C (Character String) with field length 2
  • SERVICE_AREA
    Its data type is X (Byte string) with field length 16
  • MULT_SLOTS
    Its data type is N (Character String with Digits Only) with field length 6
  • CONFIDENTIAL
    Its data type is C (Character String) with field length 2
  • PREP_PER_DAY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PREP_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • WRAP_UP_PER_DAY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WRAP_UP_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • TRAVEL_PER_DAY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TRAVEL_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • MOB_PER_DAY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MOB_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • PLVAR : Plan Version
    Its data type is C (Character String) with field length 4
  • DEMOB_PER_DAY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DEMOB_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • TRATIME_PER_DAY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TRV_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • PLANNING_STATUS
    Its data type is C (Character String) with field length 4
  • ASSIGNMENT_COUNT
    Its data type is X (Byte string) with field length 2
  • REMAINING_DUR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • REMAIN_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • TIME_ZONE : Address time zone
    Its data type is C (Character String) with field length 12
  • OTYPE : Object Type
    Its data type is C (Character String) with field length 4
  • OBJID : Accrual Object (Internal Display in Form of a GUID)
    Its data type is N (Character String with Digits Only) with field length 16
  • VAL_FROM : From Value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8