Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Output the data from the ITAB

Former Member
0 Likes
873

Hi

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
848

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.

7 REPLIES 7
Read only

Former Member
0 Likes
848

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...

Read only

Former Member
0 Likes
848

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.

Read only

Former Member
0 Likes
848

Hi

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.

Read only

Former Member
0 Likes
848

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

Read only

Former Member
0 Likes
848

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.......................

Read only

Former Member
0 Likes
848

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.

Read only

Former Member
0 Likes
849

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.