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
- Go to the work center Sales and the view Sales Target Planning.
- 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