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](/tools/odata-filter-builder) to generate these automatically!