SAP Knowledge Base Article - Public

2856480 - How to create cascading picklists in MDF via Import?

Symptom

How to create cascading picklists in MDF via Import?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
  • Metadata Framework (MDF)

Resolution

The import and export of MDF Picklists is done in the Import and Export Data feature inside Admin Center. The first step to update or create picklists is to download the current values of the picklists inside your environment. You will need to configure the relation between the two picklists to be parent and child and after to update the values and the dependency on the values of the respective parent picklist.

  1. Search for Import and Export Data in the Tool Search;
  2. Select Export Data;
  3. In the Generic Object, select Picklist;
  4. Select yes to include all dependencies;
  5. Click to download;
  6. You will see two important files in a zip file that will be downloaded: Picklist.csv and Picklist-values.csv.

Configuring the relation between the two picklists

In the Picklist.csv file, you will search for the picklist you want to transform into a child of the other one. You need to fill out the column "parentPickList.id" with the external code of the parent picklist.

1.png

This way, we have confirmed that the "Cascading_parent" is the parent and the "Cascading_child" is the child picklist in the relationship.

Configuring the dependency on the picklist values

In the Picklist-values.csv file, you will configure what values will be appearing in the child based on the options of the parent picklist. The configuration needs to be done in the child values, filling out the column "values.parentPickListValue.externalCode" with the code of the respective value in the parent picklist.

In our example, the field 1 in the child will be related to the field 1 in the parent, and the same applies to the options 2 and 3.

2.png

After finishing the edition, you will need to import the files you to the system to take effect.

  1. Search for Import and Export Data in the Tool Search;
  2. Select Import Data;
  3. In the Generic Object, select Picklist;
  4. Choose the Picklist.csv file and import;
  5. Go again to Import Data;
  6. In the Generic Object, select Picklist-values;
  7. Choose the Picklist-values.csv file and import.

Keywords

picklist, cascading, import, export, MDF, Picklist Center, Import and Export Data , KBA , LOD-SF-MDF-PKL , Picklists , How To

Product

SAP SuccessFactors HXM Suite all versions