Skip to Content
avatar image
Former Member

Select SUM in FOR ALL ENTRIES Select Query

Hi ,

I am using for all entries select statment ,can any one guide me how can i use SUM in the select statment with for all entries .

Regards,

Veera

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 11, 2007 at 05:26 PM

    try this

    Select vbeln sum(netwr ) into table itab

    From vbak

    For all entries in itab2

    Where vbeln = itab2-vbeln.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 11, 2007 at 05:33 PM

    Not sure if you can use this way.

    A

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2007 at 05:36 PM

    I think you also need to use Group by vbeln at end of the statement.

    try it

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2007 at 05:41 PM

    I am sorry, for all entries excludes all aggregate functions except count.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 11, 2007 at 05:44 PM

    Hi,

    THis is not possible using for all entries.

    Thanks,

    Sriram Ponna.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      you can use range object.

      before, you should fill range object from itab after than you can use where condition.