SAP Knowledge Base Article - Public

2657965 - Extra value in the picklist ( Blank Value) in reporting

Symptom

Customer has 2 values in the picklist - Yes and No.

While creating the report on the field - It shows 4 values.

Yes , No, Null and a Blank.

Reproducing the Issue

Login to Customer instance.

Create a Job requisition with a picklist field configured with values - [say Yes and No] and send for approvals.

1_kba.GIFkba_5.GIF

During creation, value saved for this picklist field is say Yes.

Navigate to Reporting and run a report on the picklist field.

2_KBA.GIF

In the filter - Values displayed under reports for filtering: [Null, Yes] There is no "Empty" value displayed.

After that, update the field with value say "No Selection"

Values displayed under reports for filtering: [Null, Yes] There is no "Empty" value displayed

Again, update the field with value say "Yes"

Values under reports for filtering: [Null, Empty, Yes] [There is "Empty" value displayed]

kba_3.GIF

Resolution

The blank value corresponds to a 0 value in the database. If we never assign a value to a picklist field from the data when the job req got created, its value in the  table in back end and on UI will be "null" but when we assign a value to a picklist field and move it back to "no selection", the value in the table and UI will be 0 (since the picklist id of no selection is 0). This is as per the original design.

So at any given point of time there could be both null and 0's in the backend tables for all the picklist fields and this gets reflected as "null" and blank values in the adhoc reports filter screen.

If the customer want to run a report to fetch all the job req's which have lets say picklist1 as "no selection", he needs to select both "null" and blank in the filter screen.

Keywords

KBA , LOD-SF-RCM-ADM , Admin Center, RBP, Permissions and Settings , Problem

Product

SAP SuccessFactors Recruiting all versions