Skip to Content

OR operation in DMC_ACSPL_SELECT for different fields

Hi guys,

Using the handy steering table of DMC_ACSPL_SELECT.

An interesting requirement I have: I need the whole FI history for a particular G/L Account and all the data (irrespective of G/L Account) for year 2015 and up.

In other words to filter table BSEG by Year GJAHR with particular years or G/L Account SAKNR with Particular Account Numbers. Something to result in a statement

WHERE GJAHR >= '2015'

     OR SAKNR = '0000051138'

Now if I maintain records as follows, the job just stops with an error in the source...

Any recommendations?

Capture.PNG (16.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 02, 2015 at 06:58 AM

    Ok, I checked short dumps on source system and, apparently, the generated select is using AND operator anyway without asking you 😊 after the "change" of field .

    Which means it is not possible to use an "Or" operand. Still would be nice to see what are the other options for such selections...



    Capture.JPG (12.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 10:11 PM


    I actually found that my Initial load using a view table with relevant selections runs faster than adding filters in DMC_ACSPL_SELECT. However, only for very large tables (+1 billion records).

    You can in LTRS define a Viewtable to be used for Initial load only, and let the normal table be used for replication.

    In the view table, OR statements work fine.

    Add comment
    10|10000 characters needed characters exceeded