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.
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.
· 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.
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.
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.
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.
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.
After changing the query accordingly, we see the below results.
In Segmentation Data source builder both technical names and descriptions are visible now.
Likewise the Segmentation Attribute list with descriptions for corresponding BI characteristics is visible now as shown below.
The descriptions are visible rather than the technical names, by changing the mandatory variable to optional varaible.