CMX_XSR_DB_VERS SAP table for – Standard Execution Step Repository: Versions

Here we would like to draw your attention to CMX_XSR_DB_VERS 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_XSR_DB_VERS is a SAP standard transparent table used for storing Standard Execution Step Repository: Versions related data in SAP. It comes under the package CMX_XSR.

SAP CMX_XSR_DB_VERS table

Table CMX_XSR_DB_VERS technical data

TableCMX_XSR_DB_VERS
Data storingStandard Execution Step Repository: Versions
ModulePP
ComponentPP-PI
SAP PackageCMX_XSR
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CMX_XSR_DB_VERS 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_XSR_DB_VERS table.

  • CLNT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • TIMESTAMP : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 11
  • VERSION_ID
    Its a key field. Its data type is C (Character String) with field length 22
  • ROOT_ID
    Its data type is C (Character String) with field length 22
  • ITEM_ID : Unique ID
    Its data type is C (Character String) with field length 22
  • VERS_NAME
    Its data type is C (Character String) with field length 4
  • DATE_FROM : From Date of an Entry
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DATE_TO : To Date of Accrual Item
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • STATUS_OBJ_ID
    Its data type is X (Byte string) with field length 16
  • UNAME : User Name
    Its data type is C (Character String) with field length 12