Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL QUERY PROBLEM?

Guys,

In the below select statement in where clause i want add

object = 'prog' and object = 'tabl' and object = 'domain'

how i can add these conditions.

please help on this.

SELECT OBJECT

OBJ_NAME

SRCSYSTEM

FROM TADIR

INTO TABLE IT_TADIR_FIN

WHERE OBJECT = 'PROG'

AND ( OBJ_NAME LIKE 'Y%'

OR OBJ_NAME LIKE 'Z%' ).

Excellent reward is compulsary.

regards,

vijay

Tags:
Former Member
replied

Hi,

SELECT OBJECT
OBJ_NAME
SRCSYSTEM
FROM TADIR
INTO TABLE IT_TADIR_FIN
WHERE ( OBJ_NAME LIKE 'Y%'
OR OBJ_NAME LIKE 'Z%' )
<b>AND ( ( OBJECT EQ 'PROG') OR
      ( OBJECT EQ 'TABL') OR
      ( OBJECT EQ 'DOMAIN') ).</b>

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question