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

  • Contolling(CO) 
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA Finance
  • SAP S/4HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP S/4HANA Finance all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA 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.