CDC mode filter on the SAP extractors

I want to place a filter on the extractor using CDC mode for 0FI_GL_14 during import. The filter conditions required is on field BELNR. I have BELNR EQUAL 0090070070. But it didn’t work. It simply ignore this filter and loaded everything. What will be the correct way to define this filter on extractor using CDC mode?

In addition, if I want to add a filter for BUDAT, the posting date, what will be the filter condition if I want to restrict to only ‘03/01/2012’?

The extractors residing on SAP ECC system with sql server DB.

Thanks,
S


sxu (BOB member since 2012-05-07)

Isn’t that kind of odd you configure an extractor to get delta and then restrict it to a single document number? So you will do an initial load for this single document and will get changes of this single document only. I assume there is something else why you have this requirement - please explain.

BUDAT filter makes sense, you do not care about data created 20 years ago, so you go to the object library -> right click the extractor instance and select properties. There is the superscription dialog where it says CDC mode, you can add a filter in the SAP syntax.

BUDAT greater 20120301


Werner Daehn :de: (BOB member since 2004-12-17)