CMPB_ASGN SAP table for – Campaign Assignment

Here we would like to draw your attention to CMPB_ASGN table in SAP. As we know it is being mainly used with the SAP SD-BF (Basic Functions in SD) component which is coming under SD module (Sales & Distribution). CMPB_ASGN is a SAP standard transparent table used for storing Campaign Assignment related data in SAP. It comes under the package CMPA.

SAP CMPB_ASGN table

Table CMPB_ASGN technical data

TableCMPB_ASGN
Data storingCampaign Assignment
ModuleSD
ComponentSD-BF
SAP PackageCMPA
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CMPB_ASGN 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_ASGN table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SECONDARY
    Its data type is C (Character String) with field length 1
  • KNUMH : Condition record number
    Its data type is C (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is CMPB_ASGN_KEY
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • CAMPAIGN
    Its a key field. Its data type is X (Byte string) with field length 16
  • SEQNO
    Its data type is N (Character String with Digits Only) with field length 4
  • VONA_KIND
    Its data type is C (Character String) with field length 1
  • INVALID
    Its data type is C (Character String) with field length 1