Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata


Sometimes not all data existing in the systems should be compared. The reason might be that the comparison of some data is meaningless or that you would like to restrict the data to different organizational units.

An example for the first case would be if data has to be released before it is send to the target systems (e.g. service orders have to be released in a central customer care system before they are replicated to a maintenance systems). In this case an comparison of unreleased service orders would be useless as they exist by definition only in the source system. As this behaviour is build into the process it would not make sense to allow end users to change this filter but it should be build into your data model. To allow this type of filtering model specific filters can be maintained which are valid for all comparisons using this model. 

An example of the second case could be required if multiple organizational units with different responsibles work in the same system. In this case it might be sensible to define comparisons for each responsible where the employee sees only the data he or she is responsible for. The actual data model for each responsible is identical but he should see only a subset of the data. To do this comparison specific filters can be defined as well.

Sometimes you would like to filter on values for multiple fields in the same comparison. In this case it is important that you provide a well-defined relation ship between the different filter values. An example could be that you would like to compare sales orders for certain sales organisations and distribution channel. If you would provide only the information you are interested in data for sales organization 1, sales organization 2, distribution channel A and distribution channel B the data selection would consider all possible combinations which are the value pairs (sales organization 1, distribution channel A), (sales organization 1, distribution channel B), (sales organization 2, distribution channel A), (sales organization 2, distribution channel B).

This might be okay for most cases but if you are only interested in the combinations (sales organization 1, distribution channel A), (sales organization 2, distribution channel B) you need to provide the relationship, which can be done via filter sets.

Model specific filters

To define a model specific filter select the field you would like to apply a filter to in the graphical model display. 

Comparison specific filters

Filter Sets ("Expert Filters")

Using relative date syntax

There are many use cases, where the comparison shall be time-dependent. For example, you only want to compare documents created yesterday, or during the last month. Entering static date filter values does not make sense here, because you would have to adapt the comparison filters before each run. To achieve a relative date filtering, which means calculating relative dates instead of absolute dates, CDC provides a special syntax on how define fix points and offsets for relative dates.

Syntax for Relative Dates

Instead of a fixed (absolute) date, you can enter a special keyword for the start date (prefixed by a $ character) and optionally an additional offset as difference in days.

Syntax = <StartDate>[<Difference>]

For <StartDate> the following keywords are available:

Keyword for <StartDate>


Example using 2013/04/25 as Reference Date


Current date (today)



First day of current week



Last day of current week



First day of current month



Last day of current month


$FDOCQFirst day of current quarter2013/04/01
$LDOCQLast day of current quarter2013/06/30


First day of current year



Last day of current year



First day of previous week



Last day of previous week


$FDOPQFirst day of previous quarter2013/01/01
$LDOPQLast  day of previous quarter2013/03/31


First day of previous month



Last day of previous month



First day of previous year



Last day of previous year



First day of next week



Last day of next week



First day of next month



Last day of next month


$FDONQFirst day of next quarter2013/07/01
$LDONQLast day of next quarter2013/09/30


First day of next year



Last day of next year


$CWEEKCurrent calendar week (offset in weeks)201317
$FIPECFiscal Period (current)


$FIPEPFiscal Period (previous)003.2013

These additional keywords are meant for full timestamps only:

Keyword for <StartDate>


Example for 2013/04/25 at 08:21:47 with offset -2


Time stamp now (offset in seconds)

2013/04/25 08:21:45


Time stamp now (offset in minutes)

2013/04/25 08:19:47


Time stamp now (offset in hours)

2013/04/25 06:21:47


Time stamp now (offset in days)

2013/04/23 08:21:47


absolute hour
(+=today / -=yesterday)

2013/04/24 02:00:00


current full hour (offset in hours)

2013/04/25 06:00:00


Delta mode (timestamp of last run)


The optional <Difference> is entered as positive or negative offset (usually in days, unless otherwise noted)

  • using '+' increments days (= move start date into the future)
  • using '-' decrements days (= move start date into the past)


  • $TODAY-2 = day before yesterday
  • $TODAY+2 = day after tomorrow

The relative date selection can be combined in ranges (using the LOW and HIGH fields of the selection criteria), e.g. to define "between" intervals.

Example: You want to filter the documents which have a creation date in last month. The selection criteria would be <FieldName> = $FDOPM to $LDOPM.

  • No labels