topic Re: select problem in Application Development and Automation Discussions

select problem

Former Member — Sun, 09 Jul 2006 13:08:36 GMT

this work

SELECT SINGLE SUM( mzubb )

SUM( magbb )

FROM s033

INTO (z_mzubb , z_magbb )

WHERE werks = <ls_mard>-werks

AND lgort = <ls_mard>-lgort

AND matnr = <ls_mard>-matnr

AND sptag BETWEEN date and date_e.

and this dont work in the same prog

i mean i dont have data in is033 (in se16 i get value)

SELECT mblnr

sptag

matnr

lgort

werks

mzubb

magbb

FROM s033

INTO CORRESPONDING FIELDS OF TABLE is033

WHERE werks = <ls_mard>-werks

AND lgort = <ls_mard>-lgort

AND matnr = <ls_mard>-matnr

AND sptag BETWEEN date and date_e.

Re: select problem

Manohar2u — Sun, 09 Jul 2006 13:16:17 GMT

Use second select statement to have sptag in internal table for your further processing.

Regds

Manohar

Re: select problem

Former Member — Sun, 09 Jul 2006 13:16:46 GMT

Try the GROUP BY CLAUSE addition

SELECT SINGLE SUM( mzubb )

SUM( magbb )

FROM s033

INTO (z_mzubb , z_magbb )

WHERE werks = <ls_mard>-werks

AND lgort = <ls_mard>-lgort

AND matnr = <ls_mard>-matnr

AND sptag BETWEEN date and date_e

GROUP BY WERKS LGORT MATNR .

Regards,

Ravi

Re: select problem

Former Member — Sun, 09 Jul 2006 13:32:35 GMT

Ah but in order to use the group by you would need to have those fields in the select.... (SQL 1/1) and using select single would then still limit you to the first row...

Re: select problem

Former Member — Sun, 09 Jul 2006 17:44:54 GMT

You should remove select single. and should added by group clause of the fields you have added in your select query.