SAP CRM Marketing attribute of BP

SAP CRM Marketing attribute is an important topic in SAP CRM Marketing. It allows collecting extra information on different SAP CRM Data Master like Business Partner.

As the topic of Marketing Attribute is huge, this post will focus only how to read SAP CRM Marketing Attribute of BP (Business Partner).
All the technical side will be explained with BAPI, SAP CRM Tables and a Sample ABAP Code.

Table of Contents

CRM Partner Marketing Attribute

In SAP CRM Web UI

In the SAP CRM Web UI, Marketing attribute are set in the Partner view.
Use for example, the MARKETINGPRO Rule, navigates to Business Partner and open the Marketing Blog. Check this link for more detail Marketing Attributes in CRM WEB UI – Version 6.

For more information about SAP CRM Web UI, check SAP CRM Web UI s post.

In SAP CRM SAPGUI

In order to display the Marketing Attributes of SAP CRM Partner, launch in the SAP CRM SAPGUI, the SAP CRM Tcode BP.
Alternatively if you want to assign Marketing Attribute to SAP CRM Business Partner, launch the SAP Tcode CRMD_PROF_BP.

Find here More about SAP CRM Business Partner.

SAP CRM Read Marketing attribute Tables

For Marketing Attributes, the same SAP Tables are used on both ECC and SAP CRM.
Check the list of SAP Marketing Tables and the corresponding with SAP CRM Tables for Marketing Attributes.

Mainly, the SAP Table AUSP will store the link between the Mkt Attrib. And the Guid of BP.
CABN table will store the definition of the Attributes.

SAP CRM Read Marketing attribute BAPI

BAPI for SAP CRM Marketing Attribute

The standard CRM BAPI ‘CRM_MKTBP_READ_BP_DATA‘ can retrieve the entire marketing attribute for a SAP CRM Master Data object.

It can be used to read the SAP CRM Business Partner as well as for CONTACT or MATERIAL.
You have to pass the right GUID as input parameter.

The output will be a table of CRMT_MKTPROF_VAL_R which contains:

CHARACT Characteristic Name
VALUE Characteristic Value
INHERITED Indicator: characteristic is inherited
VAL_ASSIGN Indicator: Values are Assigned to Characteristic
INSTANCEcounter
VALUE_NEUTRAL Characteristic Value
CHARACT_DESCR Characteristic description
DESCRIPTION Characteristic description
VALUE_ASSIGNMENT Value Assignment: Single-Value, Multiple-Value, Restrictable
ATVALUEDESCR Description
CHANGED_AT Marketing Object: Date of Last Change
CHANGED_BY Marketing Object: Last Changed By

Other BAPI Retrieve Marketing Attributes for CRP BP

You can also use the following BAPI

CRM_MKTBP_READ_BP

This is the first BAPI to test in order to Read Mkt. Attrib. For BP.

CRM_MKTBP_READ_ALL_TPL

Put the SAP CRM BP Guid in Input and you will get the full list of Marketing Attribute Set…

ABAP Sample: Read Marketing Attribute for CRM BP

The following ABAP code will retrieve all the Marketing Attributes of SAP CRM Business Partner.

The Partner Number will be passed as input (IV_ACCOUNT) types as BU_PARTNER.

DATA:  ls_allocvalues      TYPE crmt_mktprof_val_r,
             lt_allocvalues      TYPE TABLE OF crmt_mktprof_val_r,
             lv_bp_guid          TYPE  crmt_tg_bp_guid,        
             lt_return              TYPE bapirettab,        
             lv_account          TYPE bu_partner.

  Convert  SAP CRM BP to internal format 
    CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
     EXPORTING
        input  = iv_account
      IMPORTING
        output = lv_account.
  Retrieve the BP Guid from BP Number
 SELECT SINGLE partner_guid  FROM but000 INTO lv_sold_to_guid WHERE partner = lv_account.
 IF sy-subrc NE 0.
    RETURN.
  ENDIF.

  Read list of SAP CRM Marketing Attribute for Business Partner 
  CALL FUNCTION 'CRM_MKTBP_READ_BP_DATA'
    EXPORTING
      iv_bp_guid                     = lv_bp_guid
    TABLES
      et_return                      = lt_return
      et_allocvalues             = lt_allocvalues.

Others Resources

You may find the following resource interesting when you deal with SAP CRM Marketing

SAP CRM Marketing
SAP CRM Marketing Attributes explained