topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Wed, 08 Oct 2008 04:40:03 GMT

Hi Gurus,

Ive defined the internal table like this

itab type standard table of SPFLI with header line.

select * from spfli into itab.

write : itab-carrid.

though it is activated, it does not give an o/p

I also tried

itab type standard table of SPFLI

wa type spfli.

select * from SPFLI into table itab.

loop at itab into wa.

write : wa-carrid.

endloop.

This does not work either.

Any help on this would be appreciated.

Re: internal table

Former Member — Wed, 08 Oct 2008 04:42:44 GMT

Hi Sandeep,

Welcome to SDN.

Try this

data:
       itab type 
standard table 
          of SPFLI 
       with header line.

select * 
  from spfli 
    into table itab.

loop at itab.
   write :/  itab-carrid.
endloop.

Actualy, SPFLI is the name of a database structure as well as the corresponding data table if you won't put table addition to into statement, system will treat it like structure and so is not getting displayed.

Regards,

Anirban

Re: internal table

Former Member — Wed, 08 Oct 2008 04:44:55 GMT

hey,

Just put a break-point and debugg that you will get the solution.

Regards,

Midhun Abraham

Re: internal table

Former Member — Wed, 08 Oct 2008 04:45:15 GMT

Hi,

Are you sure it picking the data? just check Sy-subrc value and sy-dbcnt value. n check data is present in internal table or not?

Re: internal table

KK07 — Wed, 08 Oct 2008 04:45:28 GMT

Hi Sandeep,

welcome to sdn.

try in debugging mode by entering /h and see where its going wrong.have u checked the table?

Re: internal table

Former Member — Wed, 08 Oct 2008 04:46:18 GMT

This is the code..and please learn basics perfectly:

data:itab type standard table of SPFLI with header line.

select * from spfli into table itab.

loop at itab.

write : / itab-carrid.
 endloop.

Regards,

Vishwa.

Re: internal table

Former Member — Wed, 08 Oct 2008 04:47:41 GMT

Hi,

Please check whether SPFLI table having any values or not.

Re: internal table

Former Member — Wed, 08 Oct 2008 04:48:47 GMT

Define the internal table like this.

Data: begin of It_tab occurs 0,

end of it_tab.

Data: wa_itab like line of it_tab.

Select * from splfi into table it_tab.

Loop at it_tab into wa_tab.

endloop.

Re: internal table

Former Member — Wed, 08 Oct 2008 04:50:42 GMT

Hi Sandeep,

its working fine in my system.


DATA : ITAB TYPE STANDARD TABLE OF SPFLI WITH HEADER LINE.


SELECT * FROM SPFLI INTO  ITAB.

ENDSELECT.

WRITE : ITAB-CARRID.

i think data is not avialable in your system.

Re: internal table

Former Member — Wed, 08 Oct 2008 04:55:27 GMT

Hi Sandeep,

use this code

data:itab type standard table of SPFLI with header line.

select * from spfli into table itab.

loop at itab.

write : / itab-carrid.

endloop.