SAP Knowledge Base Article - Public

2625635 - Despite Choosing The Only Visible Columns Option in Excel Download, All Columns are Displayed.

Symptom

  • You are downloading your price list via the Excel Download.
  • Before the download you are choosing the only visible columns option.
  • In the downloaded Excel sheet, all columns are showing.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Product and Service Portfolio Work Centre.
  2. Go to the Price Lists View.
  3. Show Customer specific price list.
  4. Select one of the price lists.
  5. Click on Export > to Microsoft Excel.
  6. Select a language and tick the only visible columns option.

In the downloaded excel sheet, there are many empty columns included, with headings that are not visible in the UI.

Cause

  • The excel file shows all the information that is visible in the UI plus many empty columns with headings that are not part of the UI but are part of the standard excel template.
  • “Visible columns” in this case means that the excel sheet will include the columns for all the columns that are made visible in the UI.
  • If you hide certain columns in the UI, for example Release Status via the personalisation or Adaptation mode, these will then not be included in the excel file.

Resolution

This is the standard system behaviour. Any unwanted columns can be deleted in the Excel sheet.

Keywords

Excel download, price lists, visible columns, excel template , KBA , excel download , price lists , preislisten , only visible columns , sichtbare spalten , excel template , AP-PRC-PR , Pricing , Problem

Product

SAP BUSINESS BYDESIGN 1802