SAP Knowledge Base Article - Public

2721590 - Best Practice for Setting a Cascading Picklist Value For Parent STATE and Child MUNICIPALITY


  • Best Practice for Setting a Cascading Picklist Value For Parent  STATE and Child MUNICIPALITY
  • Cascading picklist value displayed all Child PicklistID with  parentOptionId= -1

Example: How to Configure Picklist Cascading Parent  STATE_MEX and Child MUNCI_MEX PicklistID

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


SAP SuccessFactors Employee Central - Cascade Picklist

Reproducing the Issue

  1. Go to Mexico user  address Portlet
  2. Select home address
  3. select State : benitor jaures
  4. Result: Municipality field : display all Picklist


This issue is that not only the right parentOptionId ones will show up but also those whose with 'parentOptionId = -1' will also show up

Example of Misconfiguration



Step1:View Cascading configuration:

Based on The  Country Specific Data Model or Manage Business Configuration (BCUI) for Country: Mexico

<hris-field max-length="256" id="state" visibility="both">
<label xml:lang="en-US">State</label>
<picklist id="STATE_MEX"/>
<hris-field max-length="256" id="address4" visibility="both" required="true">
<label xml:lang="en-US">Municipality</label>
<picklist id="MUNCI_MEX" parent-field-id="state"/>

Step 2: Picklist File

  1.  In order to use cascading list the right way, Administrator User should set Municipalities with the right parentOptionId, rather than leave it empty(empty will be set as -1 by default).
  2. All Child PicklistID  parentOptionId Must be updated 

See Below  Child MUNCI_MEX PicklistID with a valid Parent  STATE_MEX and



ECT-107499, ECT-107499, SRSD-37424,parentOptionId ,  universal parents , Picklist, Cascade,State, STATE_MEX,MUNCI_MEX , KBA , LOD-SF-EC-PER , Person Data (All Person Data Types) , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , How To


SAP SuccessFactors Employee Central all versions