SAP Knowledge Base Article - Public

2907880 - The "Achievement" Metric Lookup Table Column is Not Respecting the Decimal Places Defined in the Field-Format - Goal Management

Symptom

In the field definition for the "achievement" Metric Lookup Table Column, the field-format is not being respected and only returns values to 5 decimal places.

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

Environment

SAP SuccessFactors Goal Management

Reproducing the Issue

In the Goal Plan XML template, the field-format for the "achievement" table column is defined with more than 5 decimal places (example below shows 9 decimal places):

field format 9 decimal places.png

When adding a goal in the Goal Plan, it is possible to add values with the 9 decimal places:

add goal window.png

In the Goal Plan, the "achievement" table column only returns the value entered to 5 decimal places:

goal plan view 5 decimal places.png

Resolution

  • As defined in the database, the max length for the achievement column is 38 and the supported decimal places is 5 (38,5).
  • Thus, the current system behaviour is that the "achievement" table column which is of field type "number" will only display 5 decimal places.

Workaround:

  • If the customer wishes to calculate with larger values, they may rely on the default thousand separators.
  • The field-format attribute should be removed from the field-definition of the "achievement" table column.
  • By default, values entered will display with thousand separators:

thousand separators ui.png

 

  • We encourage you to submit or vote on an enhancement request to have this functionality considered within future development cycles – you can do this on our Customer Influence Portal at https://influence.sap.com/successfactors .
  • All enhancement requests are reviewed by our Product Management team and, if successful, are developed and implemented in a future product release.
  • Peer voting is a key part of this review process, so we encourage you to provide a clear explanation so that other customers are able to understand the functionality requested.

Keywords

TGM, GM, Goal Management, Objective, Metric Lookup Table, MLT, Achievement, table column, field-format, format, definition, decimal places, not respecting, dropping, zeros, hash, database, TGM-3873, personal, user, group, team goal, add, create, view goal details, audit, history, database , KBA , LOD-SF-GM , Goal Management , Problem

Product

SAP SuccessFactors Performance & Goals all versions