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.
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
- INSTANCE counter
- 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
This is the first BAPI to test in order to Read Mkt. Attrib. For BP.
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'
input = iv_account
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.
Read list of SAP CRM Marketing Attribute for Business Partner
CALL FUNCTION 'CRM_MKTBP_READ_BP_DATA'
iv_bp_guid = lv_bp_guid
et_return = lt_return
et_allocvalues = lt_allocvalues.
You may find the following resource interesting when you deal with SAP CRM Marketing
- SAP CRM Marketing
- SAP CRM Marketing Attributes explained