Skip to Content
avatar image
ADNAN ZAFAR

Query transftorm where clause

Feb 25, 2018 at 03:43 PM | 64 Views

hi guys

In bods query transform i m trying to write a where clause to filter on a material number. I am able to filter one material number but how can i filter on multiple material numbers. Syntax i m using is

TABLE1.MATERIAL = '10001234'

SAP Data Services
BW Data Modeling (WHM) | query transform
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Dirk Venken
    Feb 25, 2018 at 09:59 PM

    Use IN or OR:

    1. TABLE1.MATERIAL in (‘A’,’B’)
    2. TABLE1.MATERIAL = ‘A’ or TABLE1.MATERIAL = ‘B’
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    ADNAN ZAFAR
    Feb 26, 2018 at 08:48 AM

    thanks Dirk.. i know that was very elementary but i am new to it. Appreciate your help.

    Add comment
    10|10000 characters needed characters exceeded