topic Re: By using Internal Table in Application Development and Automation Discussions

By using Internal Table

Former Member — Mon, 12 Feb 2007 04:33:52 GMT

Hi all,

Could u please write the below program by using a Internal table and without using Endselect.

Example to find the number of passengers, the total luggage

weight, and the average weight of the luggage for all Lufthansa flights on 02/28/2001:

DATA: count TYPE I,

sum TYPE P DECIMALS 2,

avg TYPE F,

connid LIKE sbook-connid.

SELECT connid COUNT( * ) SUM( luggweight ) AVG( luggweight )

INTO (connid, count, sum, avg)

FROM sbook

WHERE

carrid = 'LH ' AND

fldate = '20040424'

GROUP BY connid.

WRITE: / connid, count, sum, avg.

ENDSELECT.

Thanks in Advance

Sri...

Re: By using Internal Table

Former Member — Mon, 12 Feb 2007 04:36:30 GMT

data : begin of itab occurs 0,

carrid like spfli-carrid,

count type i,

sum like sbook-luggweight,

avg like sbook-luggweight,

end of itab.

SELECT connid COUNT( * ) SUM( luggweight ) AVG( luggweight )

INTO table itab FROM sbook

WHERE

carrid = 'LH ' AND

fldate = '20040424'

GROUP BY connid.

regards

shiba dutta

Re: By using Internal Table

Former Member — Mon, 12 Feb 2007 04:39:01 GMT

Use this code:


data: begin of it_out occurs 0,
        connid type sbook-connid,
        count type i,
        sum type i,
        avg type i,
      end of it_out.

SELECT connid COUNT( * ) SUM( luggweight ) AVG( luggweight )
INTO TABLE it_out
FROM sbook
WHERE
carrid = 'LH ' AND
fldate = '20040424'
GROUP BY connid.

LOOP AT it_out.
  write: it_out-connid, it_out-count, it_out-sum, it_out-avg.
ENDLOOP.

Re: By using Internal Table

Former Member — Mon, 12 Feb 2007 04:42:36 GMT

hi dude,

in your sample code, the author uis not using any internal table. he is using select and end select for which INTO internal table is not required, he directly passing the values to the variables and writing them.

Any how for ur reference consieder this example:

Types: Begin of t_mara,

mara type mara-matnr,

maktx like mara-maktx,

end of i_mara. This is the structue.

The internal table for it will declared as :

Data: I_mara type standard table of t_mara.

The Work area as :

Data: Wa_mara type t_mara.

Regards,

vinay

Re: By using Internal Table

Former Member — Mon, 12 Feb 2007 04:43:19 GMT

Hi krishna,

DATA: begin of itab occurs 0,

count TYPE I,

sum TYPE P DECIMALS 2,

avg TYPE F,

connid LIKE sbook-connid,

end of itab.

SELECT connid COUNT( * ) SUM( luggweight ) AVG( luggweight )

INTO table itab

FROM sbook

WHERE

carrid = 'LH ' AND

fldate = '20040424'

GROUP BY connid.

loop at itab.

write:/itab-connid,itab-count,itab-sum.

endloop.

regards,

keerthi

Re: By using Internal Table

former_member192022 — Mon, 12 Feb 2007 04:56:13 GMT

DATA: BEGIN OF itab occurs 0,

connid LIKE sbook-connid,

count TYPE i,

sum TYPE sbook-luggweight,

avg TYPE sbook-luggweight,

end of itab.

select connid COUNT( * ) SUM( luggweight ) AVG( luggweight )

into table itab from sbook group by connid .

loop at itab.

write:/ itab-connid,itab-count, itab-sum, itab-avg.

endloop.

Re: By using Internal Table

Former Member — Mon, 12 Feb 2007 05:06:44 GMT

use select single

like following without using endselect.

DATA: count TYPE I,

sum TYPE P DECIMALS 2,

avg TYPE F,

connid LIKE sbook-connid.

SELECT SINGLE connid COUNT( * ) SUM( luggweight ) AVG( luggweight )

INTO (connid, count, sum, avg)

FROM sbook

WHERE

carrid = 'LH ' AND

fldate = '20040424'

GROUP BY connid.

WRITE: / connid, count, sum, avg.

Thanks

sarath