SAP Knowledge Base Article - Public

3137243 - Value Shown Twice in Excel after "Export to Microsoft Excel" From C4C

Symptom

PSM Fields which are added to the Object Work List (OWL) of any Slaes Document (Sales, Quote, Order, Opportunity, Lead...) have their values shown twice in Excel after users use the "Export to Microsoft Excel" Function.

Environment

SAP Cloud For Customer

Reproducing the Issue

 Example:

  1. You have added the field "Customer ID" or "Account ID" to the desired OWL. This field is a PSM Field.
  2. In OWL, click More button and choose "Export to Microsoft Excel".
  3. When you open the downloaded Excel file, you see the values are shown twice.

Exported file:

Cause

PSM Fields will have the representation as "IDandDescription" - it will be displayed as ID and description in the excel download. In this case both ID and Description are the same - and it appears twice.

Resolution

This is the expected system behavior. Currently it is not possible to change this representation/display mode.

We are constantly thriving to improve our system and hearing your suggestions is the best way forward. Our product managers regularly check the Influence page to hear what changes users would like to see in place and check those for feasibility. Idea requests can also be voted for by other customers.

If you would like to suggest a change to this behavior, please submit your idea at the respective SAP Influence page:

Please note that it is not possible for our Support Team to provide you additional information regarding the availability of this feature in a future release.

Keywords

Column, Duplicate, Duplicated, Repeats, Repeated, Number , KBA , SRD-CC-OIN-XL , Excel Integration , LOD-CRM-LM , Lead Management , LOD-CRM-OPP , Opportunity Management , Problem

Product

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