SAP Knowledge Base Article - Public

2479055 - Quantity in Sales Target Plan is Greyed 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 greyed out and not editable.

Reproducing the Issue

  1. Go to the work center Sales, 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 greyed 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 behaviour.

See Also

Please also see the details in the case document 2080212 - You are Not Able to Edit the Quantity of your Sales Target Planning in Excel .


KBA , SRD-CC , Cross Components , How To


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