SAP Knowledge Base Article - Public

3077468 - Sales Target Planning - Cells Grayed Out

Symptom

When using Sales Target Planning with a huge amount of data, some cells in Excel are grayed out and cannot be edited.

Environment

SAP Cloud for Customer

Cause

The data download to the Sales Target Planning Excel is limited to “250.000”. It is not planned to change this. Very high data volume leads to memory dumps in the system backend or freezing in Excel.

Example calculation for data volume:

Account: 2,000
Product Categories: 15
Months: 10
 2000 * 15 * 10 = 300,000

Resolution

The recommendation is to split this target plan, e.g. split into quarters (3 Months). This will reduce the data volume of each target plan.

Keywords

gray, grey, grayed, greyed, Excell, download , KBA , LOD-CRM-SPL , Sales Planning , Problem

Product

SAP Cloud for Customer core applications 2105