SAP Knowledge Base Article - Public

1667953 - The Column Name Days in Phase ,Which is Available in the Opportunity List is Missing When you Export the Data to Excel

Symptom

The column name Days in Phase , which is available in an Opportunity List,  is missing when you export data to excel.

Reproducing the Issue

  1. Go to the New Business work center.
  2. Go to the Opportunity List view.
  3. In the Show field from drop-down select All Opportunities and click on the Go button.
  4. You can see there is column name Days in Phase .
  5. Now click on button Export - > To Microsoft Excel.

You can see the Microsoft Excel for an Opportunity which opens ,don't have column Days in Phase available .

Cause

The column name Days in Phase is a calculated column. Calculated columns in the Opportunity List screen will not be exported to an excel.

Resolution

This is an expected system behavior.

Keywords

KBA , AP-LP , Lead Processing , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711