SAP Knowledge Base Article - Public

3324039 - Cannot open List Prices from Microsoft Excel due error: "Not enough rows in table for XYZ code list. Add more rows."

Symptom

You are unable to download Excel template to upload List Prices.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Product Portfolio work center.
  2. Go to List Prices view.
  3. Click in New button and select List Prices from Microsoft Excel.
  4. It opens a new tab in the browser and it shows message:
  • Error ID: AP_UI_OIN 043
  • Error text: Not enough rows in table for XYZ code list. Add more rows.
  • Please report an incident if the error persists.

XYZ can be MeasureUnitCode or GeneralLedgerAccountAliasCode.

For example:

  • Error text: Not enough rows in table for MeasureUnitCode code list. Add more rows.
  • Error text: Not enough rows in table for GeneralLedgerAccountAliasCode code list. Add more rows.

Cause

This scenario is a known issue. Application developers are requested to keep as many buffer rows as possible to accommodate code list enhancements from customers.

Resolution

Currently there is no permanent fix for this issue related to List Prices.

Please report an incident to SAP Support so the template related to List Prices can be retrieved from backend system. Then you can save the given Excel template we gave you for future use in Application and User Management work center - Microsoft Office® Template Maintenance view.

Please note that if you still face issues even after using the new given Excel template, the cause may be due to template versions. Please verify if the other templates are relevant for you process by following the steps below:

  1. Go to Application and User Management work center.
  2. Go to Microsoft Office® Template Maintenance view. 
  3. Search for List Prices. 
  4. Check if there are templates that were manually created by business users. 
  5. If they are not relevant, you may delete them.
  6. Try to launch the new Excel for List Price. 

Keywords

Excel; Template; List Price; Row; Code List; MeasureUnitCode , KBA , AP-PMD-PPS , Procurement Price Specification , AP-POP , Purchase Order Processing , How To

Product

SAP Business ByDesign all versions