Symptom
You are unable to download Excel template to upload List Prices.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Product Portfolio work center.
- Go to List Prices view.
- Click in New button and select List Prices from Microsoft Excel.
- 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
Firstly please try to follow the steps below:
Steps to download and correct the template:
- Go to Application and User Management work center.
- Go to Microsoft Office® Template Maintenance view.
- Open the Advanced Filter.
- Filter:
- Template Group: List Price – Worklist
- Template Type: Microsoft Excel® (Write-back)
- Click in Go.
- Download the required template language variant.
- Open the xlsx file that was downloaded.
- Extend the data area at the end, in order to create buffer lines (Please check the screenshot below).
- Save it.
Now the steps to replace with the new template:
- Go to Application and User Management work center.
- Go to Microsoft Office® Template Maintenance view.
- Click in Upload button and select Replace Existing Language Variant.
- Browse the file that you saved earlier.
- Click in OK.
- Click in Publish.
- Click in Yes.
Now you should be able to follow the steps to select 'List Prices from Microsoft Excel' and face no errors.
In case you are still facing errors, 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:
- Go to Application and User Management work center.
- Go to Microsoft Office® Template Maintenance view.
- Search for List Prices.
- Check if there are templates that were manually created by business users.
- If they are not relevant, you may delete them.
- 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