Skip to Content

We shall discuss on how to resolve the issue where the attribute list displays only attribute technical names and not the description in segment builder and F4 Help when using the ‘Maintain Data Sources for Segment Builder’ in CRM with BW query. We will go over with a example on the same.

Business Scenario

There is requirement to build a segmentation builder attribute list in CRM WEBUI for business to choose their choice of attributes for filtering & query purpose.

Issue

·         While using the transaction code CRMD_MKTDS to Maintain Data Sources for Segment Builder, we need to map the Business partner mandatory field to that of the corresponding Customer number or partner number of BW query to fetch the relevant records for output. In this process, as the BW query has lot of characteristics, while we use F4 Help on Business partner field it pops-up the list of attributes/characteristics which appear with technical names. The issue here is to make the descriptions appear along with technical names.

·         The attribute list would be available in WEBUI where business users would be choosing the KPIs or characteristics required by description instead of technical names.

Solution

By avoiding the use of mandatory variables in the BW Query being used for segmentation purpose, we can over come this

Illustration of the solution in step-by-step procedure with simple example.

Step By Step Procedure

Consider a sample BW query which has a mandatory variable Program Year as shown below.

Change variable.png

A segmentation data source is built on the above BW Query using the transaction code CRMD_MKTDS.

As you see below the BW query is mapped to a segmentation object Business Partner.

Create Datasource.png

In order to map Business partner of SAP CRM to corresponding BW characteristic which references to BP like Sold-to-party, Ship-to-party or Customer# in BW, we choose F4 help on BP field and try to assign the BW characteristic here.  As you see technical names are displayed but the corresponding descriptions don’t appear which makes it difficult to map the right BP.

Another issue on similar lines was found with respect to Creation of Attribute list is given below.

EDIT selection attr list 1.png

While creating attribute list, the characteristics/KPI’s of the BW query are displayed with technical names which makes it difficult to choose for reporting in segmentation builder.

In order to resolve this issue we need to make sure that variables are not mandatory in the query.

Now the variable is replaced with an optional variable.

change varaibles.png

After changing the query accordingly, we see the below results.

In Segmentation Data source builder both technical names and descriptions are visible now.

create datasource2.png

Likewise the Segmentation Attribute list with descriptions for corresponding BI characteristics is visible now as shown below.

EDIT selection attr list 2.png

The descriptions are visible rather than the technical names, by changing the mandatory variable to optional varaible.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply