topic Re: Re:select statement in Application Development and Automation Discussions

Re:select statement

Former Member — Thu, 31 Jan 2008 09:49:40 GMT

Hi when I writing the following select statement

SELECT SUM( menge )

INTO sumgood

FROM aufm

WHERE ( bwart EQ '101' or bwart EQ 'X01' )

AND matnr EQ it_afpo-matnr

AND aufnr EQ t_prodbom-aufnr.

It gives me a error message the statement is not accesible,

Pls send the modified statement, give u full points.

regards

Sasi

Re: Re:select statement

Former Member — Thu, 31 Jan 2008 09:53:20 GMT

sumgood should be the same type of menge

u need to use for all entries

Re: Re:select statement

Former Member — Thu, 31 Jan 2008 09:53:27 GMT

If you are written it in a REPORT program,

try to insert 'START-OF-SELECTION' before the query.

ie,

START-OF-SELECTION.

QUERY.

Re: Re:select statement

Former Member — Thu, 31 Jan 2008 09:55:15 GMT

Hi,

SELECT SINGLE SUM( menge )

INTO sumgood

FROM aufm

WHERE ( bwart EQ '101' or bwart EQ 'X01' )

AND matnr EQ it_afpo-matnr

AND aufnr EQ t_prodbom-aufnr.

Cheers,

Will.

Re: Re:select statement

Former Member — Thu, 31 Jan 2008 09:55:52 GMT

Hi,

can u give me u r entire code so that i can try to coreect it.

Regards

sunil

Re: Re:select statement

RaymondGiuseppi — Thu, 31 Jan 2008 09:56:52 GMT

If i remove the two following lines,

AND matnr EQ it_afpo-matnr
AND aufnr EQ t_prodbom-aufnr.

and define

sumgood LIKE aufm-menge

the program works well. so, the question is :

Are it_afpo and t_prodbom internal table with header line?

, if not use explicit work area, or use a SELECT FOR ALL ENTRIES syntax.

Regards

Re: Re:select statement

Former Member — Thu, 31 Jan 2008 09:57:35 GMT

sashi,

Use GROUP BY caluse in your select statement.

Ex:

SELECT SUM( menge )

INTO sumgood

FROM aufm

WHERE ( bwart EQ '101' or bwart EQ 'X01' )

AND matnr EQ it_afpo-matnr

AND aufnr EQ t_prodbom-aufnr

GROUP BY matnr." Here on which field base you are summing the merge"

Don't forget to reward if useful....

Re: Re:select statement

Former Member — Thu, 31 Jan 2008 10:01:10 GMT

Sashi,

TRY like this also.

WHERE bwart IN ( '101' , 'X01' ).

SELECT SUM( menge )

INTO sumgood

FROM aufm

WHERE bwart IN ( '101' , 'X01' )

AND matnr EQ it_afpo-matnr

AND aufnr EQ t_prodbom-aufnr.

Don't forget to reward if useful....

Re: Re:select statement

Former Member — Thu, 31 Jan 2008 10:09:09 GMT

Hi,

Check the syntax of SUM:

SUM( [DISTINCT] col ) Determines the sum of the content of the column col in the resulting set or in the current group. The data type of the column has to be numerical.

Regards,

Bhaskar