/MRSS/D_DEM_REL SAP table for – Relationships Between Demand Items

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

SAP /MRSS/D_DEM_REL table

Table /MRSS/D_DEM_REL technical data

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

SAP /MRSS/D_DEM_REL 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_REL 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
  • HEADER
    Its data type is X (Byte string) with field length 16
  • ORIGIN : Record Creation Type (Difference Table)
    Its data type is C (Character String) with field length 2
  • EXPLICIT_RELATN
    Its data type is C (Character String) with field length 2
  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • GUID : 16 Byte UUID in 32 Characters (Hexadecimal Encoded)
    Its a key field. Its data type is X (Byte string) with field length 16
  • PRED_GUID
    Its data type is X (Byte string) with field length 16
  • SUCC_GUID
    Its data type is X (Byte string) with field length 16
  • REL_TYPE : Relation type
    Its data type is C (Character String) with field length 2
  • LINE_OFFSET
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LINE_OFFSET_UNIT
    Its data type is C (Character String) with field length 6