Symptom
- Using the Excel Import feature, we want to load a country list in List of values (on a domain) and set the Value and the Label. See the tab Standard Checks in Domain Properties.
- The format of List of value is specific:
- a value is separated from a label by a "TAB" character (ascii=09). A Carriage return separate lines.
- In the spreadsheet for import we created a new domain definition. In the ListOfValues column, we added a list of value label pairs. When we import the file into SAP PowerDesigner (PD), all data is imported into the Value column.
- How should the Microsoft Excel file be formatted to import the List of values (Value and Label)?
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
SAP Powerdesigner 16.6.x
Product
SAP PowerDesigner 16.6
Keywords
PDM, LDM, OOM, attribute, column, standard, checks , KBA , BC-SYB-PD , PowerDesigner , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.