SAP Knowledge Base Article - Public

2687374 - Character limit of Learning user records' fields

Symptom

Which are the limits of the user's record fields at Learning?

Environment

SAP SuccessFactors Learning

Resolution

Here are the character limits in the user records' fields. Please note that while importing the user record through the Import Data Tool, the user ID field's limit is 30 characters. For imports through connector and users created directly through the UI, the maximum allowed is 90 bytes.

Field Character Limit Field Character Limit
User ID 90 Time Zone 100
Active (*required) 1 Locale 30
First Name 50 Currency  ID 3
Last Name 50 Related Instructor ID 30
Middle Initial 30 Custom Column Name 300
Gender 1 Custom Column Value 120 bytes
Job Code ID 50 Custom Column Name 300
Job Title 100 Custom Column Value 120 bytes
Role (*required) 30 Custom Column Name 300
Job Location ID 30 Custom Column Value 120 bytes
Domain ID (*required) 30 Custom Column Name 300
Organization ID 30 Custom Column Value 120 bytes
Employee Type ID 30 Custom Column Name 300
Employee Status ID 30 Custom Column Value 120 bytes
Address 600 Custom Column Name 300
City 50 Custom Column Value 120 bytes
State/Province 50 Custom Column Name 300
Postal Code 50 Custom Column Value 120 bytes
Country 256 Custom Column Name 300
Region ID 30 Custom Column Value 120 bytes
Email Address 128 Custom Column Name 300
Supervisor ID 30 Custom Column Value 120 bytes
Coach 30 Custom Column Name 300
Resume 200 Custom Column Value 100
Comments 600 Include in government reporting 1
Account Code ID 30 2483 Legal Entity 90
User May Use Organization Account Code 1 2483 Employee Class 90
Phone Number I 30 Hourly Rate Currency 3
Phone Number Description I 100 Native DeepLink User 1
Phone Number 2 30 Adjusted Hourly Rate Currency 3
Phone Number Description 2 100 Disability Classification ID 90
Phone Number 3 30 Gamification User ID 300
Phone Number Description 3 100

Important:

Connectors accept up to 90 characters due to technical aspects, and is not meant to be used to insert beyond 30 characters. One of such aspects is the fact that some characters in other languages take more than 1 byte, hence it is extended to 90 bytes for connectors.

For example Japanese, Chinese and Korean can occupy more bytes depending on the character. It can be from 2 - 4 bytes

UTF-8 uses 1 byte to represent characters in the ASCII set, two bytes for characters in several more alphabetic blocks,

and three bytes for the rest of the BMP. Supplementary characters use 4 bytes.

UTF-16 uses 2 bytes for any character in the BMP, and 4 bytes for supplementary characters.

UTF-32 uses 4 bytes for all characters.

There are string to byte counters calculators online that can help assist you with calculations of characters for each language [These tools are not supported by SAP]

See Also

2601761 - Character Limit For Import Data Templates

2776742 - What are the character limits of the Item fields/columns?

2404463 - LMS Connectors - Connector Workbooks FAQ

User Connector Header Mapping

Keywords

LMS, User ID, User ID length, User, character limit, length, character LMS, learning , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions