2488826 - Chinese pinyin sorting

SAP Knowledge Base Article - Public

2488826 - Chinese pinyin sorting

Symptom

MDF objects and foundation objects are not shown in Chinese pinyin order.

PS: Pinyin= (equivalent English pronunciation)

Environment

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:

English MSS.png

But the similar alphabetical order (Pinyin order) for Chinese doesn't work:

MSS-ESS-page.jpg

Manage data page11.jpg

Cause

For Chinese, Oracle database provides three different sort method in the ORDER BY clauses:

  1. SCHINESE_PINYIN_M
  2. SCHINESE_RADICAL_M
  3. SCHINESE_STROKE_M

Our application is not using pinyin sort and hence the same is not happening in the system.

Resolution

  • 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.

Keywords

pinyin sort chinese alphabetical order chinese sort picklist order MDF order , KBA , LOD-SF-EC , Employee Central , LOD-SF-EC-FOO , Foundation Objects - MDF & Legacy , LOD-SF-EC-MDF , MDF & EC2MDF Migration , Product Enhancement

Product

SAP SuccessFactors HCM Core all versions