SAP Knowledge Base Article - Public

2771056 - Export to Microsoft Excel does not Export Address Column From Target Group

Symptom

When you export the Excel of members of a target group, you see the address column is missing in the excel add-in.

Environment

SAP Sales Cloud

Reproducing the Issue

  1. Go to the Sales Campaign work center.
  2. Go to the Target Groups view.
  3. Open Target group ABC (ABC represents of target group id).
  4. Go to Members tab.
  5. Select Action icon and select Export to Microsoft Excel.
  6. Download.

Here you see the Address column is missing in the downloaded excel.

Cause

The Address field is a calculated field. Depending on the member type, the value of the field is determined at runtime. Since the values are dynamic, the export to excel function cannot work on this field.

Resolution

This is an expected system behavior.

See Also

2538339 - How the Target Group Member's E-Mail and Phone Number Check Works

Keywords

Target Group, Address, Export excel , KBA , member , address column missing in excel , LOD-CRM-MKT-TG , Target Groups , LOD-CRM-MKT-CAM , Campaigns , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions