topic Re: SUM in select query in Application Development and Automation Discussions

SUM in select query

former_member671224 — Wed, 02 Dec 2009 22:14:28 GMT

Hi all,

Im need to sum the amount for same company, account, document number and posting key. and my select query is as below;

SELECT bukrs
                   hkont
                   gjahr
                   belnr
*              buzei
                   bschl
                   sum( dmbtr ) as amount
              into CORRESPONDING FIELDS OF TABLE t_recs1
              from BSIS
              where bukrs = bukrs
                and hkont = saknr
                and ( bschl = lc_debit_asset or
                      bschl = lc_credit_asset )
              GROUP BY bukrs hkont gjahr belnr bschl
              order BY bukrs hkont gjahr belnr bschl.

But the amount (DMBTR) is displaying as 0.00 though the amount exist in table BSIS.

Can someone hlep mein this?

Thanks,

Amal

Re: SUM in select query

Former Member — Wed, 02 Dec 2009 22:37:12 GMT

and the sy-subrc is 0?

Re: SUM in select query

former_member671224 — Thu, 03 Dec 2009 00:35:43 GMT

Yes.

SY-SUBRC = 0 and also Im getting all other fields as expected except DMBTR.

Thanks,

Amal

Re: SUM in select query

Former Member — Thu, 03 Dec 2009 01:08:38 GMT

Field DMBTR might be blank for all the fetched records.

Re: SUM in select query

former_member671224 — Thu, 03 Dec 2009 01:41:32 GMT

I checked in table and its having some value (other than zero ) for DMBTR.

Thanks,

Amal

Re: SUM in select query

Clemenss — Thu, 03 Dec 2009 02:38:22 GMT

Hi Amal,

you fetch it AS amount, so the data are stored in field amount of your internal table t_recs1. Hope this field exists.

Regards,

Clemens

Re: SUM in select query

Former Member — Thu, 03 Dec 2009 06:24:59 GMT

hi amal,

have you checked that amount field is present in t_recs1 table

also check the data type you have defined the amount field as.Is it integer or is it TYPE dmbtr.

i think it should be integer.

hope this will help you

thanks

Tanmaya

Re: SUM in select query

Clemenss — Thu, 03 Dec 2009 12:03:16 GMT

Hi Tanmaya,

thank you for repeating my post.

Regards,

Clemens