MDF objects and foundation objects are not shown in Chinese pinyin order.
Pinyin= (equivalent English pronunciation)
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Employee Central - Manage Data
Employee Central - Manager Self Service
Reproducing the Issue
Go to employee profile > take action > click on any foundation object or MDF object dropdown.
We notice that the objects are sorted in English alphabetical order:
But the similar alphabetical order (Pinyin order) for Chinese doesn't work:
For Chinese, Oracle database provides three different sort method in the ORDER BY clauses:
Our application is not using pinyin sort and hence the same is not happening in the system.
- Our development team is implementing the pinyin sort method in successfactors oracle queries to support pinyin sorting.
- This functionality would be made available in b1708.
PS: This feature will be available with b1708 for customers in Oracle database. The same functionality is being discovered for HANA database and currently is a limitation in HANA.
pinyin sort, chinese alphabetical order, chinese sort, picklist order, MDF order , KBA , LOD-SF-EC , Employee Central , LOD-SF-EC-MDF , MDF & EC2MDF Migration , LOD-SF-EC-FOO , Foundation Objects (Organisation, Pay and Job Structures) , Product Enhancement