Symptom
- How to implement cascading in MDF Picklists?
- How to limit the values of a picklist depending on the selection of another picklist?
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
Picklist cascading implementation is a two part process.
- Create Parent-Child relationship picklists first as per KBA 2861689;
- Create the proper picklist fields and field critera in the MDF Object where the picklist will be implemented.
As an example for this guide, we will use a Countries > States > Cities cascading relationship. You must follow KBA from step 1 above before proceeding for the next steps.
- Have the 3 picklists below created:
Once you have these ready then you need to have an MDF object which will contain all these parent-child picklist fields.
NOTE: If you don't add a Parent Picklist Value for a specific Picklist Value, this option will be displayed by default in the MDF Object. - Create a Custom MDF Object to use these picklists, e.g. "cust_Cascading_Picklist"
- Set the top-level picklist (Countries) in the cust_Country field:
- Define the field criteria for the child picklist fields. Country is the top level picklist, hence, field criteria is not necessary for this field.
Add the criteria highlithed bleow in the cust_State and cust_City fields respectively:
Source Field Name = parentPickListValue
Destination Field Name = [Field Name] from parent picklist - Save the Custom MDF Object configuration.
- Test the setup in Manage Data, creating a new record for the MDF Object where cascading picklists were configured:
NOTE: Child fields will not display any values at this moment. - In Country dropdown, select a Country (e.g. USA)
- Reference values for USA will now display in State dropdown.
- This behavior will be replicated in the City dropdown, after selecting a state. Only cities under the given state value will be visible (e.g. California)
NOTE: The cascading feature in picklists is implemented using Field Criteria. Make sure this is correctly defined in the object at field level.
See Also
2861689 - How to create MDF Picklist and set a parent picklist?
2955483 - Implementing Cascading Picklists on Background Elements/ EP portlets.
2856480 - How to create cascading picklists in MDF via Import?
Keywords
mdf picklist, cascading, association, picklist, mdf, parent picklist, parent, child picklist, field criteria, parentPickListValue , KBA , LOD-SF-MDF-PKL , Picklists , LOD-SF-EC-BCI , Manage Business Configuration (BCUI) & Data Models (XML) , LOD-SF-PLT-PCK , Picklist Management Issue , How To