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

[EvanR · Accepted solution]

Hi Neil, 

Continuing our thread here. I am including screenshots of the suggested code snippet [SUBSTRING(OBJNR,1,2) = 'OR'] working in both extractions and transformations. 

Please let me know if you have any questions.

Thanks,
Evan

[niels1515 · Accepted solution]

Hi Evan, For some reason the filter doesn't work when I use it in a basic extraction. If I use the filter in Advanced Extraction it works. Thanks 🙂 Greetings Niels