/MRSS/D_DEM_H SAP table for – Complex Demand

Here we would like to draw your attention to /MRSS/D_DEM_H 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_H is a SAP standard transparent table used for storing Complex Demand related data in SAP. It comes under the package /MRSS/SGD.

SAP /MRSS/D_DEM_H table

Table /MRSS/D_DEM_H technical data

Table/MRSS/D_DEM_H
Data storingComplex Demand
ModulePM
ComponentPM-WOC
SAP Package/MRSS/SGD
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /MRSS/D_DEM_H 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_H 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
  • BASIC_START
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BASIC_END
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SCHED_START
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SCHED_END : Ind.: Purchase requisition at activity finish date
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ACTUAL_START
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ACTUAL_END
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PLVAR : Plan Version
    Its data type is C (Character String) with field length 4
  • 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
  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • STAT_ERR
    Its data type is C (Character String) with field length 2
  • STAT_COMPL
    Its data type is C (Character String) with field length 2
  • PROBABILITY
    Its data type is C (Character String) with field length 6
  • ORIG_ORDER_TYPE
    Its data type is C (Character String) with field length 8
  • PLANT
    Its data type is C (Character String) with field length 8
  • ACTIVITY_TYPE
    Its data type is C (Character String) with field length 6
  • CREATED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 24
  • CREATED_AT : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CHANGED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 24
  • CHANGED_AT : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • GUID : 16 Byte UUID in 32 Characters (Hexadecimal Encoded)
    Its a key field. Its data type is X (Byte string) with field length 16
  • WORKCENTER_ID : 30 Characters
    Its data type is N (Character String with Digits Only) with field length 16
  • WORKCENTER_TYPE
    Its data type is C (Character String) with field length 4
  • WORKCENTER_PLANT
    Its data type is C (Character String) with field length 8
  • SCHEDULING_TYPE
    Its data type is C (Character String) with field length 2
  • PLANNING_STATUS
    Its data type is C (Character String) with field length 4
  • HEADER
    Its data type is X (Byte string) with field length 16
  • PARENT : Internal: Node ID
    Its data type is X (Byte string) with field length 16
  • DEM_TYPE
    Its data type is C (Character String) with field length 8
  • ID : Demo hierarchy: Node ID
    Its data type is C (Character String) with field length 50
  • DESCRIPTION : Alert configuration: data element for text
    Its data type is C (Character String) with field length 80