ABAP query..

[Former Member]

I want to select all customers from table KNKK into internal table where KKBER = '1000' and CRBLB = 'X' or GRUPP = 'Z'.

How can I do this ?

[Former Member]

>

> I want to select all customers from table KNKK into internal table where KKBER = '1000' and CRBLB = 'X' or GRUPP = 'Z'.
> 
> 
> How can I do this ?

select * from KNKK
into table it_knkk
where KKBER = '1000'
         and ( CRBLB = 'X'  or GRUP = 'Z' ).

[Former Member]

Try this:

select kunnr

from KNKK

into table i_kunnr

where ( KKBER = '1000' AND

CRBLB = 'X' ) or

GRUPP = 'Z'.

[Former Member]

It sys incorrect nesting. Structure should be concluded by endselect,,,

[Former Member]

In my sys. there is no syntax error for this code

data: i_kunnr type standard table of kunnr.

select kunnr

from KNKK

into table i_kunnr

where ( KKBER = '1000' AND

CRBLB = 'X' ) or

GRUPP = 'Z'.

Regards,

joy.

[Former Member]

Rajesh - please use a more meaningful subject line. This is the ABAP forum so any query shoud be about ABAP.

You have to decide what your logic should be and place parenthesis correctly to implement that logic. But only you can tell what that logic should be.

Rob

[Former Member]

<LOCKED BY MODERATOR - USE APPROPRIATE TITLES>

Greetings,

Blag.