SAP Knowledge Base Article - Public

3226412 - How to Show Product ID in the Sales Target Planning Excel


You have created a sales target plan based on dimension: product, and open it in the Excel.

In the excel, only product description is shown as the row element, you want to have product ID shown as well.


SAP Business ByDesign

Reproducing the Issue

  1. Open the excel application.
  2. Open a sales target planning file. 
  3. After logged in, you find the product is only shown as description.


In the Sales Target Plan excel, product ID is not shown by default in the excel.

In the sales target planning excel, on the right panel:SAP Business Bydesign - View, You can see Row Dimensions table. Select row element: Product, the default option for Shown As is "Shown As ID".


You can select different option for show as, in this case, select 'Show As Description and ID', the product ID is then displayed in the excel.

sales target planning_show as ID.png


sales target planning; excel; product ID , KBA , SRD-CRM-PLA , Planning , Problem


SAP Business ByDesign all versions


sales target planning_show as ID.png