SAP Knowledge Base Article - Public

3058948 - The Sender ID, Receiver ID, Sender Type and Receiver Type columns are missing from Excel File of an Overhead Distribution

Symptom

When export to excel is performed from Overhead Distribution View in the Processed Successfully tab, you observe Fields Sender ID, Receiver ID, Sender Type and Receiver Type are not part of the excel.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue work center.
  2. Go to the Overhead Distribution view.
  3. Search and Select the respective Run ID.
  4. Go to the Processed Successfully tab.
  5. Click Export - To Microsoft Excel.
  6. Open the file.

Exported File is missing columns for Sender ID, Receiver ID, Sender Type and Receiver Type.

Cause

The Sender ID, Receiver ID, Sender Type and Receiver Type fields have calculated rules associated.

Resolution

Excel export does not support calculated fields. The system behaves as expected.

Keywords

Sender ID, Receiver ID, Sender Type, Receiver Type, columns missing, Excel File, Overhead Distribution. , KBA , sender id , receiver id , sender type , receiver type , columns missing , excel file , overhead distribution , SRD-FIN-COR , Cost & Revenue , How To

Product

SAP Business ByDesign all versions