SAP CMPB_MAP Conversion Table CAIMPAIGN CRM <> CMPGN_ID Table data and field list

CMPB_MAP is a standard SAP Table which is used to store Conversion Table CAIMPAIGN CRM <> CMPGN_ID data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMPB_MAP table consists of various fields, each holding specific information or linking keys about Conversion Table CAIMPAIGN CRM <> CMPGN_ID data available in SAP. These include CAMPAIGN (Generic project planning: GUID from external R/3 system), CMPGN_ID (Campaign ID), CMPGN_EXTID (Campaign (External ID)), LOGSYS (Logical system)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMPB_MAP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMPB_MAP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMPB_MAP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
CAMPAIGNGeneric project planning: GUID from external R/3 system CGPL_GUID16_R3RAW16SYSUUID
CMPGN_IDCampaign ID CMPGN_ID_R3CHAR10CMPGN_ID_R3CMPGN_IDH_CMPGN_ID
CMPGN_EXTIDCampaign (External ID) CMPGN_EXTID_R3CHAR24CMPGN_EXTID_R3
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
EXCHANGE_STATUSData Exchange: Campaign Status CMPGN_EXCHANGE_STATUSCHAR1CMPGN_EXCHANGE_STATUS
.INCLU--AP 0
START_DATEProject planned start date PS_PLFAZDATS8DATUM
END_DATEProject planned finish date PS_PLSEZDATS8DATUM
PRIORITYPriority CGPL_PRIORITYNUMC3NUMC3
IS_EXCLUSIVECampaigns: Exclusive Campaign CMPGN_EXCLUSIVECHAR1CMPGN_EXCLUSIVE
VALIDATION_STATStatus of a Campaign CMPGN_VALIDATION_STATUSCHAR1CMPGN_VALIDATION_STATUS
OBJECT_TYPEObject Type in Project Planning CGPL_OBJECT_TYPECHAR3CHAR3

Key field Non-key field



How do I retrieve data from SAP table CMPB_MAP using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMPB_MAP to SELECT all data from the table
DATA: WA_CMPB_MAP TYPE CMPB_MAP.

SELECT SINGLE *
FROM CMPB_MAP
INTO CORRESPONDING FIELDS OF WA_CMPB_MAP
WHERE...

How to access SAP table CMPB_MAP

Within an ECC or HANA version of SAP you can also view further information about CMPB_MAP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).