internal table

[Former Member]

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.

[Former Member]

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

[Former Member]

hey,

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

Regards,

Midhun Abraham

[Former Member]

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?

[KK07]

Hi Sandeep,

welcome to sdn.

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

[Former Member]

hi

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.

[Former Member]

Hi,

Please check whether SPFLI table having any values or not.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.