SAP Knowledge Base Article - Public

2277515 - How to create cascading picklists in MDF (Non-Migrated Instances)


  • Cascading picklists in MDF (For non-migrated instances)
  • Creating parent-child relationship in MDF picklists

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


  • SuccessFactors Cloud HCM: Meta Data Framework
  • SuccessFactors Cloud HCM: Employee Central


Suppose we have three picklists with cascading relationship : Country, State and City. State can be derived from Country i.e Country is acting as the parent of State and similarly City is derived from State i.e State is the parent of City.

To create picklists in MDF, please navigate to Admin Center > Configure Object Definitions > Create Picklist.

For setting up cascading picklists in MDF, you must follow these steps :-

  1. Country Picklist :-

Picklist - 1.JPG

  1. State Picklist ( parentPickList field value has been selected as Country and parentPicklistValue column has been derived from the values for Country picklist ) :-

picklist - 2.JPG

  1. City Picklist ( parentPickList field value has been selected as State and parentPickListValue column has been derived from the values for State picklist ) :-

picklist - 3.JPG

  1.  Now, create a generic object to cascade these picklist. For eg. "cust_cascadingPicklistMDF".

obj def.JPG

  1. Now, field criteria has to be added to get cascading property. Country is the top-level picklist which has no parent so for this picklist, you don't need to define field criteria.

field - 1.JPG

  1. In Source Field Name, write "parentPickListValue" which is a column in the picklist definition and in Destination Field Value, write the field name from the object definition itself which you want to use as parent.

field - 2.JPG

field - 3.JPG

  1. Manage Data page for the object "cust_cascadingPicklistMDF".



  1. Check Country dropdown and select Country as "USA".


  1. Check State dropdown. Only those states related to USA are shown in the dropdown.


  1. Now, select any state from the State dropdown say California (CA) and check for the City dropdown. Only those cities related to California are shown in the City dropdown.


  1. Final UI screen of the object.


The cascading feature of the picklist is implemented using Field Criteria. Please make sure that it is correctly defined in the object at field-level.


MDF Picklist, Cascading Picklists, Support for cascasding picklists in MDF, Configure Object Definitions , KBA , LOD-SF-MDF-PKL , Picklists , LOD-SF-MDF-OBJ , Object Definition & Field Related Issues , How To


SAP SuccessFactors HXM Suite all versions