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

  • You are exporting the successfully processed log of an Overhead Distribution run to Microsoft Excel. 
  • In the exported Excel list you notice that the Sender ID, Receiver ID, Sender Type and Receiver Type are not displayed in the list. 

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. Under Details, in the Logs collumn press Log Results.
  5. In the application log go to the Processed Successfully tab.
  6. Press Export - To Microsoft Excel.
  7. Open the file.

You notice that the Sender ID, Receiver ID, Sender Type and Receiver Type are not displayed in the list.

Cause

The Sender ID, Receiver ID, Sender Type and Receiver Type fields are so called calculated fields

Resolution

The export to Microsoft Excel is not supported for calculated fields. The system behaves as expected.

Keywords

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

Product

SAP Business ByDesign all versions