SAP_ABAP基礎(chǔ)語法培訓(xùn)教程

1、1會(huì)計(jì)學(xué)SAP_ABAP基礎(chǔ)語法培訓(xùn)教程基礎(chǔ)語法培訓(xùn)教程2021-12-122021-12-132021-12-14TR司庫司庫后勤系統(tǒng)后勤系統(tǒng)財(cái)務(wù)系統(tǒng)財(cái)務(wù)系統(tǒng)人力資源人力資源客戶及工業(yè)部門的客戶及工業(yè)部門的特殊要求特殊要求2021-12-152021-12-162021-12-172021-12-18 SAP 業(yè)務(wù)流程業(yè)務(wù)流程S&D 銷售訂單 PP主生產(chǎn)計(jì)劃物料需求計(jì)劃采購訂單庫存管理生產(chǎn)執(zhí)行開票運(yùn)輸生產(chǎn)訂單發(fā)票校驗(yàn)成本財(cái)務(wù) MMCO/FI2021-12-192021-12-1102021-12-1112021-12-1122021-12-1132021-12-1142021-12-

2、1152021-12-1162021-12-1172021-12-1182021-12-1192021-12-120導(dǎo)航區(qū)域工具區(qū)域?qū)ο罅斜砀綄俅翱?021-12-121事務(wù)碼SE382021-12-1222021-12-1232021-12-1242021-12-1252021-12-126XXXXXX（公司文本） 庫存分析報(bào)表頁 數(shù)：XXX工廠代碼：XXXX會(huì)計(jì)年度：XXXX會(huì)計(jì)期間：XX庫存總價(jià)：XXXX.XX(貨幣碼)報(bào)表生成者：XXXXXXXX物料類型物料號(hào)碼物料描述庫存地點(diǎn)非限制使用庫存限制使用庫存庫存單位價(jià)格總價(jià)(貨幣碼)HALB100-100GG-25000144.000 11

3、38.000 PC196.37￥232,109.34008810.000 10.000 PC196.37￥3,927.40sum54.0001143.000PC196.37￥236,036.74sumxxxxx.xxxxxxxxx.xxx Xxxxx.xx￥xxxxxxx.xx簽字：_簽字：_簽字：_2021-12-1272021-12-1282021-12-1292021-12-1302021-12-1312021-12-1322021-12-133程序內(nèi)部全局?jǐn)?shù)據(jù)定義對(duì)話模塊事件塊子程序等ABAP程序2021-12-1342021-12-1352021-12-1362021-12-1372

4、021-12-1382021-12-1392021-12-1402021-12-1412021-12-1422021-12-1432021-12-1442021-12-1452021-12-1462021-12-1472021-12-1482021-12-1492021-12-1502021-12-1512021-12-1522021-12-1532021-12-1542021-12-1552021-12-1562021-12-157初始值類型為字符串存儲(chǔ)長度15個(gè)字節(jié)2021-12-1582021-12-159數(shù)據(jù)類型初始值說明示例CSPACE文本字符串NameN000.0數(shù)字文本01234

5、T000000時(shí)間150028D00000000日期20091231I0整型345F0浮點(diǎn)數(shù)5E+04P0壓縮數(shù)123,456,789.000X0十六進(jìn)制數(shù)3A2021-12-1602021-12-1612021-12-1622021-12-1632021-12-1642021-12-1652021-12-1662021-12-1672021-12-168運(yùn)算數(shù)學(xué)表達(dá)式語句關(guān)鍵字語句加法n = x + y.ADD y TO x.減法n = x - y.SUBTRACT y FROM x.乘法n = x * y.MULTIPLY x By y.除法n = x / y.DIVIDE x BY y.

6、整除n = x DIV y.取余n = x MOD y.冪n = x * y.2021-12-1692021-12-170函數(shù)名稱說明ABS( X )返回輸入?yún)?shù)的絕對(duì)值SIGN( X )返回輸入?yún)?shù)符號(hào)，正數(shù)返回1，0返回0，負(fù)數(shù)返回-1TRUNC( X )返回輸入?yún)?shù)的整數(shù)部分FRAC( X )返回輸入?yún)?shù)的小數(shù)部分CEIL( X )返回不小于輸入?yún)?shù)的最小整數(shù)值FLOOR( X )返回不大于輸入?yún)?shù)的最大整數(shù)值2021-12-171函數(shù)名稱說明Cos,Sin,Tan三角函數(shù)Acos,Asin,Atan反三角函數(shù)Cosh,Sinh,Tanh雙曲函數(shù)Exp底數(shù)為e(2.7182818285)

7、的冪函數(shù)Log/Log10底數(shù)為e/10的對(duì)數(shù)SQRT平方根2021-12-1722021-12-1732021-12-174數(shù)據(jù)類型輸出長度對(duì)齊方式C變量長度左對(duì)齊N變量長度左對(duì)齊T6左對(duì)齊D8左對(duì)齊F2*變量長度右對(duì)齊I11右對(duì)齊P2*變量長度(+1個(gè)小數(shù)位）右對(duì)齊2021-12-1752021-12-176運(yùn)算符意義EQ或=等于NE或或不等于LT或小于LE或大于GE或=大于等于2021-12-1772021-12-1782021-12-1792021-12-1802021-12-1812021-12-1822021-12-1832021-12-1842021-12-1852021-12-

8、1862021-12-1872021-12-1882021-12-1892021-12-1902021-12-1912021-12-1922021-12-1932021-12-1942021-12-1952021-12-1962021-12-1972021-12-1982021-12-1992021-12-1100運(yùn)算符含義s1 CO s2如果s1僅包含s2中的字符，則為真s1 CN s2如果s1還包含s2外的字符，則為真s1 CA s2如果s1包含任意一個(gè)s2中的字符，則為真s1 NA s2如果s1不包含s2中的字符，則為真s1 CS s2如果s1包含字符串s2，則為真s1 NS s2如果s

9、1不包含字符串s2，則為真s1 CP s2如果s1包含模式s2，則為真s1 NP s2如果s1不包含模式s2，則為真2021-12-11012021-12-11022021-12-11032021-12-11042021-12-11052021-12-11062021-12-11072021-12-1108idnameageIdNameage2021-12-11092021-12-11102021-12-11112021-12-11122021-12-11132021-12-11142021-12-11152021-12-11162021-12-11172021-12-11182021-12-

10、1119內(nèi)表工作區(qū)讀取數(shù)據(jù)行更新數(shù)據(jù)行2021-12-11202021-12-1121標(biāo)準(zhǔn)表排序表哈希表索引訪問允許允許不允許關(guān)鍵字訪問允許允許允許相同值關(guān)鍵字行可重復(fù)可重復(fù)或不可重復(fù)不可重復(fù)推薦訪問方式主要通過索引主要通過關(guān)鍵字只能通過關(guān)鍵字2021-12-11222021-12-11232021-12-11242021-12-1125append to .collect into .表結(jié)構(gòu) carrconnumsatz carrconnumsatzlh04003925.00 lh04003925.00 dl169924500.00 dl169924500.00 dl198413100.00

11、 dl198413100.00 lh04005700.00 lh04005700.00 9625.00 lh040236750.00 lh040236750.00 lh04003925.00 2021-12-11262021-12-11272021-12-11282021-12-11292021-12-11302021-12-1131n不能指定偏移量和長度n成功分配給，sy-subrc返回0，否則為42021-12-11322021-12-11332021-12-11342021-12-11352021-12-11362021-12-11372021-12-11382021-12-113920

12、21-12-11402021-12-11412021-12-11422021-12-11432021-12-11442021-12-11452021-12-11462021-12-11472021-12-11482021-12-11492021-12-11502021-12-11512021-12-11522021-12-11532021-12-11542021-12-11552021-12-11562021-12-11572021-12-11582021-12-11592021-12-11602021-12-11612021-12-11622021-12-11632021-12-116420

13、21-12-11652021-12-11662021-12-11672021-12-11682021-12-11692021-12-11702021-12-11712021-12-11722021-12-11732021-12-11742021-12-11752021-12-11762021-12-11772021-12-11782021-12-11792021-12-11802021-12-11812021-12-1182q1xxx （無此形式）2021-12-11832021-12-11842021-12-1185子句說明SELECT SELECT 子句定義選 擇的結(jié)果是 單行還是一 個(gè)表

14、、選擇 的是哪些列 、以及是否 將排除相同 的行。 即：定義選擇的結(jié)果FROM FROM 子句指定即 將從中選取 數(shù)據(jù)的數(shù)據(jù) 庫表或視圖 。 即：指定將讀取的數(shù)據(jù)庫表INTO INTO 子句確定即 將讀入選定 數(shù)據(jù)的目標(biāo) 區(qū) 。 該子句也可 以放在FROM 子句之前。 如果沒有指 定 INTO 子句，系統(tǒng) 將使用表工 作區(qū)。表工 作區(qū)是由 TANLES 語句自動(dòng)創(chuàng) 建的表頭行 。即：為選定的數(shù)值指定目標(biāo)區(qū)WHERE WHERE 子句指定將 按照指定的 條件讀取哪 些行來作為 選擇。即：選擇（篩選）條件GROUP BY GROUP-BY 子句從幾行 組成的組中 產(chǎn)生了作為 結(jié)果的單行 。一個(gè)組是

15、 在 中列出的列 中有相同值 的行的集合 。即：給行分組ORDER BY ORDER-BY 子句為選定 的行定義順 序 。即：指定行的順序2021-12-11862021-12-11872021-12-11882021-12-11892021-12-11902021-12-11912021-12-11922021-12-11932021-12-11942021-12-11952021-12-11962021-12-11972021-12-11982021-12-11992021-12-12002021-12-12012021-12-12022021-12-12032021-12-1204202

16、1-12-12052021-12-12062021-12-12072021-12-12082021-12-12092021-12-1210開始運(yùn)行程序初始化過程選擇屏幕處理單行數(shù)據(jù)讀取(邏輯數(shù)據(jù)庫或者Select循環(huán)全體數(shù)據(jù)處理列表輸出單行數(shù)據(jù)處理2021-12-12112021-12-12122021-12-12132021-12-12142021-12-12152021-12-12162021-12-12172021-12-12182021-12-12192021-12-12202021-12-12212021-12-12222021-12-12232021-12-12242021-12-

17、12252021-12-12262021-12-12272021-12-12282021-12-12292021-12-12302021-12-12312021-12-12322021-12-12332021-12-12342021-12-12352021-12-12362021-12-12372021-12-12382021-12-12392021-12-12402021-12-12412021-12-12422021-12-12432021-12-12442021-12-12452021-12-12462021-12-1247XXXXXX（公司文本） 庫存分析報(bào)表頁 數(shù)：XXX工廠代碼：XXXX會(huì)計(jì)年度：XXXX會(huì)計(jì)期間：XX庫存總價(jià)：XXXX.XX(貨幣碼)報(bào)表生成者：XXXXXXXX物料類型物料號(hào)碼物料描述庫存地點(diǎn)非限制使用庫存限制使用庫存庫存單位價(jià)格總價(jià)(貨幣碼)HALB100-100GG-25000144.000