MCH_SELECT SAP table for – Interface: Generalized Selection Criteria

Here we would like to draw your attention to MCH_SELECT table in SAP. As we know it is being mainly used with the SAP BW-WHM (Warehouse Management in BW) component which is coming under BW module (Business Warehouse). MCH_SELECT is a SAP standard transp table used for storing Interface: Generalized Selection Criteria related data in SAP. It comes under the package RSBCMD.

SAP MCH_SELECT table

Table MCH_SELECT technical data

TableMCH_SELECT
Data storingInterface: Generalized Selection Criteria
ModuleBW
Sub ModuleBW-WHM-DST
SAP PackageRSBCMD
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_BW
Table CategoryTRANSP

SAP MCH_SELECT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in MCH_SELECT table.

  • GUID25 : BW Generation tool: GUID in compressed form (CHAR25)
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • INTERVALNUMBER : Field name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • SIGN : Selection criteria: SIGN
    Its data type is CHAR (Character String) with field length 1
  • LOGOPERATOR : Selection criteria: OPTION
    Its data type is CHAR (Character String) with field length 2
  • LOWERLIMIT : Selection criteria: From value
    Its data type is CHAR (Character String) with field length 45
  • UPPERLIMIT : Selection criteria: To value
    Its data type is CHAR (Character String) with field length 45