2379670 - Unable to Upload Demand Plan Key Figure through Excel Upload for more than 1200 records.

SAP Knowledge Base Article - Public

2379670 - Unable to Upload Demand Plan Key Figure through Excel Upload for more than 1200 records.

Symptom

When you try to upload data through excel for a Demand Plan, it is not possible to upload more than 1200 line items in the system.

Reproducing the Issue

  1. Navigate to Demand Planning Work Center.
  2. Select Demand Plans Subview.
  3. Show All Demand Plans By Selection and select Go.
  4. Select a Demand Plan.
  5. Select Upload.
  6. Excel sheet will open. Fill in the mandatory fields.
  7. Perform Save To.

Cause

Only 1200 records can be uploaded per time as there is a Microsoft limitation set on the number of records that can be updated based on the number of columns in each row.

Resolution

We can remove the records if it is more than 1200 and limit to 1200 records for Excel upload as a best practice and for a better system performance.

This is the expected system designed behavior.

Keywords

KBA , SRD-CC , Cross Components , Product Enhancement

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711