2588935 - Excel Import: How to import List of Values - SAP PD | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2588935 - Excel Import: How to import List of Values - SAP PD

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)?

 


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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.