CMPB_MAP SAP table for – Conversion Table CAIMPAIGN CRM <> CMPGN_ID

Here we would like to draw your attention to CMPB_MAP table in SAP. As we know it is being mainly used with the SAP SD-MD (Master Data in SD) component which is coming under SD module (Sales & Distribution). CMPB_MAP is a SAP standard transparent table used for storing Conversion Table CAIMPAIGN CRM <> CMPGN_ID related data in SAP. It comes under the package CMPB.

SAP CMPB_MAP table

Table CMPB_MAP technical data

TableCMPB_MAP
Data storingConversion Table CAIMPAIGN CRM <> CMPGN_ID
ModuleSD
ComponentSD-MD
SAP PackageCMPB
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • END_DATE : Evaluation Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PRIORITY : Priority
    Its data type is N (Character String with Digits Only) with field length 3
  • IS_EXCLUSIVE
    Its data type is C (Character String) with field length 1
  • VALIDATION_STAT
    Its data type is C (Character String) with field length 1
  • OBJECT_TYPE : Alert configuration: object type
    Its data type is C (Character String) with field length 3
  • CAMPAIGN
    Its a key field. Its data type is X (Byte string) with field length 16
  • CMPGN_ID : Campaign ID
    Its data type is C (Character String) with field length 10
  • CMPGN_EXTID
    Its data type is C (Character String) with field length 24
  • LOGSYS : Logical system
    Its data type is C (Character String) with field length 10
  • EXCHANGE_STATUS
    Its data type is C (Character String) with field length 1
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is CMPB_ATTR
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CMPB_MAP_ATTR
  • START_DATE : Date of Difference Table Quarterly Comparison Entry
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8