{"id":1939,"date":"2014-06-18T07:25:38","date_gmt":"2014-06-18T05:25:38","guid":{"rendered":"http:\/\/www.karadere.com\/blog\/?p=1939"},"modified":"2014-06-18T07:25:38","modified_gmt":"2014-06-18T05:25:38","slug":"sap-abap-ta-yanlis-programlama","status":"publish","type":"post","link":"https:\/\/www.karadere.com\/blog\/sap-abap-ta-yanlis-programlama.html","title":{"rendered":"Sap Abap ta yanl\u0131\u015f programlama"},"content":{"rendered":"

\"SAP<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

*&———————————————————————*
\n*& Report\u00a0 Zdeneme
\n*&
\n*&———————————————————————*
\n*&
\n*&
\n*&———————————————————————*<\/p>\n

REPORT\u00a0 zes_selections2_2.<\/p>\n

” looplar\u0131 kullanarak asl\u0131nda join le yap\u0131lmal\u0131<\/p>\n

TABLES :\u00a0 vbak, vbap, makt.<\/p>\n

DATA : BEGIN OF itab OCCURS 0,
\nvbeln TYPE vbak-vbeln,
\nerdat TYPE vbak-erdat,
\nposnr TYPE vbap-posnr,
\nmatnr TYPE vbap-matnr,
\nnetwr TYPE vbap-netwr,
\nwaerk TYPE vbap-waerk,
\nmaktx TYPE makt-maktx,
\nEND OF itab.<\/p>\n

DATA : BEGIN OF ls_itab,
\nvbeln TYPE vbak-vbeln,
\nerdat TYPE vbak-erdat,
\nposnr TYPE vbap-posnr,
\nmatnr TYPE vbap-matnr,
\nnetwr TYPE vbap-netwr,
\nwaerk TYPE vbap-waerk,
\nmaktx TYPE makt-maktx,
\nEND OF ls_itab.<\/p>\n

DATA : BEGIN OF itab2 OCCURS 0,
\nvbeln TYPE vbak-vbeln,
\nerdat TYPE vbak-erdat,
\nposnr TYPE vbap-posnr,
\nmatnr TYPE vbap-matnr,
\nnetwr TYPE vbap-netwr,
\nwaerk TYPE vbap-waerk,
\nmaktx TYPE makt-maktx,
\nEND OF itab2.<\/p>\n

DATA : BEGIN OF ls_itab2,
\nvbeln TYPE vbak-vbeln,
\nerdat TYPE vbak-erdat,
\nposnr TYPE vbap-posnr,
\nmatnr TYPE vbap-matnr,
\nnetwr TYPE vbap-netwr,
\nwaerk TYPE vbap-waerk,
\nmaktx TYPE makt-maktx,
\nEND OF ls_itab2.<\/p>\n

SELECT-OPTIONS so_vbeln FOR vbak-vbeln.<\/p>\n

data : lt_vbak type table of vbak .
\ndata : ls_vbak type vbak .<\/p>\n

data : lt_vbap type table of vbap .
\ndata : ls_vbap type vbap .<\/p>\n

data : lt_makt type table of makt .
\ndata : ls_makt type makt .<\/p>\n

select * from vbak
\ninto corresponding fields of table itab
\nwhere vbeln in so_vbeln .<\/p>\n

*”move itab[] to\u00a0 itab2[] .
\nitab2[] = itab[] .<\/p>\n

clear itab[] .
\nrefresh itab .<\/p>\n

LOOP AT itab2 into ls_itab2.<\/p>\n

select * from vbap
\ninto corresponding fields of table lt_vbap
\nwhere vbeln eq ls_itab2-vbeln .<\/p>\n

LOOP AT lt_vbap into ls_vbap .<\/p>\n

itab-vbeln = ls_vbap-vbeln .
\nitab-erdat = ls_vbap-erdat .
\nitab-matnr = ls_vbap-matnr.
\nappend itab .<\/p>\n

ENDLOOP.<\/p>\n

clear lt_vbak[] .
\nrefresh lt_vbak[] .<\/p>\n

ENDLOOP.<\/p>\n

clear itab2[] .
\nrefresh itab2 .<\/p>\n

itab2[] = itab[] .<\/p>\n

clear itab[] .
\nrefresh itab .<\/p>\n

LOOP AT itab2 into ls_itab2.<\/p>\n

select single * from makt
\ninto ls_makt
\nwhere matnr eq ls_itab2-matnr .<\/p>\n

itab-vbeln = ls_itab2-vbeln .
\nitab-erdat = ls_itab2-erdat .
\nitab-matnr = ls_itab2-matnr.
\nitab-maktx = ls_makt-maktx.
\nMODIFY itab index sy-tabix .
\nappend itab .<\/p>\n

endloop.<\/p>\n

“delete itab where matnr is initial .<\/p>\n

LOOP AT itab.
\nWRITE :\/ itab-vbeln ,
\nitab-erdat,
\nitab-posnr,
\nitab-matnr,
\nitab-netwr,
\nitab-waerk,
\nitab-maktx.
\nENDLOOP.<\/p>\n","protected":false},"excerpt":{"rendered":"

Sap Abap ta yanl\u0131\u015f programlama <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[88,41,45],"tags":[395,1725,1837,2346],"class_list":["post-1939","post","type-post","status-publish","format-standard","hentry","category-abap-sap","category-programlama-software","category-sap","tag-abap","tag-programlama","tag-sap","tag-yanlis","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"views":1917,"_links":{"self":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/1939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/comments?post=1939"}],"version-history":[{"count":0,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/1939\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/media?parent=1939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/categories?post=1939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/tags?post=1939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}