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)

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

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-MDF , MDF & EC2MDF Migration , LOD-SF-EC-FOO , Foundation Objects (Organisation, Pay and Job Structures) , Product Enhancement

Product

SAP SuccessFactors HCM Core all versions