SAP Knowledge Base Article - Public

2905090 - Application Date field not available in Integration Center or OData/SFAPI - Recruiting Management

Symptom

When trying to find the field Application Date using Integration Center, or when executing a query in OData/SFAPI, I am not able to find it like we do in Ad-Hoc.

Environment

SAP SuccessFactors Recruiting Management

Reproducing the Issue

  1. Open Reporting, and create a new Recruiting V2 table report;
  2. Select columns and search for "Application Date";
  3. Now go to Integration Center, and create a new Integration;
  4. Select the JobApplication Entity, and look for the Application Date field;
  5. Not able to find it.

Resolution

This happens because the Application Date is not an Exposed field through API. The field Application Date is not stored directly into a Database table/column, and that is the reason why we can't find it in Integration Center, neither OData API or SFAPI.

How come that we see the field in Ad-Hoc then? - Ad-hoc has some additional columns that are not found in Integration Center. That is because IC is pulling the data straight out from the database, the only information we have there is the information that is stored on the database. Now, on the Ad-Hoc side, we have native calculated columns, which are hardcoded into the product functionality accordingly to the necessity of the customers.

On Ad-hoc, when we see the Application Date column, we are actually seeing a calculation that the system is doing, getting information from the Audit and displaying to us on the field value.

Keywords

ad-hoc, ad, hoc, column, calculated, system, field, hard, coded, application, date, column, missing, can, not, find, found, integration, center, odata, api, sf , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem

Product

SAP SuccessFactors Recruiting all versions