topic Re: getting the quantity in Application Development and Automation Discussions

getting the quantity

Former Member — Thu, 23 Jul 2009 07:02:12 GMT

hi Guru's

i have trouble in getting the menge.


   Select sum(menge)
   into output_tab-menge
   WHERE MKPF.MBLNR = MSEG.MBLNR 
   and MKPF-MJAHR = MSEG-MBLNR
   AND SPMON(MKPF.BUDAT) = SPMON (PA-BUMON)       
   AND SPMON (MKPF.BUDAT) = SPMON (PA-BUMON)      
   AND MKPF-WERKS = PA-WERKS.
   AND MSEG-BWART IN PA-BWART
   AND MSEG-MATNR = INPUT_TAB-MATNR.

and it is always prompt "incorrect expression"

thank you in advace.

Re: getting the quantity

Former Member — Thu, 23 Jul 2009 07:04:07 GMT

Hi Dranel,

Correct your query.

Select sum(menge)

into output_tab-menge from MKPF

WHERE MKPF.MBLNR = MSEG.MBLNR

and MKPF-MJAHR = MSEG-MBLNR

AND SPMON(MKPF.BUDAT) = SPMON (PA-BUMON)

AND SPMON (MKPF.BUDAT) = SPMON (PA-BUMON)

AND MKPF-WERKS = PA-WERKS.

AND MSEG-BWART IN PA-BWART

AND MSEG-MATNR = INPUT_TAB-MATNR.

Regards,

Vijay

Re: getting the quantity

Former Member — Thu, 23 Jul 2009 07:11:00 GMT

Hi,

Add the FROM table clause in the select statement as below


  Select sum(menge)
   into output_tab-menge
  FROM MKPF
  WHERE MKPF.MBLNR = MSEG.MBLNR 
   and MKPF-MJAHR = MSEG-MBLNR
   AND SPMON(MKPF.BUDAT) = SPMON (PA-BUMON)       
   AND SPMON (MKPF.BUDAT) = SPMON (PA-BUMON)      
   AND MKPF-WERKS = PA-WERKS.
   AND MSEG-BWART IN PA-BWART
   AND MSEG-MATNR = INPUT_TAB-MATNR.

Regards,

Vik

Re: getting the quantity

Former Member — Thu, 23 Jul 2009 07:12:44 GMT

Hi,

You have missed the FROM clause.

Re: getting the quantity

Former Member — Thu, 23 Jul 2009 07:17:37 GMT

MKPF.MBLNR = MSEG.MBLNR is okay

but how can

MKPF-MJAHR be equal to MSEG-MBLNR? You should be having a fiscal year type here, dont you think??

Rgsa

Sameer

Re: getting the quantity

Former Member — Thu, 23 Jul 2009 10:12:46 GMT

hi Vijay,

the error occurs when i modify the code <unknown column name "MENGE"> i already try to change the table and fields that i used but still the error occurs.

loop at mseg_tab.

AT NEW menge.

SUM.

wkl-qty = mseg-menge.

ENDAT.

ENDLOOP.

select sum( menge )

INTO OUTPUT_TAB-menge

FROM MKPF

WHERE MKPF.MBLNR = MSEG.MBLNR

and MKPF-MJAHR = MSEG-MJAHR

AND SPMON(MKPF.BUDAT) = SPMON (PA-BUMON)

AND SPMON (MKPF.BUDAT) = SPMON (PA-BUMON)

AND MKPF-WERKS = PA-WERKS.

AND MSEG-BWART IN PA-BWART

AND MSEG-MATNR = INPUT_TAB-MATNR.

endselect.

is it OK??.,

Re: getting the quantity

Former Member — Thu, 23 Jul 2009 10:33:23 GMT

Hello

Table MKPF not contain field MENGE. Thif field is present in table MSEG.

Try to change table in your query.