SAP Knowledge Base Article - Public

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


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.


Successfactors - Recruiting


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 genereting the report (outside of ad-hoc report).

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

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

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


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 , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , How To


SAP SuccessFactors Recruiting all versions