topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Thu, 15 Jun 2006 07:25:25 GMT

Hi everyone!

How do I modify this statment to summarize ZNEDSLAG-ZZOMSTOTAL on distinct kunnr (customernumber)?

SELECT SUM( zzomstotal ) INTO zvarenytt_i-sentrallager FROM znedslag

WHERE kunnr IN s_kunnr.

TABLE ZNEDSLAG:

kunnr zzvar zzomstotal

30005 A 10

30005 B 10

30006 C 9

30007 D 2

RESULT I WANT:

zzomstotal

Best regards,

Jørgen

Re: Select statement

Former Member — Thu, 15 Jun 2006 07:29:22 GMT

data: begin of itab occurs 0,

kunnr type kunnr,

zzomstotal like znedslag-zzomstotal,

end of itab.

SELECT kunnr SUM( zzomstotal ) INTO itabFROM znedslag group by kunnr

WHERE kunnr IN s_kunnr.

append itab.

endselect.

Re: Select statement

Former Member — Thu, 15 Jun 2006 07:42:21 GMT

DATA : Sum TYPE i.

sum = 0 .

Read table ZNEDSLAG into zvarenytt_i with key Kunnr .

if sy-subrc = 0.

sum = sum + zvarenytt_i-zzomstotal.

endif.

Write sum.

Rgds,

Jothi.

Mark useful answers.

Re: Select statement

Former Member — Thu, 15 Jun 2006 07:43:29 GMT

It is advised not to use Aggregate functions.

select KUNNR ZZOMSTOTAL

into table itab

where kunnr in s_kunnr.

if sy-subrc eq 0.

sort s_kunnr by kunnr zzomstotal.

loop at itab.

at end of kunnr.

SUM.

write : itab-zzsomstotal.

*C-- You will get the sum of value for distinct kunnr.1

endat.

endloop.

endif.

Re: Select statement

Former Member — Thu, 15 Jun 2006 07:48:25 GMT

Okey, thanks! So it's not posible to do this without using an internal table?

Re: Select statement

Former Member — Thu, 15 Jun 2006 08:02:52 GMT

ya u have to need internal table or variable to store the sum value . after store value into variable u update z table with condition kunnr.