topic join table SUM using for all entries in Application Development and Automation Discussions

join table SUM using for all entries

muhammad_sohail — Mon, 06 Dec 2010 07:39:18 GMT

Dear All,

Will anyone pls. tell me what is the problem in this query, it is not working.

SELECT aufnr SUM( menge )

INTO CORRESPONDING FIELDS OF TABLE itab_aufnr

FROM mkpf

INNER JOIN mseg ON mseg_{mblnr EQ mkpf}mblnr AND mkpf_{mjahr EQ mseg}mjahr

FOR ALL ENTRIES IN itab_rework

WHERE mseg~aufnr = itab_rework-aufnr

GROUP BY aufnr.

Regards,

Moderator message: please search for available information before asking, "it's not working" is not a proper error description.

Edited by: Thomas Zloch on Dec 6, 2010 9:41 AM

Re: join table SUM using for all entries

kesavadas_thekkillath — Mon, 06 Dec 2010 07:45:00 GMT

Your syntax check will clearly explain the problem. Aggregate functions are not allowed with for all entries.

Please check yourself before posting because the syntax message itself explains thats.

Re: join table SUM using for all entries

muhammad_sohail — Mon, 06 Dec 2010 07:53:46 GMT

It's means that I cannot use aggregate functions with for all entries, but I want to take the sum() on the basis of aufnr. When I have used it in loop it is taking so much time to execute.

How I should solve this problem.

Thanks.

Re: join table SUM using for all entries

kesavadas_thekkillath — Mon, 06 Dec 2010 07:59:07 GMT


When I have used it in loop it is taking so much time to execute.

That depends upon the amount of data you are processing and the set of codes written inside the loop. For sum you have to use collect statement or a SUM statement inside a control break statement.