SAP Knowledge Base Article - Public

3032058 - Status column in excel is numeric in Manage Production Orders App

Symptom

In Manage Production Orders App, when exporting the operations to excel and viewing the document, the Status column is numeric.

Environment

SAP S/4HANA Cloud.

Reproducing the Issue

  1. Go to Manage Production Order App
  2. Click in an order to see more details
  3. Scroll down to Order Schedule --> Operations
  4. Select the export to excel button
  5. Open the file .xlsx
  6. See the column Status
  7. The Status is 1,2,3.

Cause

Standard System Behavior.

Resolution

This is because excel considers value from oData call. Therefore, it replicates data in CDS view. The status is changed to 1,2,3... in CDS view.

Keywords

Manage Production Orders, App, Status, column, xlsx, excel, Operations, export, document. , KBA , PP-FIO-SFC , Fiori UI for Production Orders , PP-FIO-SFC-2CL , Fiori UI for Production Orders (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions