REPORT ZLMN_DEN_001.
TABLES : ZKITAP.
" Select up to 1 rows ile ilk satiri oku.
Select * from zkitap up TO 1 rows.
write : Zkitap-kitap_no, zkitap-kitap_adi.
Endselect.
--------------------------------------------
ABAP SELECT SINGLE
REPORT ZLMN_DEN_001.
TABLES : ZKITAP.
"Select single ile ilk satırı oku.
SELECT SINGLE * FROM ZKITAP.
WRITE:/ ZKITAP-KITAP_NO, ZKITAP-KITAP_ADI.
---------------------------------------------
SELECT ENDSELECT
REPORT ZLMN_DEN_001.
TABLES : ZKITAP.
DATA : MY_KITAP_NO TYPE ZKITAP-KITAP_NO,
MY_KITAP_ADI TYPE ZKITAP-KITAP_ADI.
SELECT KITAP_NO KITAP_ADI INTO (MY_KITAP_NO,MY_KITAP_ADI)
FROM ZKITAP.
WRITE :/ MY_KITAP_NO, MY_KITAP_ADI.
ENDSELECT.
------------------------------------------------
ITAB MOVE
REPORT ZLMN_DEN_001.
TABLES : ZKITAP.
DATA : ITAB TYPE STANDARD TABLE OF ZKITAP WITH HEADER LINE.
SELECT * FROM ZKITAP.
MOVE-CORRESPONDING ZKITAP TO ITAB.
APPEND ITAB.
ENDSELECT.
loop at ITAB.
WRITE : / ITAB-KITAP_NO.
Endloop.
-----------------------------------------------
INTERNAL TABLO KOPYALAMA
REPORT ZLMN_DEN_001.
TABLES : ZKITAP, ZYAZAR, ZMATBAA.
DATA : ITAB TYPE STANDARD TABLE OF ZKITAP WITH HEADER LINE.
DATA : ITAB_IKI TYPE STANDARD TABLE OF ZKITAP WITH HEADER LINE.
SELECT *
INTO TABLE ITAB
FROM ZKITAP.
ITAB_IKI[] = ITAB[].
LOOP AT ITAB_IKI.
WRITE : / ITAB_IKI-KITAP_NO.
ENDLOOP.
-----------------------------------------------
APPENDDING
REPORT ZLMN_DEN_001.
TABLES : ZKITAP, ZYAZAR, ZMATBAA.
DATA : ITAB LIKE HASHED TABLE OF ZKITAP WITH HEADER LINE WITH UNIQUE KEY KITAP_NO.
SELECT * FROM ZKITAP APPENDING CORRESPONDING FIELDS OF TABLE ITAB WHERE KITAP_NO < 10.
LOOP AT ITAB.
WRITE : / ITAB-KITAP_NO.
ENDLOOP.
-----------------------------------------------
REPORT ZLMN_DEN_001.
TABLES : ZKITAP.
DATA : ITAB LIKE HASHED TABLE OF ZKITAP WITH HEADER LINE WITH UNIQUE KEY KITAP_NO.
SELECT * FROM ZKITAP INTO CORRESPONDING FIELDS OF TABLE ITAB WHERE KITAP_NO < 100.
LOOP AT ITAB.
WRITE : / ITAB-KITAP_NO.
ENDLOOP.
----------------------------------------------
Heshed internal tabloya veri gönderimi
REPORT ZLMN_DEN_001.
DATA : ITAB LIKE HASHED TABLE OF ZKITAP WITH HEADER LINE WITH UNIQUE KEY KITAP_NO.
select * from zkitap into table itab where kitap_no < 20.
loop at itab.
write : / itab-kitap_no.
endloop.
----------------------------------------------
Standart Internal Tabloya veri gönderimi
REPORT ZLMN_DEN_001.
TABLES : ZKITAP, ZYAZAR, ZMATBAA.
DATA : ITAB TYPE STANDARD TABLE OF ZKITAP WITH HEADER LINE.
SELECT *
INTO TABLE ITAB
FROM ZKITAP.
LOOP AT ITAB.
WRITE : / ITAB-KITAP_NO, ITAB-KITAP_ADI, ITAB- SAYFA_SAYISI.
ENDLOOP.
------------------------------------------------
***********************************************************
Serkan AKKAVAK
Bilgisayar Mühendisi
serkurumsal@yandex.com
SAP ve ABAP konusunda tüm sorun ve sorularınızı gönderebilirsiniz.
Social Plugin