SAP Knowledge Base Article - Preview

3263947 - Country Specific Entity field value is free-text (integer) OR picklist for a specific countries but ODATA API fetching random value from picklist although picklist is not configured for that country.

Symptom

Country-specified entity, e.g. PerAddressDEFLT, field address3 is configured as picklist for some countries and configured as field/integer for some countries.

address3 field configured as picklist for some countries and configured as integer/free-text for some countries.

Trying to fetch address3 label (PerAddressDEFLT -> Address3Nav -> PicklistLables -> Label) for a country.

Consider for specific country "Belgium", address3 field is configured as integer/free-text not as picklist. API response for picklist should be null because for that specific country, address3 configured as integer/free-text not picklist. But in this case, API is fetching the random picklist value.

Query:

 https://<api url>/odata/v2/PerAddressDEFLT?$format=json&$filter=personIdExternal eq '800000001951'&$expand=countryNav,countyNav/picklistLabels,cityNav/picklistLabels,stateNav/picklistLabels,address3Nav/picklistLabels,address4Nav/picklistLabels,address7Nav/picklistLabels&$nochche=123

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

Belgium case, "address3" is integer/free-text, not picklist

Response:  but ODATA API, incorrectly link to picklist, and return "Algeria" rather than null.


Read more...

Environment

  • SAP SuccessFactors HCM Suite
    • ODATA API 

Product

SAP SuccessFactors HXM Suite 2211

Keywords

Country specific entity, country specific fields, picklist specific country field, string specific field, random picklist value, ODATA API, Integration Center , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.