topic Re: SOLVE THIS QUERY in Application Development and Automation Discussions

SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:14:10 GMT

HI SAP GURUS,

SELECT SUM( dmbtr ) INTO w_dmbtr10

FROM bsis

WHERE belnr = it_input-belnr

AND hkont = it_input-racct

AND gjahr = it_input-gjahr

AND bukrs = 'BP01'

AND shkzg = 'S'.

I HAVE GIVEN THAT IN A LOOP.

SY-SUBRC ALWAYS EQUALS ZERO. WHAT S WRONG WITH THAT QUERY??

Re: SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:16:18 GMT

U can do one thing.

take all the dmbtr in one internal table and then loop into that internal table and calculate the SUM.

Re: SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:20:31 GMT

Hi,

Instead of doing sum inside the query within loop. First fetch your query

then loop and add up dmbtr.

Thanks & Regards

Re: SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:22:46 GMT

hi anurodh and ranjit

i do agree what u r saying . i just want to know what s the problem with that query..

Re: SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:22:57 GMT

Hi Rakesh,

Even if the select query does not fetch any entries SUM is calculated as zero, so that only its

giving sy-subrc as zero (Not sure).

SELECT  dmbtr INTO TABLE it_dmbtr10 
FROM bsis 
WHERE belnr = it_input-belnr 
AND hkont = it_input-racct
AND gjahr = it_input-gjahr 
AND bukrs = 'BP01'
AND shkzg = 'S'.

IF sy-subrc EQ 0.
LOOP AT it_dmbtr10.
   "Calculate the sum
ENDLOOP.
ENDIF.

Try like this.

Hope this helps you.

Regards,

Manoj Kumar P

Edited by: Manoj Kumar on Jan 13, 2009 6:23 AM

Re: SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:24:24 GMT

Hi,

First select all the dmbtr values into one internal table with all your requirements and then u can find the SUM. and avoid select statement inside the loop statement.

Thanks.

Re: SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:34:54 GMT

Hi Rakesh,

I think this sy-subrc problem comes because of the SUM function which u used in the select statement.

Thanks.

Re: SOLVE THIS QUERY

Former Member — Tue, 13 Jan 2009 05:36:10 GMT

the sy-subrc always shows zero bcoz of that sum .even the wrbtr is 0 .

solved the problem

Re: SOLVE THIS QUERY

I355602 — Tue, 13 Jan 2009 05:42:08 GMT

Hi,

Try it this way, it will work:-


DATA : v_dmbtr TYPE bsis-dmbtr.

START-OF-SELECTION.
  SELECT SUM( dmbtr ) INTO (v_dmbtr) 
  FROM bsis 
  WHERE belnr = it_input-belnr 
  AND hkont = it_input-racct
  AND gjahr = it_input-gjahr 
  AND bukrs = 'BP01'
  AND shkzg = 'S'.

END-OF-SELECTION.
WRITE : / v_dmbtr.

Hope this solves your problem.

Thanks & Regards,

Tarun Gambhir