OData Filter Cheat Sheet for SAP Developers

OData filters are one of the most powerful — and misunderstood — features of SAP services. This guide covers everything you need.

Basic Comparison Operators

Operator	Meaning	Example
eq	Equals	Material eq 'MAT-001'
ne	Not Equals	MaterialType ne 'FERT'
gt	Greater Than	Price gt 100.00
ge	Greater or Eq	StockQty ge 0
lt	Less Than	ValidTo lt datetime'2024-12-31T00:00:00'
le	Less or Eq	Weight le 50

String Functions (OData v4)

$filter=contains(Description,'SAP')
$filter=startswith(MaterialNumber,'Z')
$filter=endswith(Supplier,'GmbH')
$filter=toupper(Country) eq 'DE'

OData v2 vs v4 Differences

The most common gotcha is date handling:

OData v2 (SAP Gateway):

$filter=CreatedOn eq datetime'2024-06-01T00:00:00'

OData v4 (S/4HANA Cloud):

$filter=CreatedOn eq 2024-06-01

Logical Operators

Combine filters with and / or:

$filter=Plant eq '1000' and MaterialType eq 'ROH'
$filter=Country eq 'DE' or Country eq 'AT'

Use our OData Filter Builder to generate these automatically!