SAP Knowledge Base Article - Public

2603074 - Data not shown in Excel after Export

Symptom

During export of data to excel, the data is not shown in few fields.

Environment

Excel

Reproducing the Issue

  1. Go to the custom work center view.
  2. Select a particular query.
  3. Select Export to Excel.
  4. In the downloaded excel, data is not shown for a particular field.

Cause

"Identifier Description Data Field" property in the UI designer is not configured

Resolution

  • Go to UI designer to the particular screen.
  • Check the data binding for the field description.
  • Go to Data Model and locate the binding path.
  • You see that "Identifier Description Data Field" is empty.
  • This should be configured.

UI.PNG

Keywords

data missing in excel, export to excel, extension field shows no data in excel , KBA , data missing in excel , export to excel , SRD-CC-OIN-XL , Excel Integration , How To

Product

SAP Cloud for Customer add-ins all versions