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

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; excel; product ID , KBA , SRD-CRM-PLA , Planning , Problem