cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Signavio Extraction Filter for M2S JCDS

niels1515
Explorer
0 Kudos
522

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

View Entire Topic
EvanR
Employee
Employee

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

 

EvanR_0-1715852693452.png

EvanR_1-1715852699768.png

 

 

niels1515
Explorer
0 Kudos
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