SAP Knowledge Base Article - Public

3394751 - Metric Lookup Table Required Field Validation Does Not Work - Goal Management


In latest goal, required="true" is configured for the "metric-lookup-table" field in goal plan xml, but the required field validation does not work when creating goals.

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 Goal Management

  • Latest Goal Management


This is current expected behavior. 
Even if you configure [field-definition id="metric-lookup-table" type="table"], the validation will not happen when creating goals, meaning users can create and save goals successfully even they do not fill in the MLT field.


In latest goal, the code checks and validates required field configuration of the table columns inside MLT. This means, at field level, configuring the field MLT as required or not has no impact on the validation.
Therefore, as a workaround, please configure the table column of MLT as required field. This can be done in Admin Center or goal plan xml via provisioning.

Note: MLT field-level required field validation works fine in legacy goal.

Via Admin center

  1. Manage Templates > click on goal plan
  2. select goal plan template
  3. click on the the MLT field
  4. click on required filed under columns e.g. Achievement, Rating or Description
  5. save the template

Please refer to the below screenshot:

set MLT column required field.png

Via provisioning
As a customer, you do not have access to provisioning. Please engage your Partner or SuccessFactors Product Support to implement the fix.
If you don't have a Partner, you can find for SAP Certified Partners via the SAP Partner Finder or, alternatively, speak with your Account Executive or Customer Engagement Executive about Professional Services options.

Please refer to below goal plan xml code example:

  <field-definition id="metric-lookup-table" type="table" required="true" detail="true" viewdefault="on" showlabel="true" default-calc-type="step" use-min-target-as-rating="true" field-show-coaching-advisor="false" cascade-update="regular">
    <field-label>Metric Lookup Table</field-label>
    <field-description>>Metric Lookup Table</field-description>
    <table-row-label>>Metric Lookup Table</table-row-label>
    <table-column id="achievement" type="number" required="true" order="both" cascade-update="regular">
    <table-column id="rating" type="number" required="true" order="both" cascade-update="regular">

If you think this possibility would be useful on your business, you can share your ideas via Customer Influence Portal for our Product Management team to review it. Once you have submitted your idea, other customers and partners can vote for it and your votes help us to prioritize ideas that we will consider for upcoming product releases.
2090228 - How to Submit Ideas for SAP SuccessFactors Products

See Also

User Assistance Document: Creating Goals and Ratings with Achievement Lookup > Metric Lookup Basics


MLT, mlt, required field, metric lookup table, table column, column, required, field, validation, performance goal, goal, sf, successfactors, goal management , KBA , LOD-SF-GM-TMP , Template Management , Problem


SAP SuccessFactors Performance & Goals all versions


Pasted image.png