CMX_XS_DB_HREL SAP table for – XSteps: Links to Historical Objects (Relationships)

Here we would like to draw your attention to CMX_XS_DB_HREL table in SAP. As we know it is being mainly used with the SAP PP-PI (Production Planning for Process Industries – PP) component which is coming under PP module (Production Planning). CMX_XS_DB_HREL is a SAP standard transparent table used for storing XSteps: Links to Historical Objects (Relationships) related data in SAP. It comes under the package CMX_XS.

SAP CMX_XS_DB_HREL table

Table CMX_XS_DB_HREL technical data

TableCMX_XS_DB_HREL
Data storingXSteps: Links to Historical Objects (Relationships)
ModulePP
ComponentPP-PI
SAP PackageCMX_XS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CMX_XS_DB_HREL 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 CMX_XS_DB_HREL table.

  • CLNT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is CMX_XS_W_HISTREL_DB_KEY
  • OID
    Its a key field. Its data type is C (Character String) with field length 22
  • IDX : Securities Index
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • CHILD_NID
    Its data type is C (Character String) with field length 22