Symptom
In the Customer Specific Price List, you select the option Export in the Items tab, however, the Account ID does not showed up.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Product and Service Portfolio work center.
- Go to the Price Lists view.
- Query for Customer Specific Price List.
- Select any Price List and click on Edit.
- Go to the Items tab and click on Export button.
- Download the excel file and open it.
- It's possible to see that the Account ID and Description fields are missing data.
Cause
Excel export from Price List via Items tab, selecting the option of Export To Microsoft Excel® is used to download Items data only.
This option of Excel export is used only to download fields of Items table, it's used in high volume Price Lists
Resolution
- Go to the Product and Service Portfolio work center.
- Go to the Price Lists view.
- Query for Customer Specific Price List.
- Click on the Price List hyperlink (it will take control to Price list Factsheet)
- Click on button "Download"
- You can save the Price List into excel (which will have both header and item information).
Keywords
Export, Excel, Price List , KBA , AP-PRC-PC , Calculation , How To
Product
SAP Business ByDesign all versions