Skip to Content
0
Former Member
Jul 09, 2006 at 01:08 PM

select problem

29 Views

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.

<b>and this dont work in the same prog

i mean i dont have data in is033 (in se16 i get value)</b>

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.