How to replicate parentheses using a view?

Former Member — Wed, 26 Nov 2008 15:49:29 GMT

Hi,

I want to create a view, but I have some problem to replicate some concept that normally I use within SQL here in a R/3 system.

I have created this view inside SE11:

CABN ATNAM LIKE '%_MOD' OR

CABN ATNAM LIKE 'SC4%_102' AND

CABN ATNAM NOT LIKE '%_MOD'

The problem is that I can't use the parentheses inside the transaction

Using the parentheses, I have to create something like this:

CABN ATNAM LIKE '%_MOD' OR

(CABN ATNAM LIKE 'SC4%_102' AND

CABN ATNAM NOT LIKE '%_MOD')

Any idea to solve this problem?

Thank you a lot

Re: How to replicate parentheses using a view?

Former Member — Fri, 28 Nov 2008 13:40:27 GMT

Hi.

CABN ATNAM LIKE '%_MOD' OR  " 1
CABN ATNAM LIKE 'SC4%_102' AND  CABN ATNAM NOT LIKE '%_MOD'  " 2

Create one view with first condition and then use created view in another

view with second conditions.