topic Is this ABAP statement correct ? in Application Development and Automation Discussions

Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 09:07:30 GMT

Hello Colleague,

I am trying to sum number of seats available in a flight of same carrier type and putting in internal table.

I wrote this statement but sum is coming as 0.

DATA: t_sflight TYPE TABLE OF sflight.

SELECT carrid SUM( seatsmax ) FROM sflight INTO CORRESPONDING FIELDS OF TABLE t_sflight GROUP BY carrid.

If i do the same thing by creatting structure with only these two fields carrid seatsmax then it works fine.

Please let me know is above mentioned statement is correct or not ?

Regards,

Ravi

Re: Is this ABAP statement correct ?

arindam_m — Tue, 14 May 2013 09:16:41 GMT

Hi,

Put this in two work variable like LV_CARRID and LV_SUM then transfer that to the table and do SELECT.. END SELECT.

Cheers,

Arindam

Re: Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 09:18:49 GMT

Hi, that anytime i can do that. But what i am doing is that correct or not ?

Regards,

Ravi

Re: Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 09:21:16 GMT

Hi Ravi,

For aggregate operation/field, by default there is no field name for it, and in your case system would not knwo which correspond field to go into.

Try this.

SELECT carrid SUM( seatsmax ) as seatsmax FROM

sflight INTO CORRESPONDING FIELDS OF TABLE t_sflightGROUP BY carrid.

I guess, it works for 2 fields only structure because you use INTO TABLE instead of

INTO CORRESPONDING FIELDS OF TABLE right?

Hope this helps.

regards,

Xiang Li

Re: Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 09:22:36 GMT

Hi Ravi,

The query is not correct as INTO corresponding fields of table looks for the exact field name to which the fetched data needs to be passed.

The query worked in the other case because you have specified the exact fields to which the fetched data should return.

Hope this explanation helps.

Thanks and Regards,

Sriranjani Chimkaurthy.

Re: Is this ABAP statement correct ?

Venkat_Sesha — Tue, 14 May 2013 09:25:50 GMT

Hi Ravi,

May be nothing wrong your statement. The problem is with the Data at table level.

Even I too get the same sum 0. and a number when created with TYPES.

So check the data in the database table.

You may know other ways to write the same Logic, i dont any comments on those things.

But the above mentioned select should work.

Hope this helps.

Re: Is this ABAP statement correct ?

former_member209920 — Tue, 14 May 2013 09:27:45 GMT

INTO CORRESPONDING FIELDS OF TABLE

IT will ask for exact field name in you internal table.

therefore your query is incorrect.

Re: Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 09:31:25 GMT

Hi,

Problem is with corresponding fields of table.Please create appropriate structure and try it.

I tried the below code and it was working.

TYPES : BEGIN OF ty_sflight ,

        carrid TYPE sflight-carrid,

        seatsmax TYPE sflight-seatsmax,

        END OF ty_sflight.

DATA: t_sflight TYPE TABLE OF ty_sflight,

      l_sflight TYPE ty_sflight.

SELECT carrid SUM( seatsmax ) FROM sflight INTO TABLE t_sflight GROUP BY carrid.

LOOP AT t_sflight INTO l_sflight.

    WRITE :/ l_sflight-carrid, l_sflight-seatsmax.

ENDLOOP.

Regards,

Peri

Re: Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 09:35:37 GMT

corresponding fields of table means i will search for the fields which is present in internal table if its was there then i will get that field info.. so i think statement wt u propose is incorrect..

Re: Is this ABAP statement correct ?

dirk_wittenberg — Tue, 14 May 2013 09:47:34 GMT

Hi,

as Xiang Li already wrote all that's missing is "as seatsmax" behing the "sum(seatsmax)".

With this it should work as it provides the fieldname for the "corresponding" clause.

Regards,

Dirk

Re: Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 10:25:37 GMT

Thank you, Xiang Li.

Re: Is this ABAP statement correct ?

Former Member — Tue, 14 May 2013 11:38:05 GMT

You are most welcome. Thanks for the LIKE and point given.