Skip to Content
0
Former Member
Nov 26, 2008 at 03:49 PM

How to replicate parentheses using a view?

31 Views

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