‎2008 Mar 31 7:10 AM
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
‎2008 Mar 31 7:24 AM
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.
‎2008 Mar 31 7:15 AM
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...
‎2008 Mar 31 7:15 AM
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.
‎2008 Mar 31 7:17 AM
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.
‎2008 Mar 31 7:18 AM
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
‎2008 Mar 31 7:19 AM
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.......................
‎2008 Mar 31 7:23 AM
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.
‎2008 Mar 31 7:24 AM
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.