CMX_XSR_DB_ITEM SAP table for – Standard Execution Step Repository: Items

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

SAP CMX_XSR_DB_ITEM table

Table CMX_XSR_DB_ITEM technical data

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

SAP CMX_XSR_DB_ITEM 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_ITEM table.

  • CLNT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • LANGU : Language ID
    Its data type is C (Character String) with field length 1
  • TEMPLATE_ROOT_ID
    Its data type is C (Character String) with field length 22
  • REF_INDICATOR
    Its data type is C (Character String) with field length 1
  • UNAME : User Name
    Its data type is C (Character String) with field length 12
  • 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
  • ITEM_ID : Unique ID
    Its a key field. Its data type is C (Character String) with field length 22
  • PARENT_FOLDER_ID
    Its data type is C (Character String) with field length 22
  • .INCLU-RPS
    Its include structure/component is is CMX_XS_W_REPOSITORY_NAME
  • NAMESPACERPS
    Its data type is C (Character String) with field length 3
  • REPOSITORYRPS
    Its data type is C (Character String) with field length 3
  • LOCATION : Logical Destination (Specified in Function Call)
    Its data type is C (Character String) with field length 20
  • STEXT : Demo name
    Its data type is C (Character String) with field length 40
  • MTEXT
    Its data type is g (String of variable length – ABAP type STRING) with field length 8