SAP Knowledge Base Article - Public

2479055 - Quantity in Sales Target Plan is Grayed Out


You have created a sales target plan and you are viewing it in Excel. You would like to edit the Quantity field, however the Excel cell is grayed out and not editable.


SAP Cloud for Customer

Reproducing the Issue

  1. Go to the work center Sales and the view Sales Target Planning.
  2. Choose your plan and open it in Excel.

You are not able to edit the Quantity field in Excel. The cells are grayed out.


You can only update the quantity if the respective product has a valid unit of measure.


If there is no product (i.e. if the product is Not Assigned / # in a particular row), there can be no unit of measure either. For this reason, no quantities can be maintained. This is the correct behavior.


sales target plan, sales plan, greyed out, quantity, key figure, editable, business analytics, planning , KBA , AP-RC-ANA-PLN , C4C, ByD: Analytics Planning , How To


SAP Hybris Cloud for Customer add-ins 1705 ; SAP Hybris Cloud for Customer add-ins 1708