SAP Knowledge Base Article - Public

3373727 - Values of Second Manager is not fetched from job relationship in Compensation worksheet


Values are not fetched from job relationship to custom field "Second Manager" in compensation worksheet.

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 Compensation
  • SAP SuccessFactors Variable Pay

Reproducing the Issue

In the Design Worksheet, you have made a custom field named as Second Manager, for it to be fetched from job relationship. But when you launch worksheets the data is blank even though you have mapped everything correctly.

Kindly check the following things before you move on:

  • The option id of second manager is same as the one which is mapped to job relationship of employee, if you have same label for multiple picklists, Kindly change the picklist label such that each Second Manager is distinguishable without knowing its option id.


    Job relationship in Employee profile:
  • The user have second manager mapped correctly. (this should be checked only if the user worksheet is not launched with second manager hierarchy, since there would be no worksheet for that user if it wasn't mapped correctly)
  • The mappings in design worksheets are :

    To fetch user id:
    Column Type: String
    EC category: Job Relationships
    EC component name: Compensation Manager(Option ID) (this is from the picklist jobRelType)
    EC field : Name

    To fetch Name of the Second Manager:
    Column Type: Username
    EC category: Job Relationships
    EC component name: Compensation Manager(Option ID) (this is from the picklist jobRelType)
    EC field : Name


The Second Manager Field appears Blank due to the jobRelType picklist.

Please note, if you have multiple picklist with same name ( most likely to associate with different parent picklist) like below:

You might also have same Non-unique external code in all of them.
Non unique external code.png
When this happens, the data is not being fetched.


Kindly check if all the second managers maintained in this picklist have same Non-Unique external code, if yes change it slightly( add number/symbol in them to make unique)

Once you do the changes, delete the worksheet and do the mappings again in design worksheet( as the previous mapping were just edited now), then launch the worksheet again.
Once you do the data starts appearing:

See Also

2509740 - Second Manager missing in the Employee export or UDF


Second Manager, Job Relationship, custom field, blank, empty, picklist, showing, value, custom, relationship type, job, relationship, jobRelType, Compensation, cmp, Variable pay, vrp, mapping, compensation manager, Non unique, external code, comp manager, worksheet, executive review, unique, same, not visible, invisible, not fetching, second, manager, eligible, employee profile, data, portlet,  ECT-187144 , KBA , LOD-SF-CMP-EC , EC data, EC mappings, configuration & settings , LOD-SF-VRP , Variable Pay Programs , LOD-SF-CMP , Compensation Management , Known Error


SAP SuccessFactors Compensation 2105 ; SAP SuccessFactors Compensation 2205 ; SAP SuccessFactors Compensation 2305