topic Re: Output the data from the ITAB in Application Development and Automation Discussions

Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:10:27 GMT

This is ravi

please help me to write the code .

■ Create a work area of following fields-

o KNA1-KUNNR

o KNA1-LAND1

o KNA1-ORT01

o KNA1-SPRAS

o KNA1-REGIO

■ Create an internal table of the above structure

■ Fetch 10 rows of data from KNA1 table and populate

the ITAB in step 2

■ Output the data from the ITAB

Re: Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:15:15 GMT

Hi,

DATA :  BEGIN OF ITAB OCCURS 0,
         KUNNR LIKE KNA1-KUNNR,
	 LAND1 LIKE  KNA1-LAND1,
	 ORT01 LIKE  KNA1-ORT01,
	 SPRAS LIKE KNA1-SPRAS,
	 REGIO LIKE KNA1-REGIO,
       END OF ITAB.

STRAT-OF-SELECTION.


SELECT * FROM KNA1 INTO CORRESPONDING FIELDS OF TABLE ITAB UPTO 10 ROWS.


LOOP AT ITAB.
 WRITE : ITAB-KUNNR,ITAB-LAND1,ITAB-ORT01,ITAB-SPRAS,ITAB-REGIO.
ENDLOOP.

Regards,

V.Balaji

Reward if Usefull...

Re: Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:15:46 GMT

data: begin of itab,

kunnr like KNA1-KUNNR,

land1 like KNA1-LAND1,

ort01 like KNA1-ORT01,

spras like KNA1-SPRAS,

regio like KNA1-REGIO,

end of itab.

data: wa like itab.

data: itab1 like itab occurs 0.

select * from kna1 into corresponding fields of table itab1.

loop at itab.

write:/ itab1-kunnr,...

endloop.

Re: Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:17:22 GMT

types : begin of st_kna1,

kunnr type kunnr,

land1 type land1,

ort01 type ort01,

SPRAS type spras,

REGIO type regio,

end of st_kna1.

data : it_kna1 type standard table of st_kna1,

wa_kna1 type st_kna1.

select kunnr land1 ort01 spras regio from kna1 into table it_kna1 up to 10 rows.

loop at it_kna1 into wa_kna1.

write:/ wa_kna1-kunnr,

wa_kna1-land1,

wa_kna1-ort01,

wa_kna1-spras,

wa_kna1-regio.

endloop.

Re: Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:18:14 GMT

hi,

data : begin of itab occurs 0,

kunnr type KUNNR

land1 type LAND1

ort01 type ORT01

spras type SPRAS

REGIO type regio,

end of itab.

data : wa type itab.

start-of-selection.

select kunnr land1 ort01 spras regio from kna1 into table itab upto 10 rows.

loop at itab into wa.

write : wa-kunnr,wa-land1,wa-ort01,wa-spras, wa-regio.

endloop.

hope this is useful

Reward points.

Madhavi

Re: Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:19:48 GMT

types: begin of x_kna1,

kunnr type kna1-kunnr,

land1 type kna1-land1,

ort01 type kna1-ort01,

spras type kna1-spras,

regio type kna1-regio,

end of x_kna1.

data: it_kna1 type standard table of x_kna1,

wa_kna1 type x_kna1.

select kunnr land1 ort01 spras regio from kna1 upto 10 rows into table it_kna1.

loop at it_kna1 into wa_kna1.

write:/ wa_kna1-kunnr,

20 wa_kna1-land1,

30 wa_kna1-ort01,

40 wa_kna1-spras,

50 wa_kna1-regio.

clear wa_kna1.

endloop.

reward if useful.......................

Re: Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:23:23 GMT

Hi,


TYPES:    BEGIN OF t_kna1,
          kunnr  TYPE kunnr,
          land1   TYPE land1_gp,
         END OF t_kna1.

* Internal Table

DATA:i_kna1  TYPE STANDARD TABLE OF t_kna1,
     wa_kna1 TYPE t_kna1.


SELECT kunnr land1 FROM kna1
UP TO 10 ROWS
INTO TABLE i_kna1.

LOOP AT i_kna1 INTO wa_kna1.
  WRITE: wa_kna1-kunnr.

ENDLOOP.

Re: Output the data from the ITAB

Former Member — Mon, 31 Mar 2008 06:24:23 GMT

Hi,

I have used Work Area,

TYPES :  begin of ty_itab ,
      kunnr type kna1-kunnr,
      land1 type  kna1-land1,
      ort01 type  kna1-ort01,
      spras type kna1-spras,
      regio type kna1-regio,
     end of ty_itab.

data: itab type STANDARD TABLE OF ty_itab,
      wa_itab TYPE ty_itab.
START-OF-SELECTION.


select kunnr
      land1
      ort01
      spras
      regio
      from kna1
      into table itab
      up to 10 rows.

loop at itab into wa_itab .
  write :/ wa_itab-kunnr,wa_itab-land1,wa_itab-ort01,wa_itab-spras,wa_itab-regio.
endloop.

Regards,

Brown.