topic Re: ABAP query.. in Application Development and Automation Discussions

ABAP query..

Former Member — Thu, 31 Jul 2008 20:05:46 GMT

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 ?

Re: ABAP query..

Former Member — Thu, 31 Jul 2008 20:09:10 GMT


> 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' ).

Re: ABAP query..

Former Member — Thu, 31 Jul 2008 20:11:35 GMT

Try this:

select kunnr

from KNKK

into table i_kunnr

where ( KKBER = '1000' AND

CRBLB = 'X' ) or

GRUPP = 'Z'.

Re: ABAP query..

Former Member — Thu, 31 Jul 2008 20:13:28 GMT

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

Re: ABAP query..

Former Member — Thu, 31 Jul 2008 20:14:02 GMT

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

Re: ABAP query..

Former Member — Thu, 31 Jul 2008 20:21:15 GMT

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.

Re: ABAP query..

Former Member — Thu, 31 Jul 2008 20:29:49 GMT

<LOCKED BY MODERATOR - USE APPROPRIATE TITLES>

Greetings,

Blag.