SAP Signavio Extraction Filter for M2S JCDS

[niels1515]

Hello experts,

I would like to make my extraction of the JCDS table a little smaller because I only use the numbers of the field OBJNR with the beginning OR* in the transformation. I would also like to use a filters in the extraction. But I have problems with the current filter, because no rows are returned.

my attempt was: OBJNR = 'OR*'

Does anyone have an idea how I can solve this?
Greetings Niels

[RobertT]

Hello Niels

Your syntax of OBJNR = 'OR*' would be checking if there was an OBJNR literally equal to OR*. This is likely why 0 results are returned.

Instead, try looking to filter for OBJNR beginning with OR. The correct syntax would be OBJNR LIKE ‘OR%’.