SAP Knowledge Base Article - Public

2479055 - Quantity in Sales Target Plan is Grayed Out

Symptom

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.

Environment

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.

Cause

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

Resolution

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.

Keywords

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

Product

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