The Table Report Builder provides multiple options for configuring report fields. The two options are Data Type Configuration and Show Value ID Configuration. Each of the options can be utilized to meet the needs of the report creator.
Configuring Fields
Objective
After completing this lesson, you will be able to configure fields in SAP SuccessFactors Table Reports.
Configuration Overview
DataType Configuration
DataType Configuration enables the report creator to define what date/time format should be utilized for datetime fields. This allows the selection of either the Date field (for example, 31/12/2015) or Timestamp field (for example, 31/12/2015 21:00:00) formats. If you select Timestamp, it also gives the option to choose whether the field is localized (shown relevant to your current time zone).
Show Value ID Configuration
Show Value ID Configuration enables you to define whether the ID or label should be shown for Picklist fields. Showing the ID can be useful when language-independent logic must be defined based on the report output.
For example, you may have a field that a user selects values Good, Fair, or Needs Improvement as labels. However, the system stores the ID values of 3, 2, 1. Normally the report will show the Label by default, translated into the report consumers preferred locale. It may be useful is some circumstances to show the ID (3,2,1) in the report so that it is the same values, regardless of preferred locale.