topic hi in Application Development and Automation Discussions

hi

Former Member — Tue, 20 May 2008 09:43:06 GMT

SELECT SINGLE SUM(ERFMG) FROM MSEG INTO ITAB-ERFMG WHERE MBLNR = ITAB-MBLNR AND LGORT = 'FGS' AND BWART = '101'.

this stmt is not working why?

Re: hi

Former Member — Tue, 20 May 2008 09:47:48 GMT

you need spaces Abap is very sensitive with that

try


SUM( ERFMG )

or what was the exact error ?

regards

Re: hi

Former Member — Tue, 20 May 2008 09:51:44 GMT

i have given space but stil not giving output. Its saying Sum un known coloumn name

Re: hi

prasanth_kasturi — Tue, 20 May 2008 10:00:19 GMT

HI,

I THINK YOU HAVE GIVEN SPACE BETWEEN SUM AND THE BRACKET.

GIVE THE FOLLOWING WAY

SUM( ERFMG ).

REWARD IF HELPFUL

PRASANTH

Re: hi

Former Member — Tue, 20 May 2008 10:08:17 GMT

Hi Anuradha,

try this code

SELECT  SUM(ERFMG) 
        INTO ITAB-ERFMG
         FROM MSEG 
          WHERE MBLNR = ITAB-MBLNR 
          AND LGORT = 'FGS'
         AND BWART = '101'.

IF Found Helpfull DO Reward.

Regards.

Eshwar.

Re: hi

Former Member — Tue, 20 May 2008 11:06:07 GMT

hi there....

i think the error is here

MBLNR = ITAB-MBLNR

u cannot apply this as itab currently is empty....

here itab is not the internal table but the work area which is empty when the query is called. u need to put this inside a loop at itab to get the query working.

do reward if helpful.

Re: hi

Former Member — Tue, 20 May 2008 16:44:28 GMT

Hi,

Actually sum you should't use in select querys why becuase it is a performance issue.

anyhow, your select query is in loop or not. if it is in loop ok. but it is not in loop

itab-mblnr is empty so it won't work. then you have to read that table itab.

if it is one time requirement you can use read statement.

or it is required for all entries in itab then you have use loop.

below 2 eg are there 1st one is for read table and 2nd one is looping table

Eg: read table itab with key mblnr = mblnr.

Eg:

loop at itab.

select query.

endloop.

Regard

Ganesh

Re: hi

Former Member — Tue, 20 May 2008 18:15:10 GMT

Hi Anuradha,

I have checked this query now and its working 100% correctly.

 
SELECT sum( erfmg )
        INTO lv_erfmg
         FROM mseg
          WHERE mblnr = '4900000010'
          AND lgort = '1020'
         AND bwart = '561'.

Check: There is no gap between sum and starting bracket also check your doc number in debug mode.. if its not in compatible format thats in table no data will be fetched. You will have to apeend zeros or something.

Please award points to all correct answers in this thread and mark question as answered.

Thanks,

Ags..

Re: hi

Former Member — Tue, 27 May 2008 09:23:49 GMT

y thr is necessary to SUM

ur using select single ,only one value will come .

use either select single erfmg

or select sum( erfmg )

as per ur requirement.

Re: hi

former_member787646 — Wed, 28 May 2008 01:46:31 GMT

Hi,

Try this.

IF NOT ITAB-MBLNR IS INITIAL.

SELECT SUM( ERFMG ) FROM MSEG INTO

ITAB-ERFMG WHERE MBLNR = ITAB-MBLNR

AND LGORT = 'FGS' AND BWART = '101'.

ENDIF.

Hope it helps you.

Murthy.

Re: hi

Former Member — Wed, 28 May 2008 04:58:35 GMT

Hi,

In your code ...

********************

SELECT SINGLE SUM(ERFMG) FROM MSEG INTO ITAB-ERFMG WHERE MBLNR = ITAB-MBLNR AND LGORT = 'FGS' AND BWART = '101'.

Change it like this.....

SELECT SINGLE SUM( ERFMG ) FROM MSEG INTO ITAB-ERFMG WHERE MBLNR = '10032333' AND LGORT = 'FGS' AND BWART = '101'.

*********************************

So in your the mistakes is the way you gave Sum(ERFMG) it shopuld be like Sum( ERFMG ) and in the where clause you cant use a field of itab as it is still initial...

Reward if helpful.

Regards,

Syed