CMCPMBD SAP table for – Market Structure of External Data Providers

Here we would like to draw your attention to CMCPMBD 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). CMCPMBD is a SAP standard transp table used for storing Market Structure of External Data Providers related data in SAP. It comes under the package RS_BCT_CMCP.

SAP CMCPMBD table

Table CMCPMBD technical data

TableCMCPMBD
Data storingMarket Structure of External Data Providers
ModuleBW
Sub ModuleBW-BCT-CPG-CMC
SAP PackageRS_BCT_CMCP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentBI_CONT
Table CategoryTRANSP

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

  • EDP_MBD : Competition
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • CMCP_MKT : Competition
    Its data type is CHAR (Character String) with field length 4
  • CMCP_COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • CMCP_REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • CMCP_CPROF1 : Consumer Income Structure
    Its data type is CHAR (Character String) with field length 4
  • CMCP_CPROF2 : Household Size
    Its data type is CHAR (Character String) with field length 4
  • CMCP_CPROF3 : Age of Head of Household
    Its data type is CHAR (Character String) with field length 4
  • CMCP_CPROF4 : Life Cycle
    Its data type is CHAR (Character String) with field length 4