topic Re: Select Query problem.. in Application Development and Automation Discussions

Select Query problem..

Former Member — Mon, 27 Jun 2011 07:30:25 GMT

why doesnt this select query work....??

Am confused bcoz i need to check BLART from a set function and AUGBL and BELNR from internal table of type BSEG.

SELECT * FROM bsas INTO TABLE it_bsas

for ALL ENTRIES IN t_set_values

where blart <> t_set_values-from(2)

GROUP BY augbl belnr

HAVING augbl = i_bseg1-augbl

and belnr = i_bseg1-belnr.

following is the error message :

The addition "GROUP BY" only makes sense with a field list.

Re: Select Query problem..

Former Member — Mon, 27 Jun 2011 07:42:58 GMT

1 . the use of blart is not correct it should be blart = itab-field .

2. Group by is obsolete and puts extra load on the server and lead to poor performance . Instead process the data in the internal table after selecting without group by from data base .

Re: Select Query problem..

Former Member — Mon, 27 Jun 2011 08:36:33 GMT

thanks for the reply.

t_set_values is the set function

i just missed the equal sign .....but the problem is

how can i check the data from i_bseg1 itab even with comparing belnr augbl from i_bseg1 table...

DATA: t_set_values TYPE TABLE OF rgsb4 WITH HEADER LINE,

wa_itabsetvalues TYPE rgsb4,

itab_set_values LIKE TABLE OF t_set_values.

DATA: BEGIN OF xyz OCCURS 0,

value TYPE bkpf-blart,

END OF xyz.

DATA it_bsas TYPE TABLE OF bsas WITH HEADER LINE.

CALL FUNCTION 'G_SET_GET_ALL_VALUES'

EXPORTING

client = sy-mandt

FORMULA_RETRIEVAL = ' '
LEVEL = 0

setnr = 'ZHDFC_SET_DOCTYPE'

VARIABLES_REPLACEMENT = ' '

table = 'BKPF'

class = '0000'

NO_DESCRIPTIONS = 'X'
NO_RW_INFO = 'X'
DATE_FROM =
DATE_TO =

fieldname = 'BLART'

TABLES

set_values = t_set_values

EXCEPTIONS
SET_NOT_FOUND = 1
OTHERS = 2

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

SELECT * FROM bsas INTO TABLE it_bsas

for ALL ENTRIES IN t_set_values

where blart = t_set_values-from(2)

GROUP BY augbl belnr

HAVING augbl = i_bseg1-augbl

and belnr = i_bseg1-belnr.