SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

Successfactors - Recruiting

Cause

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

Resolution

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'

posting_scrshot.png

To find this column:

In your Ad-Hoc report type Single Domain Recruiting V2

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

column_table.png

 

Keywords

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

Product

SAP SuccessFactors Recruiting all versions