SAP Knowledge Base Article - Public

2428346 - How to report on a Requisition Job Posting value (I,E,I/E,Not Posted...) - Recruiting Management


We would like to develop an ad-Hoc report showing the Job Posting value of a requisition, the same way we see them in the Requisition UI in column Job Postings.

This column value must display: Internal (I), External(E), Both(I/E), A (Agency) and Not Posted.

"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


There is no fields returning exactly the terms I,E,I/E,Not Posted,A. It can however be achieved indirectly


The field needed is: column 'Board ID' from table 'Posting'.

This field will return distinct rows for 'External' 'Internal' and 'Empty' if not posted. To get the exact same info as UI, an extra logic will need to be added after generating the report (outside of ad-hoc report).

- merge rows for requisition which have Board ID 'Internal' and 'External' into I/E

- set empty Board ID column as 'Not-Posted'

- filter to remove extra Board IDs 'Internal posting' and posting status 'deleted'

User ID.png

To find this column:

In your Ad-Hoc report type Single Domain Recruiting V2

The Column 'Board ID' is in table 'Posting':




posting values, ad-hoc, reporting on external postings, posting types, board ID, job posting, job requisition, internal, external , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , How To


SAP SuccessFactors Recruiting all versions