The CMPB_ASGN table in SAP ERP or S/4HANA stores Campaign Assignment data. There are total 9 fields in CMPB_ASGN table. The Campaign Assignment table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMPB_ASGN table. It is in Core Objects of Campaign Determination (CMPA) ABAP package and is part of the Basic Functions (SD-BF) module.
SAP CMPB_ASGN Table Fields
Following is the list of fields that are available in SAP CMPB_ASGN table. The primary key fields of the table are MANDT (Client), VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), CAMPAIGN (Generic project planning: GUID from external R/3 system).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR (10) |
| POSNR | Item number of the SD document | POSNR | * | NUMC (6) |
| CAMPAIGN | Generic project planning: GUID from external R/3 system | CGPL_GUID16_R3 | * | RAW (16) |
| SEQNO | Campaigns: Counter for Sequence | CMPGN_SEQNO | NUMC (4) | |
| VONA_KIND | Campaigns: Relationship Type | CMPGN_VONA_KIND | CHAR (1) | |
| INVALID | Campaigns: Invalid Assignment | CMPGN_INVALID | CHAR (1) | |
| SECONDARY | Campaigns: Secondary Object | CMPGN_SECONDARY | CHAR (1) | |
| KNUMH | Number of the Condition Record | KNUMH | KOND3 | CHAR (10) |
