SAP Knowledge Base Article - Preview

3709772 - Incorrect format in Excel when exporting ALV Grid/List

Symptom

  • A report is run (for example KE24, KE30), and its output is exported to Excel.
  • The Period/Year field format is incorrect when exporting, showing 'YYYYXXX' instead of 'XXX.YYYY'. 
  • The UoM may also be displayed incorrectly in excel.


Read more...

Environment

  • Controlling (CO)
  • SAP S/4HANA
  • Profitability Analysis 
  • SAP_BASIS 758    SP 00

Product

SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA Finance all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions

Keywords

UoM, KE24, KE25, KE30, Actual Line Items, planned line items, KKBC_HOE_H, Unit of measure,  International System of Units, SI, , KBA , CO-PA-IS , Information System , EC-EIS-DD , Interactive Drill-Down Reporting , FI-GL-IS , Information System , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.