CMCDT_2T SAP table for – Master Data Texts for Subcategory

Here we would like to draw your attention to CMCDT_2T table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). CMCDT_2T is a SAP standard transp table used for storing Master Data Texts for Subcategory related data in SAP. It comes under the package RS_AA_CM.

SAP CMCDT_2T table

Table CMCDT_2T technical data

TableCMCDT_2T
Data storingMaster Data Texts for Subcategory
ModuleBW
Sub ModuleBW-BCT-CPG-CMC
SAP PackageRS_AA_CM
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • HIER_ID : Hierarchy ID
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • CDT2 : Subcategory
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • SPRAS : Language Key
    Its a key field. Its data type is LANG (Language key character with length 1) with field length 1
  • TEXT : Description
    Its data type is CHAR (Character String) with field length 20