SAP Knowledge Base Article - Public

2838861 - How to report on employees who do not have a Profile Picture


Fetch a report of employees who do not have a profile picture.

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 HXM Suite


  1. Create a new Report-Canvas
  2. Add a List Report Component to the page
  3. Select the component > Edit Query > Advanced Reporting > New
  4. Choose Employment Realm > drag and drop 'Global Job Infomration' to Objects
  5. Expand 'Global Job Information' and look for 'Employment Photo' > drag and drop the same to Objects
  6. Add an Object Level filter on 'Employment Photo' object. 
  7. Filter condition to be "Phototype in 20" and "Null". Depending on the instance configuration the profile picture phototype can be 1, in this case please filter by "Phototype in 1, Null".


  1. Fetch Results
  2. All the employees who have 'User Sys ID' column of 'Employment Photo' object blank DOES NOT have a profile picture


employment, photo, profile, picture, employee, user, person, no, report, canvas, advanced, reporting , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To


SAP SuccessFactors HXM Suite all versions