【正文】 60。 Select * from zflight into int_fligh. Append int_fligh. Clear int_fligh. Endselect. 推薦 Refresh: int_fligh. Select * from zflight into table int_fligh. 使用批量修改內(nèi)表代替逐行修改 不推薦 Loop at int_fligh. If int_flighflag is initial. Int_flighflag = ‘X’. Endif. Modify int_fligh. Endloop. 推薦 Int_flighflag = ‘X’. Modify int_fligh transporting flag where flag is initial. 使用二分法查詢，提高查詢內(nèi)表數(shù)據(jù)速度 不推薦 Read table int_fligh with key airln = ‘LF’. 推薦 Read table int_fligh with key airln = ‘LF’ binary search. 兩個(gè)內(nèi)表添加使用批量增加代替逐行 不推薦 Loop at int_fligh1. Append int_fligh1 to int_fligh2. Endloop. 推薦 Append lines of int_fligh1 to int_fligh2. 使用table buffering Use of buffered tables is remended to improve the performance considerably. The buffer is bypassed while using the following statements Select distinct Select … for update Order by, group by, having clause Joins Use the Bypass buffer addition to the select clause in order to explicitly bypass the buffer while selecting the data. 使用FOR ALL Entries 不推薦 Loop at int_try. Select single * from zfligh into int_fligh where try = int_trytry. Append int_fligh. Endloop. 推薦 Select * from zfligh appending table int_fligh For all entries in int_try Where try = int_trytry. 正確地使用where語句，使查詢能使用索引 When a base table has multiple indices, the where clause should be in the order of the index, either a primary or a secondary index To choose an index, the optimizer checks the field names specified in the where clause and then uses an index that has the same order of the fields. One more tip is that if a table begins with MANDT, while an index does not, there is a high possibility that the optimizer might not use that index. 1正確地使用MOVE語句 Instead of using the movecorresponding clause it is advisable to use the move statement instead. Attempt should be made to move entire internal table headers in a single shot, rather than moving the fields one by one. 1正確地使用inner join Let us take an example of 2 tables, zairln and zflight. The table zairln has the field airln, which is the airline code and the field lnnam, which is the name of the airline. The table zflight has the field airln, the airline code and other fields which hold the details of the flights that an airline operates. Since these 2 tables a re logically joined by the airln field, it is advisable to use the inner join. Select a~airln a~lnnam b~fligh b~try into table int_airdet From zairln as a inner join zflight as b on a~airln = b~airln. In order to restrict the data as per the selection criteria, a where clause can be added to the above inner join. 1使用sort by 代替order by 1避免使用SELECT DISTINCT語句 使用的 ABAP SORT + DELETE ADJACENT DUPLICATES 代替.posted @ 20081202 14:10 hyladmin 閱讀(12) | 評(píng)論 (0) |編輯 屏幕設(shè)計(jì) 屏幕是SAP系統(tǒng)和用戶對(duì)話的媒介，在應(yīng)用程序中定義，并從R/3系統(tǒng)應(yīng)用層傳送給顯示層進(jìn)行顯示并接收用戶輸入。之前我們大量開發(fā)的ABAP報(bào)表用到的選擇界面和列表屏幕的定義及用戶交互的觸發(fā)、接收和相應(yīng)過程，是由ABAP程序來控制的。而今天才知道原來標(biāo)準(zhǔn)屏幕可以由開發(fā)人員進(jìn)行布局設(shè)計(jì)和繪制，并調(diào)用ABAP模塊。這首次讓我感到ABAP原來還有點(diǎn)面向?qū)ο蟆? 來說一個(gè)簡(jiǎn)單的例子（HELLO WORD的經(jīng)典例子）： REPORT demo_hello_world. * Selection Screen PARAMETERS input(12) TYPE c DEFAULT 39。Hello World!39。. * Dynpro CALL SCREEN 100. * List SKIP TO LINE 10. POSITION 40. WRITE input. 如果將這個(gè)程序COPY到SE38中嘗試運(yùn)行，一定會(huì)報(bào)錯(cuò)，因?yàn)槠聊?00未定義。屏幕定義的事務(wù)代碼是SE51，也可以通過雙擊 CALL SCREEN 100的100進(jìn)入屏幕編輯器。 屏幕編輯器分為三個(gè)部分： ：定義屏幕類型，NEXT SCREEN:定義當(dāng)前屏幕的后續(xù)屏幕序號(hào)，即系統(tǒng)的對(duì)話處理器結(jié)束當(dāng)前屏幕的處理之后，應(yīng)前往的下一個(gè)屏幕。如果沒有設(shè)置該項(xiàng)，則默認(rèn)的后續(xù)屏幕為當(dāng)前屏幕本身。 這個(gè)時(shí)候可以按“格式”按鈕進(jìn)行布局設(shè)計(jì)。這個(gè)界面有一些圖標(biāo)對(duì)應(yīng)于個(gè)中屏幕元素，拖曳這些圖標(biāo)到設(shè)計(jì)區(qū)域，就可以在相應(yīng)的位置添加屏幕元素了。 這個(gè)程序的運(yùn)行結(jié)果是兩個(gè)屏幕，第一個(gè)屏幕默認(rèn)一個(gè)輸入框：39。Hello World!，第二個(gè)屏幕是一個(gè)輸入框，默認(rèn)值也是 hello world！按“其次”按鈕可以進(jìn)入WRITE界面，輸出值posted @ 20081202 14:09 hyladmin 閱讀(13) | 評(píng)論 (0) |編輯 系統(tǒng)變量的表SYST 系統(tǒng)內(nèi)部有一個(gè)專門存放系統(tǒng)變量的表SYST（可以用SE11來查看）,其中最常用的系統(tǒng)變量有: SYSUBRC: 系統(tǒng)執(zhí)行某指令后,表示執(zhí)行成功與否的變量,’0’ 表示成功： 例如：SELECT后找到合適的記錄，SYSUBRC=0。 系統(tǒng)運(yùn)行時(shí)，用AUTHORITYCHECK進(jìn)行權(quán)限檢 查，通過的話SY SUBRC=0。 SYUNAME: 當(dāng)前使用者登入SAP的USERNAME。 SYDATUM: 當(dāng)前系統(tǒng)日期。 SYUZEIT: 當(dāng)前系統(tǒng)時(shí)間。 SYTCODE: 當(dāng)前執(zhí)行程序的Transaction code SYINDEX : 當(dāng)前LOOP循環(huán)過的次數(shù) SYTABIX: 當(dāng)前處理的是internal table 的第幾筆 SYTMAXL: Internal table的總筆數(shù) SYSROWS: 屏幕總行數(shù)。 SYSCOLS: 屏幕總列數(shù)。 SYMANDT: 當(dāng)前系統(tǒng)編號(hào)(CLIENT NUMBER) SYVLINE: 畫豎線 SYULINE: 畫橫線 SYDBCNT:DB 操作: 處理過的表行號(hào),例如：SELECT共查詢到幾條記錄 SYLSIND:清單處理, 明細(xì)清單索引，指示了當(dāng)前列表的級(jí)別。比如0是基本列號(hào)，1是第一級(jí)明細(xì)列表。 posted @ 20081202 14:08 hyladmin 閱讀(15) | 評(píng)論 (0) |編輯 SUBMIT的幾種情況 最普通的用法 *Code used to execute a report SUBMIT Zreport. 帶selectoptions程序的Submit的用法 *Code used to populate 39。selectoptions39。 amp。 execute report DATA: seltab type table of rsparams, seltab_wa like line of seltab. seltab_waselname = 39。PNPPERNR39。. seltab_wasign = 39。I39。. seltab_waoption = 39。EQ39。. * load each personnel number accessed from the structure into * parameters to be used in the report loop at pnppernr. seltab_walow = pnppernrlow. append seltab_wa to seltab. endloop. SUBMIT zreport with selectiontable seltab via selectionscreen. 帶parameters程序的Submit的用法 *Code used to populate 39。parameters39。 amp。 execute report SUBMIT zreport with p_param1 = 39。value39。 with p_param2 = 39。value39。. 其他情況 *Submit report and return to current program afterwards SUBMIT zreport AND RETURN. *Submit report via its own selection screen SUBMIT zreport VIA SELECTIONSCREEN. *Submit report using selection screen variant SUBMIT zreport USING SELECTIONSET 39。VARIANT139。. *Submit report but export resultant list to memory, rather than *it being displayed on screen SUBMIT zreport EXPORTING LIST TO MEMORY. * Once report has finished and control has returned to calling * program, use function modul