SAP Knowledge Base Article - Public

3413104 - payComponentCode field from EmpPayCompNonRecurring is coming as blank in SFAPI

Symptom

When performing an SFAPI query to EmpPayCompNonRecurring entity, the payComponentCode field is not returning any data.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
    • SFAPI

Reproducing the Issue

  1. The SFAPI call below is performed:

    <queryString>SELECT pay_date,payComponentCode,user_id FROM EmpPayCompNonRecurring WHERE (person_id_external IN ('1111'))</queryString>

  2. The response contains no value in payComponentCode:

    <sfobject>
        <id>EMPCN-4324</id>
        <type>EmpPayCompNonRecurring</type>
        <pay_date>2020-01-01</pay_date>
        <payComponentCode xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <user_id>1111</user_id>
    </sfobject>

Cause

The value of payComponentCode will return null if the pay component on current day is inactive.

This happens only in SFAPI, in OData this status check is not done.

Resolution

Please make sure that the pay component being selected is active at the day the query is performed.

See Also

Deprecation of Partner API, SFAPI Adhoc, and SFAPI for Simple Entities | SAP Help Portal

Keywords

sfapi, deprecated, status, active, inactive, paycomponent, pay component, pay component code, , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Problem

Product

SAP SuccessFactors HCM Suite all versions