SAP Knowledge Base Article - Public

3500636 - 'Assigned Resources' column is empty when exporting table to spreadsheet

Symptom

Assigned Resources column from app 'Manage Project Demand' is empty, when exporting the table to a spreadsheet using the Export Table feature.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Open app 'Manage Project Demand';
  2. Navigate to the 'Resources' tab;
  3. Click on 'Export table';
  4. Open the Excel table generated in step 3;
  5. Notice that the 'Assigned Resources' column will be empty.

Cause

This is the standard system behavior. The 'Assigned Resources' column from app 'Manage Project Demand' is an Aggregated row, a feature that is not supported in SAP Spreadsheet Export.

Resolution

Since this is the expected behavior, the Assign Resources column will in fact be empty when exporting the table to a spreadsheet in app 'Manage Project Demand'.

Therefore, in order to populate it in Excel, the information must be inputted manually.

The following link provides details on the Spreadsheet Export Restrictions: UI5 Demo Kit - Spreadsheet Export Restrictions.

See Also

For additional information, check SAP Note 3198506 - SAPUI5 Export Capabilities and Restrictions.

Keywords

S/4HANA Cloud, manage project demand, resources, assigned resources, export, spreadsheet, excel, empty , KBA , PPM-SCL-DMN-FIO , Fiori UI for Project Demand (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions