SAP Knowledge Base Article - Public

2960781 - "Null Value" in Offer Letter Status (Adhoc Report) - Recruiting Management


When filtering by the Offer Letter Status, a "(Null Value)" is displayed.

"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 Recruiting Management

Reproducing the Issue

  1. Go to Reporting.
  2. Select Recruiting V2.
  3. Select "Offer Letter".
  4. Select the field "Offer Status". - This label can change based on the customer's configuration.
  5. Filter by it and notice the "(Null Value)".


The Offer Status field in the Offer Letter entity is only updated when the "Online Offer" mode is used. For other mode like "Verbal", "Print" and "Text", the Offer Status does not have any value, therefore it will bring a "Null Value".


When creating a report, you must use the "Send Mode" field to know how the Offer was created and whenever the "Verbal", "Print" and "Text" modes are selected, it's expected to have a "Null Value" if you are using the Offer Status field.


Offer, Null, Value, Status, Letter, Mode, Online, Filter , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-RCM-CAO , Candidate Offers, Offer Letters , Problem


SAP SuccessFactors Recruiting all versions