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
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 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.
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.
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:
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…
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.
You may find the following resource interesting when you deal with SAP CRM Marketing
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…