SAP Knowledge Base Article - Public

2820617 - How to Filter Multiple Values in a non filterable Field using Value Look Up Table in Calculated Filter - Integration Center


For cases of complex integration scenario which requires :

(1) To filter Multiple field values from a customfield with non filterable property.

(2) Usage of a calculated filter to replace multiple if/then/else statement(s).

Using Value LookUp Table on Calculated Filter is an option

Note:  custom field(s) with non filterable property is standard behavior for Odata APIs, in integration center the requirement can be achieved using calculated filter's post query result processing.

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


SAP Successfactors HCM Suite Integration Center

Reproducing the Issue

Use Case : Need to filter out records with ‘BestRun France (2200)’,’BestRun USA (3000)’ and ‘Null’ records from Custom Field 5 of User entity in the report.

Remarks : User Entity > Custom Fields are hardcoded set to filterable = false

not filterable.jpg


Custom field(s) with non filterable property is standard behavior for Odata APIs


See Sample Application for the Use Case mentioned.

First,see Original Output of Report without Value Look Up Table – Calculated Filter. Records for Users with ‘BestRun France (2200)’,’ BestRun USA (3000)’ are showing.

CF iniital.jpg

1.0 Apply Value Look Up Table – Calculated Filter

     1.1   Go to Filter and Sort Tab > Advanced filter > Calculate filter

Select Field Value > Select your Custom Field you wish to apply the filter to


    1.2   Then the put in the value lookup table the values NOT needed in report .

Items in screenshot of value lookup table contains ‘NULL’ and ‘BestRun USA and France’. The intention is to remove from the resport records with these value.


Note : Guide info link > Calculated filter is defined as a negative filter logic.That is, it filters out the value based on the condition, instead of filtering in

    1.3   Now, see result Output Below.

CF after.png

 Records are filtered from the report satisfying the requirement, working around the limitation for if/then/else statement allowed to be put in the calculated filter.

Note : Max Value Look Up table items is restricted up to up to 300 via CSV upload file using the Upload Sample CSV or Manually you can enter values up to 1000.


See Also

Integration Center Successfactors HCM Suite Guide


Value LookUp Table, Caculated Filter, Custom Field Filter, Customizable Field Filtering, filterable=false , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To


SAP SuccessFactors HCM Core all versions


Test Sample VLT via CF (1).docx